Hello everyone
We are trying to simulate a DR recovery scenario using the RMAN backups
The idea is to simulate a situation where we have to restore / recover the database on a new server using the latest available backups / last archive log available on TAPE
Source and Target database servers are running Oracle 11g with ASM
Target database is already running ASM instance and the disk group names are same as we have it on the source/production database
Source/production DB server is called PROD1 and target/ DR server is called PRODDR1
Source Database is called APPDB and we would like to restore and recover the database with same name on the target server
We have a few questions
Should we use the typical RMAN restore and recovery process (first restore the SPFILE from the backup then restore the control files from the backup and then recover the database)
OR
Should we use the RMAN DUPLICATE DATABASE process?
What is the difference between the 2 and which one is better option for our situation?
Also, here are the steps we think we would need to perform
First create directories on the target server such as adump/bdump/hdump etc
Then
a. Create RMAN backup of source db and archive logs
b. Copy that backup to a location on the target server
c. Create a pfile from spfile on the source server and copy that over to target server
d. Create a password file useing orapwd on the target server
e. export ORACLE_SID=APPDB on the target server
Now if we use the typical RMAN restore and recovery, we can just startup force the instance
and then
1. Restore SPFILE file from the RMAN auto backup
2. Startup nomount
3. Restore controlfile from RMAN auto backup
4. Mount the database
5. Recover database (using until cancel perhaps or until last available SEQ number etc)
6. Open database with resetlogs
Question:
When we restore the SPFILE and CONTROFILE from the RMAN autobackup, would it create the required directories under ASM (e.g. +DATA/appdb and +FRA/appdb) automatically? or before we restore the spfile and controlfiles we need to use the asmcmd utility and create the appdb directory under +DATA and +FRA BEFORE we start the recovery process?
If we use the backup based duplication, then
1. Do we need to create a pfile from spfile before we can begin?
2. IF YES, What is the minimum requirements / settings we need to have in that PFILE that we would use to startup nomount the instance
3. Startup nomount pfile='location of the pfile we just created / modified
4. rman auxialiary /
5. duplicate database to 'appdb' backup location 'location on the target server where we copied the RMAN backup from source db';
Thanks in advance for your assistance with this