Oracle Dataguard issue

From: Jack van Zanen <>
Date: Thu, 13 May 2010 11:14:14 +1000
Message-ID: <>

Hi All,

Oracle on AIX
Oracle dataguard setup without the broker.

We are doing some testing and have the following scenario.

Primary database:
put all tablespaces in begin backup mode. copy all datafiles to standby location
create standby controlfile (note we did not do end backup first)

Standby database:
copy the standby controlfile to the correct locations set all required parameters in the initSID.ora startup nomount
alter database mount standby database
recover managed standby database disconnect Check the alert log and make sure that the managed recovery is started correctly (which it was as logswitches from primary came through)

Simulate a network failure by setting the log_archive_dest_state_2 to defer on primary. (note primary is still in begin backup mode)

When we try to activate the standby database:

Tried to activate Standby, gets error, ORA-01194, file needs recovery.

We tried several things but other than making sure the standby controlfile is created after the end backup commands have been issued we have not been able to open this database up.

We shipped more logfiles from primary , even after issuing end backup command on primary and tried opening. No luck We issued end backup on standby database and try to activate. No luck We recreated the controlfile on standby. This sets status to primary but still can not be recovered/opened.

Anybody have any insight how we can recover this?

Jack van Zanen

This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation

-- Received on Wed May 12 2010 - 20:14:14 CDT

Original text of this message