RMAN restore using different backupsets

[feng11]

Hi Gurus,

I am new to RMAN. Have tried backup and restore on a standard configuration. Currently need to restore an old RMAN backup from tape.

Restore latest RMAN backups are simple. But now I need to restore RMAN backups dated a month ago. We have retrieved the media tapes that contains the needed RMAN image files. Doing a RMAN > list backup list a long list of past backups.

1) Is there a way to zoom in on the backupsets based on a date, tag or any parameters?

2) Can I do a RMAN restore selectively on the backupset a month ago?

I have gone thru oracle documenation on RMAN backup and recovery and couldn't find examples or information describing this.

Appreciate any advise and suggestions. Thanks

[davey23uk]

use the set until command to say the point when you want to restore to, oracle will choose the correct backupset

[feng11]

Hi ,

Thanks for the advice. I have use the until SCN parameter to restore my database from tape. But when i tried to

"recover database using backup controlfile until cancel"

it suggest the archive log which i have, and thus applied it.
I tried to issue a CANCEL for the next prompt, but messages says that my system_01.dbf file needs to be more consistent.

The conflict is tat the next archived log message says that the archive log is no longer needed. This could be due to my command at rman

RMAN > restore database until SCN 10000;

How can i proceed to recover my database?

I am really stuck with this for 2 days.

[davey23uk]

keep applying the logs until you can do CANCEL