Re: Create controlfile for standby database

Sami,

Again, I have no experience with DG/RAC, maybe that requires a shutdown, althuogh I don't see why, as far as I understand the concepts of RAC.

This said, I use vanilla 'alter tablespace begin backup' and '... end backup' commands in my scripts, and create a hot backup by scp-ing the datafiles to the standby site. After the backup I create the standby controlfile. All without shutting down the database.

DG is about high availability. There are situations when you have to re-instantiate a standby, e.g. after a failover, or a HW-error causing loss of datafiles on the standby. Needing to shutdown the primary to create the standby is unacceptable, because it interrupts your service. You are setting up data guard to prevent interruptions, not to cause them. Therefore, avoid the cold backup, and instantiate with a hot backup, either through vanilla scp-copy or RMAN.

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===

On Sun, 2005-08-28 at 18:20 -0400, Sami Seerangan wrote:

> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96653/create_ps.htm#58008
>
> Oracle document says,
> 1)Startup
> 2)Create standby control file.
>
> When we STARTUP the SCN would be increased. This will make
> inconsistency between the cold backup and the creation of standby
> controlfile.
> Isn't it? Or Am I missing something here?
>
> I know we can bring up the datafile header SCN to same as Standby
> control file SCN by applying archive logs, but rather I can make
> consistent image between my Backup and Standby controlfile by starting
> my database in Mount mode.
>
>

--
http://www.freelists.org/webpage/oracle-l