Lost latest RMAN backup

From: Gary <rooty_hill2002_at_yahoo.com.au>
Date: 14 Nov 2004 21:33:13 -0800
Message-ID: <171bd226.0411142133.670ea042@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 Received on Sun Nov 14 2004 - 23:33:13 CST