RMAN Recovery Question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: RMAN Recovery Question

  1. #1
    Join Date
    Jan 2001
    Posts
    515

    RMAN Recovery Question

    We have Solaris 10 and Oracle 10.2.0.3. We want to test the RMAN recovery to another server from tape.

    We plan to restore the hot backup from tape to this other server. Oracle Home will also be copied from tape to this new server. We have a backup of the control file.

    Here are my questions

    1. The database was backed up on prod with a catalog. For the restore I would assume that I would need to restore my control file first and then do I need to recover this database nocatalog from the control file or do I connect to the prod RMAN database? Will this mess up the prod database doing a recovery on another server while the prod database is up and running?

    2. Also, I am assuming I would do a point in time recovery for some time right after the hot backup completed. Is there a way to determine the scn to recover to?

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    You don't need to connect to the prod database.
    You need to have the dbid stored somewhere if you dont connect to the RMAN catalog .
    No it will not touch the prod database at any time.

    Yes there is a function in 10g from which you can scn_to_timestamp and timestamp_to_scn

    But if you know the time to which you want to restore you can use that directly in RMAN using set until time syntax

    regards
    Hrishy

  3. #3
    Join Date
    Jan 2001
    Posts
    515

    Thanks

    Thank you Hrishy.

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