DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: RMAN restore using different backupsets

Hybrid View

  1. #1
    Join Date
    Oct 2002
    Location
    Singapore
    Posts
    49

    Smile RMAN restore using different backupsets

    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
    Regards
    CF

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    use the set until command to say the point when you want to restore to, oracle will choose the correct backupset

  3. #3
    Join Date
    Oct 2002
    Location
    Singapore
    Posts
    49

    Unhappy

    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.
    Regards
    CF

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    keep applying the logs until you can do CANCEL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width