Creating standby database using data guard.
Current Env:
Oracle 11.2.0.1
ASM
Size 1.7T and growing.
I'm rebuilding a standby database and need to use rman because of a few factors. In the past, I did a file copy create a standby control file config init.ora and it always worked.
We have a database and had the stanby build; but someone issued a flashback and corrupted the standby database.
Because of the size 1.7T and growing and we are now using ASM.
My research is only showing building standby through rman using dupicate database command.
I would like to copy the cold backup to a external drive and ship it to the standby site where I'll do the restore. This is because of time and bandwith required to rebuild the standby will interfere with operaitions for the period the files are being copied.
So what would be the high level steps.
1) get the cold backup
2) create the standby control file
3) ship the data via corrier
4) restore the database
5) and this is where i'm not sure. recover the standby control file - but during the restore of the database the "normal" control file will open and perhaps do a checkpoint. therefore the standby controlfile will be usless.
6) recover the standby database.
Has anyone accomplished this?
As much specifics will be helpful. This system is operational and needs to be done right the first time.
thanks,
-Rob