Re: Using Standby for cloning
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.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?