I need your advice about a project I am doing now:
I have 7 RAC 11gR2 nodes on Redhat Linux. We are backing up the database (one instance node) using incremental updated backups via RMAN, and then we move the backups to tape. I autobackup the controlfile and spfile with RMAN and my retention window is 60 days. I am also, running md_backup every night to backup ASM metadata.
until now everything is ok.
But, what happens if I completely loose the 7 nodes RAC? if all the servers are down and completely lost?
I have to think about the best, easier solution to restore from tapes and then restore/recover my database (database + ASM) to a dedicated single instance on a separated server located in another data center.
could you share your experience and advice the step by step of doing it?
the example just speak about File System.
What about ASM scenario ? It's the same?
I think it's difficult with ASM since I have to create ASM diskgroups and disks in the new server and the complicated part is to set the new filenames (datafiles, controlfiles, spfiles ...)
Also, don't forget I am in RAC so what about undo restore and redolog files restore... these files are per thread ...
Edited by: 868469 on Jun 27, 2011 10:56 AM
Maybe the steps could be:
1- Install Oracle 11gR2 software in the new server. with Fast recovery area, Archivelog mode configured. With File system management Storage.
2- Configure MML in the new server and the EMC client.
3- From the EMC server choose which Fast recovery Area backup to restore. Restore of Fast recovery Area, Archive logs and Spfile/Control file autobackups
4- Restore the Fast recovery Area backup tape to the new fast recovery area.Don't know how do it since my RAC 11Gr2 is using ASM and my new server is using File system for storage
5- restore the pfile or spfile and startup nomout. Don't know how do it since my RAC 11Gr2 is using ASM and my new server is using File system for storage
6- restore the controlfile from the backup. Don't know how do it since my RAC 11Gr2 is using ASM and my new server is using File system for storage
7- startup mount and restore and recover the datafiles. Don't know how to do it since my RAC 11Gr2 is using ASM and my new server is using File system for storage.
8- open with resetlogs
As you can see my concern is ASM in my 11gR2 RAC and File System in my new 11gR2 server.
What do you think about the procedure?¿
For sure I will test it, but, I need just your opinion.
Edited by: oracle on Jun 28, 2011 4:49 AM