Skip to Main Content

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!

RMAN restore:Disaster scenario, only tape backups, to new server?

cayenneNov 4 2010 — edited Nov 19 2010
Hello all,

I'm looking to see if anyone can give some links to a good guide, or give me some general directions to research for a RMAN restore to a new server.

I've seen examples out there, but most of them assume just cloning, and the original server is up and running, and you can transfer datafiles, spfiles, etc. around.

I'm wanting to attempt this like a complete disaster situation. I want to assume my prod server is gone. I have tape backups from RMAN, I do set the option for control and spfile to be backed up each time.

I do hourly archive backups. I do daily level one backups. I do weekly level incremental backups. I have a 5 day retention window.

I have a 5 node RAC cluster for PROD. I have a 2 node RAC cluster for NEW. My tape can be reached by both machines....rman works between the servers.

So, what I'm wanting to do, is from tape, user RMAN on the NEW server, and recreate INSTANCE1.

Both servers use ASM. (different SANS on each box, no mixing here)

On NEW server, it is sitting there with clustering running, and database binaries installed (no instances yet), and has been patched to exact same level as PROD.

Of course my PROD server is going to be chugging along during this, so I don't want to do anything that will mess up the current backups, just want to use them, but leave them on tape. While I am pretending that PROD is gone, it is still there and I don't want to do anything that would mess with it during this exercise.

So, it is from here I'm wanting to start.

I'm a RMAN newb....wanting to learn. Does anyone have any good links they could send with a guide of some sort for me to follow and learn from?

Tips? I don't expect a step by step guide from anyone here (ok, if you want to I won't argue), but really just some over view and key points I need to look for while I research how to do this.

Thank you in advance,

cayenne
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 17 2010
Added on Nov 4 2010
4 comments
410 views