Amazon books

Wednesday, June 19, 2013

DGMGRL> switchover to db11gstb Performing switchover NOW, please wait... Error: ORA-16775: target standby database in broker operation has potential data loss Failed. Unable to switchover, primary database is still "db11g" DGMGRL>


If you got this error below while switching database using Data Guard Broker,

############################
DGMGRL> switchover to db11gstb
Performing switchover NOW, please wait...
Error: ORA-16775: target standby database in broker operation has potential data loss

Failed.
Unable to switchover, primary database is still "db11g"
DGMGRL>
############################

Stop the MRP process at standby database and restart it using current log file:

recover managed standby database cancel;
recover managed standby database using current logfile disconnect from session;


Do the switchover again.

Best Regards,
Paulo Portugal

No comments:

Post a Comment