Connecting to dgmgrl as a sys
[oracle@ol7-122 admin]$ dgmgrl
DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production
Copyright (c) 2000, 2013, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> show configuration;
not logged on
DGMGRL> connect sys
Password:
Connected as SYSDG.
Showing Configuration
DGMGRL> show configuration
Configuration - DR_AGAP
Protection Mode: MaxPerformance
Members:
agap - Primary database
Error: ORA-12543: TNS:destination host unreachable
standby - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR (status updated 0 seconds ago)
Check the database status.
Check the StatusReport monitorable database property.
DGMGRL> show database 'standby' 'StatusReport';
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT
* WARNING ORA-16858: last communication time from redo source could not be determined
Check the LogXptStatus monitorable database property.
DGMGRL> show database 'standby' 'LogXptStatus';
LOG TRANSPORT STATUS
PRIMARY_INSTANCE_NAME STANDBY_DATABASE_NAME STATUS
Check the InconsistentProperties monitorable database property
DGMGRL> SHOW DATABASE 'standby' 'InconsistentProperties';
INCONSISTENT PROPERTIES
INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE
Failover
DGMGRL> failover to 'standby';
Performing failover NOW, please wait...
Failover succeeded, new primary is "standby"
note: other option is DGMGRL> FAILOVER TO database-name [IMMEDIATE];
Showing configuration
DGMGRL> show configuration;
Configuration - DR_AGAP
Protection Mode: MaxPerformance
Members:
standby - Primary database
agap - Physical standby database (disabled)
ORA-16661: the standby database needs to be reinstated
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 11 seconds ago)
DGMGRL>
for Oracle Database Administrators
