DG Status

0

— From Dgmgrl side:
# dgmgrl /DGMGRL> show configuration verbose
DGMGRL> show database verbose <primary_db>
DGMGRL> show database verbose <stby_db>
DGMGRL> show database verbose <primary_db> statusreport
DGMGRL> show database verbose <stby_db> statusreport
DGMGRL> show database verbose <primary_db> inconsistentproperties
DGMGRL> show database verbose <stby_db> inconsistentproperties

— From the agent side:
# /opt/oracle/dcs/bin/dbcli list-databases
# /opt/oracle/dcs/bin/dbcli describe-database -i <DB id >
# /opt/oracle/dcs/bin/dbcli list-dgconfigs
# /opt/oracle/dcs/bin/dbcli list-dataguardstatus

— From Database side:
set lines 1000 line size 1000 pages 1000 pagesize 1000
select status from v$instance
select name,open_mode, database_role, protection_mode, switchover_status,db_unique_name from v$database;

Share.

About Author

Leave A Reply