Using Standby for cloning
OracleDoc gave me a great idea (in that 'why RAC' thread) that I had not thought about. Taking my standby database and using that for creating a clone!
What am I missing here? I shutdown the standby and scp all the files (online redo, control included) from standby box to qa box - essentially a cold backup copy, rename the instance and opening. Perhap use 9i feature to rename the database (or am i confusing the DBID?). And I'm done.
The standby is 563.15 KMs from production and 'on the wire' with qa and dev.
Re: Using Standby for cloning
Why not just use the duplicate command?
Re: Using Standby for cloning
Quote:
Originally posted by gopi
What am I missing here? I shutdown the standby and scp all the files (online redo, control included) from standby box to qa box - essentially a cold backup copy, rename the instance and opening. Perhap use 9i feature to rename the database (or am i confusing the DBID?). And I'm done.
You would actualy need a controlfile from your primary, not from your standby. Standby's controlfile can not be used for cloning unless you actually want to add another standby database to your DataGuard configuration (ie one primary and several standbys).
This is also a normal method to use standby for daily backups to offload the primary - you back up databfiles on the standby site and controlfile on the primary - that makes a valid and complete backup set.