RE: SAP Oracle Database Restore
- From: "Blanchard, William G" <William.Blanchard@xxxxxxxxxxxxx>
- To: <jkstill@xxxxxxxxx>, <wellmetus@xxxxxxxxx>
- Date: Fri, 4 Mar 2011 13:04:17 -0600
You can use RMAN with BRBACKUP/BRRESTORE/BRRECOVER.
WGB
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still
Sent: Saturday, February 26, 2011 6:09 PM
To: wellmetus@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: SAP Oracle Database Restore
On Fri, Feb 25, 2011 at 8:08 AM, Roger Xu <wellmetus@xxxxxxxxx> wrote:
According to the backup log (/oracle/SID/sapbackup/bebsvyuz.anf), the
backup was done on 10/22/2009 and it used 5 tapes.
Any idea? My thoughts is:
Do they *really* want a backup restored from 2009?
I have to ask: Have other backups been made since that time?
1) scan all 5 tapes using "scanner -m" command for media index
(do I need file index?)
2) use brrestore to restore all the oracle data files
3) use brrecover to recover the database
At my previous job I got us off of the BR utilities for backups, and
went to
straight RMAN years ago.
The BR Tools are just a way for SAP folks to make backups and do
recoveries
without having to understand what they are doing.
For DBA's I thought it was just a layer of stuff that got in the way and
required obtuse configuration. Just my opinion maybe, but the BR
tools seem more difficult to configure and use than RMAN.
I realize that doesn't help with your current problem, but if you have
any
say in how backup and recovery takes place in the future...
Re that: were the backups hot backups, or did they go through RMAN?
The BR tools have allowed that for sometime.
You should probably consider getting someone involved that knows
how to work with all of the technologies in question.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
_____________
The information contained in this message is proprietary and/or confidential.
If you are not the intended recipient, please: (i) delete the message and all
copies; (ii) do not disclose, distribute or use the message in any manner; and
(iii) notify the sender immediately. In addition, please be aware that any
message addressed to our domain is subject to archiving and review by persons
other than the intended recipient. Thank you.
_____________
Other related posts:
