Yes 2009 is better than nothing. BRRESTORE is the only hope now and no RMAN involved. I think my approach works because I was able to restore the offline redo logs. I am waiting on space to restore the datafiles now ... Thanks! On Sat, Feb 26, 2011 at 6:08 PM, Jared Still <jkstill@xxxxxxxxx> wrote: > 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 > >