Problem Description
I switchover from primary to standby successfully but when I swithback to primary I got following error:
DGMGRL> show configuration
Configuration
Name: DBAPRD.intdata.com
Enabled: YES
Protection Mode: MaxPerformance
Databases:
DBALC - Primary database
DBAPRD - Physical standby database
DBADR - Physical standby database
Fast-Start Failover: DISABLED
Current status for "DBAPRD.intdata.com":
SUCCESS
DGMGRL> switchover to 'DBAPRD'
DGMGRL> 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 "DBALC"
DGMGRL> show configuration
Configuration
Name: DBAPRD.intdata.com
Enabled: YES
Protection Mode: MaxPerformance
Databases:
DBALC - Primary database
DBAPRD - Physical standby database
DBADBDR - Physical standby database
Fast-Start Failover: DISABLED
Current status for "DBAPRD.intdata.com":
Warning: ORA-16607: one or more databases have failed
Following error was found in alertlog of primary database:
Errors in file /u02/oracle/diag/dbaPRD/diag/rdbms/dbalc/dbaLC/trace/dbaLC_lns1_21171.trc:
ORA-03135: connection lost contact
LGWR: Error 3135 closing archivelog file '(DESCRIPTION=(ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HOST=racprod1-v)(PORT=1540)))(CONNECT_DATA=(SERVICE_NAME=dbaPRD.intdata.com)(SERVER=DEDICATED)))'
Sat Jun 08 19:20:51 2013
Deleted Oracle managed file +dba_FLASH/dbalc/archivelog/2013_04_14/thread_1_seq_130382.8527.812711313
Waiting for all non-current ORLs to be archived...
Waiting for the ORL for thread 1 sequence 136062 to be archived...
Sat Jun 08 19:20:59 2013
ARC3: Archiving not possible: failed standby destinations
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance dbaLC - Archival Error
ORA-16014: log 2 sequence# 136062 not archived, no available destinations
ORA-00312: online log 2 thread 1: '+dba_DATA/dbalc/onlinelog/group_2.311.794395241'
ORA-00312: online log 2 thread 1: '+dba_FLASH/dbalc/onlinelog/group_2.303.794395255'
Errors in file /u02/oracle/diag/dbaPRD/diag/rdbms/dbalc/dbaLC/trace/dbaLC_arc3_14518.trc:
ORA-16014: log 2 sequence# 136062 not archived, no available destinations
ORA-00312: online log 2 thread 1: '+dba_DATA/dbalc/onlinelog/group_2.311.794395241'
ORA-00312: online log 2 thread 1: '+dba_FLASH/dbalc/onlinelog/group_2.303.794395255'
......
ORA-16416 signalled during: ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN...
Cause:
The target standby database in the broker operation did not have all the redo logs from the primary database.
Solution:
I tried "alter system swith logfile" but it didnt' work.
Restart primary database solve the problem.
Conclusion
Before swithover , run a few log switchover to make sure log can ship to standby.
Saturday, June 8, 2013
switchover failed with ORA-16775: target standby database in broker operation has potential data loss
Labels:
Dataguard
Subscribe to:
Post Comments (Atom)
I encountered with this and the reason was that I didnot run command ( switchover to ..) in new standby database(old primary)
ReplyDelete