Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Restoring DB to another node and another dbname

DroidDrSep 18 2007 — edited Sep 24 2007

Hi,

I want to restore a database as it was a couple of months ago.
I want to restore it to another node, under another db name. I basically want to do comparisons on certain tables comparing today's data vs the data a couple months ago.

I have the rman backups with control file autobackups.
How do I do this:
- Do I use the duplicate command of RMAN (keep in mind that I need the DB as of 2 months ago)?
- Do I use RMAN commands and somehow rename the DB through that process?

Please advise on the best way to do this!
I am running 10gR2 on win x64 enterprise edition.

Best wishes!

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 22 2007

Added on Sep 18 2007

#performance-availability, #recovery-manager-rman

8 comments

4,155 views