vitalopedrotti_at_yahoo.fr (Vitalis) wrote in message news:<4e6dd3ba.0411150458.3d9d9c91_at_posting.google.com>...
> rooty_hill2002_at_yahoo.com.au (Gary) wrote in message news:<171bd226.0411142133.670ea042_at_posting.google.com>...
> > Hi!
> >
> > For one of my testing databases, I have just lost the latest RMAN
> > backup and I want to restore and recover.
> >
> > Database version : 9.2.0.4
> >
> > Platform : HP-UX 11
> >
> > Database name: reportsq (same as instance name)
> >
> > Archived log mode: Yes
> >
> > Controlfile Autobackup : OFF
> >
> > Archived log and online redo logs: Available
> >
> > Current control file: Available
> >
> > Only user data file: USER01.dbf is missing
> >
> > Datafiles except USER01.dbf: Available
> >
> > Latest RMAN backup: df_11_REPORTS.bus has been deleted.
> >
> > Previous RMAN backup(before the latest one): df_10_REPORTS.bus (not
> > include control file when backup)
> >
> > Can I use df_10_REPORTSQ.bus to restore and recover reportsq in this
> > case, and how?
> >
> > Thanks,
> >
> > Gary
>
> Hi,
>
> If you have the backups of all archived logs produced since backup 10,
> it is possible.
>
> -Run "crosscheck backup;" and "delete expired backup;" (assuming
> automatic channels are correctly configured) to let rman know of the
> missing backup piece.
> -Take the missing datafile offline (if not already in this status),
> and run "restore datafile" & "recover datafile" over this file.
> Finally take the datafile online.
>
> Vitalis
Thanks a lot Vitalis, it worked fine.
Gary
Received on Mon Nov 15 2004 - 21:46:10 CST
