To activate the standby site if the primary site is not reachable.
*****************************************************************************
dgmgrl /
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Sun Aug 9 14:15:22 2026
Version 19.31.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected to "orcl_stdy"
Connected as SYSDG.
DGMGRL> show configuration ;
Configuration - DG_CONF
Protection Mode: MaxPerformance
Members:
orcl - Primary database
Error: ORA-1034: ORACLE not available <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
orcl_stdy - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
ERROR (status updated 0 seconds ago)
DGMGRL> SHOW DATABASE VERBOSE orcl_stdy;
Database - orcl_stdy
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 172 seconds ago)
Apply Lag: 0 seconds (computed 172 seconds ago)
Average Apply Rate: 61.00 KByte/s
Active Apply Rate: 0 Byte/s
Maximum Apply Rate: 0 Byte/s
Real Time Query: OFF
Instance(s):
orcls
Database Warning(s):
ORA-16857: member disconnected from redo source for longer than specified threshold
Properties:
DGConnectIdentifier = 'orcldstdy'
ObserverConnectIdentifier = ''
FastStartFailoverTarget = 'orcl'
PreferredObserverHosts = ''
LogShipping = 'ON'
RedoRoutes = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyLagThreshold = '30'
TransportLagThreshold = '30'
TransportDisconnectedThreshold = '30'
ApplyParallel = 'AUTO'
ApplyInstances = '0'
StandbyFileManagement = ''
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '0'
LogArchiveMinSucceedDest = '0'
DataGuardSyncLatency = '0'
LogArchiveTrace = '0'
LogArchiveFormat = ''
DbFileNameConvert = ''
LogFileNameConvert = ''
ArchiveLocation = ''
AlternateLocation = ''
StandbyArchiveLocation = ''
StandbyAlternateLocation = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
LogXptStatus = '(monitor)'
SendQEntries = '(monitor)'
RecvQEntries = '(monitor)'
UserManagedParams = ''
HostName = 'oracentd19c'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracentd19c)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl_stdy_DGMGRL)(INSTANCE_NAME=orcls)(SERVER=DEDICATED)))'
TopWaitEvents = '(monitor)'
SidName = '(monitor)'
Log file locations:
Alert log : /u01/app/oracle/diag/rdbms/orcl_stdy/orcls/trace/alert_orcls.log
Data Guard Broker log : /u01/app/oracle/diag/rdbms/orcl_stdy/orcls/trace/drcorcls.log
Database Status:
WARNING
*********************************************************************************************************************
DGMGRL> FAILOVER TO orcl_stdy; <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
Performing failover NOW, please wait...
Failover succeeded, new primary is "orcl_stdy"
Configuration Status:
SUCCESS (status updated 46 seconds ago)
DGMGRL> show configuration ;
Configuration - DG_CONF
Protection Mode: MaxPerformance
Members:
orcl_stdy - Primary database
orcl - Physical standby database (disabled)
ORA-16661: the standby database needs to be reinstated
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 38 seconds ago)
DGMGRL> DGMGRL> [oracle@oracentd19c ~]$ sqlme
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Aug 9 14:27:47 2026
Version 19.31.0.0.0
Copyright (c) 1982, 2026, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.31.0.0.0
[-PRIMARY-]sys@ORCL_STDY> SELECT db_unique_name, database_role, open_mode, switchover_status
FROM v$database; 2
DB_UNIQUE_NAME DATABASE_ROLE OPEN_MODE
------------------------------ ---------------- --------------------
SWITCHOVER_STATUS
--------------------
orcl_stdy PRIMARY READ WRITE
NOT ALLOWED
[-PRIMARY-]sys@ORCL_STDY>
SELECT db_unique_name,
database_role,
open_mode,
resetlogs_change#,
resetlogs_time
FROM v$database;
DB_UNIQUE_NAME DATABASE_ROLE OPEN_MODE
------------------------------ ---------------- --------------------
RESETLOGS_CHANGE# RESETLOGS
----------------- ---------
orcl_stdy PRIMARY READ WRITE
4771662 09-AUG-26
[-PRIMARY-]sys@ORCL_STDY> SELECT current_scn FROM v$database;
CURRENT_SCN
-----------
4777481
[-PRIMARY-]sys@ORCL_STDY> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.31.0.0.0
On failed node
SQL> startup ;
ORACLE instance started.
Total System Global Area 6710883904 bytes
Fixed Size 9193024 bytes
Variable Size 1677721600 bytes
Database Buffers 5016387584 bytes
Redo Buffers 7581696 bytes
Database mounted.
ORA-16649: possible failover to another database prevents this database from
being opened
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> select * from dual;
ADDR INDX INST_ID CON_ID D
---------------- ---------- ---------- ---------- -
0000000015940ADC 0 1 0 X
Database Status:
DISABLED - ORA-16623: member detected role change
DGMGRL> DGMGRL> [oracle@oracent19c ~]$
[oracle@oracent19c ~]$
[oracle@oracent19c ~]$
[oracle@oracent19c ~]$
[oracle@oracent19c ~]$ !sql
sqlme
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Aug 9 14:27:37 2026
Version 19.31.0.0.0
Copyright (c) 1982, 2026, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.31.0.0.0
SQL> SELECT db_unique_name, database_role, open_mode, switchover_status
FROM v$database; 2
DB_UNIQUE_NAME DATABASE_ROLE OPEN_MODE
------------------------------ ---------------- --------------------
SWITCHOVER_STATUS
--------------------
orcl PRIMARY MOUNTED
NOT ALLOWED
SQL> SELECT flashback_on
FROM v$database; 2
FLASHBACK_ON
------------------
YES
[oracle@oracentd19c ~]$ dgmgrl /
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Sun Aug 9 14:34:37 2026
Version 19.31.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected to "ORCL_STDY"
Connected as SYSDG.
DGMGRL> SHOW DATABASE VERBOSE orcl
Database - orcl
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: (unknown)
Apply Lag: (unknown)
Average Apply Rate: (unknown)
Active Apply Rate: (unknown)
Maximum Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
orcl
Properties:
DGConnectIdentifier = 'orcl'
ObserverConnectIdentifier = ''
FastStartFailoverTarget = 'orcl_stdy'
PreferredObserverHosts = ''
LogShipping = 'ON'
RedoRoutes = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyLagThreshold = '30'
TransportLagThreshold = '30'
TransportDisconnectedThreshold = '30'
ApplyParallel = 'AUTO'
ApplyInstances = '0'
StandbyFileManagement = ''
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '0'
LogArchiveMinSucceedDest = '0'
DataGuardSyncLatency = '0'
LogArchiveTrace = '0'
LogArchiveFormat = ''
DbFileNameConvert = ''
LogFileNameConvert = ''
ArchiveLocation = ''
AlternateLocation = ''
StandbyArchiveLocation = ''
StandbyAlternateLocation = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
LogXptStatus = '(monitor)'
SendQEntries = '(monitor)'
RecvQEntries = '(monitor)'
UserManagedParams = ''
HostName = 'oracent19c'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracent19c)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl_DGMGRL)(INSTANCE_NAME=orcl)(SERVER=DEDICATED)))'
TopWaitEvents = '(monitor)'
SidName = '(monitor)'
Log file locations:
(Unknown)
Database Status:
DISABLED - ORA-16661: the standby database needs to be reinstated
on old primary
SQL> startup ;
ORACLE instance started.
Total System Global Area 6710883904 bytes
Fixed Size 9193024 bytes
Variable Size 1677721600 bytes
Database Buffers 5016387584 bytes
Redo Buffers 7581696 bytes
Database mounted.
ORA-16649: possible failover to another database prevents this database from
being opened
on failed node !!
SQL> startup ;
ORACLE instance started.
Total System Global Area 6710883904 bytes
Fixed Size 9193024 bytes
Variable Size 1677721600 bytes
Database Buffers 5016387584 bytes
Redo Buffers 7581696 bytes
Database mounted.
ORA-16649: possible failover to another database prevents this database from
being opened
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> select * from dual;
ADDR INDX INST_ID CON_ID D
---------------- ---------- ---------- ---------- -
0000000015940ADC 0 1 0 X
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.31.0.0.0
from active node !!!!!!!!!! from new prod REINSTATE DATABASE orcl
DGMGRL> REINSTATE DATABASE orcl;
Reinstating database "orcl", please wait...
Reinstatement of database "orcl" succeeded
DGMGRL> SHOW DATABASE VERBOSE orcl
Database - orcl
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 1 second ago)
Apply Lag: 0 seconds (computed 1 second ago)
Average Apply Rate: 979.00 KByte/s
Active Apply Rate: 0 Byte/s
Maximum Apply Rate: 0 Byte/s
Real Time Query: OFF
Instance(s):
orcl
Properties:
DGConnectIdentifier = 'orcl'
ObserverConnectIdentifier = ''
FastStartFailoverTarget = 'orcl_stdy'
PreferredObserverHosts = ''
LogShipping = 'ON'
RedoRoutes = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyLagThreshold = '30'
TransportLagThreshold = '30'
TransportDisconnectedThreshold = '30'
ApplyParallel = 'AUTO'
ApplyInstances = '0'
StandbyFileManagement = ''
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '0'
LogArchiveMinSucceedDest = '0'
DataGuardSyncLatency = '0'
LogArchiveTrace = '0'
LogArchiveFormat = ''
DbFileNameConvert = ''
LogFileNameConvert = ''
ArchiveLocation = ''
AlternateLocation = ''
StandbyArchiveLocation = ''
StandbyAlternateLocation = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
LogXptStatus = '(monitor)'
SendQEntries = '(monitor)'
RecvQEntries = '(monitor)'
UserManagedParams = ''
HostName = 'oracent19c'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracent19c)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl_DGMGRL)(INSTANCE_NAME=orcl)(SERVER=DEDICATED)))'
TopWaitEvents = '(monitor)'
SidName = '(monitor)'
Log file locations:
Alert log : /u01/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log
Data Guard Broker log : /u01/app/oracle/diag/rdbms/orcl/orcl/trace/drcorcl.log
Database Status:
SUCCESS
DGMGRL> show configuration ;
Configuration - DG_CONF
Protection Mode: MaxPerformance
Members:
orcl_stdy - Primary database
orcl - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 44 seconds ago)
on new standby !!!
SELECT recovery_mode
FROM v$archive_dest_status
WHERE dest_id = 1; 2 3
RECOVERY_MODE
----------------------------------
MANAGED REAL TIME APPLY
Sunday, 9 August 2026
oracle standby To activate the standby site if the primary site is not reachable.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment