Re: Lost latest RMAN backup

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 Received on Mon Nov 15 2004 - 06:58:11 CST