Oracle Dataguard issue
- From: Jack van Zanen <jack@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 13 May 2010 11:14:14 +1000
Hi All,
Oracle 9.2.0.7 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:
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH (completes
succesfully)
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
Other related posts:
