Re: SAP Oracle Database Restore
Date: Mon, 14 Mar 2011 14:41:01 -0500
Message-ID: <AANLkTi=NqUq8EZ5pn+s5KHskF4n=oUs3Zd3hcmoZ2MeH_at_mail.gmail.com>
We were able to use the command below to restore the database.
brrestore -b bebsvyuz.anf -m full
It worked!
We did not scan the tape but we did restore the client file index via -
*nsrck -L7 -t "10/22/2009" client_server_name*
Thanks,
Roger Xu
On Sat, Feb 26, 2011 at 6:08 PM, Jared Still <jkstill_at_gmail.com> wrote:
> On Fri, Feb 25, 2011 at 8:08 AM, Roger Xu <wellmetus_at_gmail.com> 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
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 14 2011 - 14:41:01 CDT