Oracle Dataguard : dgmgrl - various commands

<b>Start dgmgrl </b> export ORACLE_SID=dbdg; . oraenv; dgmgrl sys/<password> <b>Check the configuration status<br /></b> SHOW CONFIGURATION; SHOW DATABASE VERBOSE 'North_Sales' SHOW DATABASE 'North_Sales'; SHOW DATABASE 'North_Sales' 'StatusReport'; SHOW DATABASE 'North_Sales' 'InconsistentProperties'; SHOW DATABASE 'North_Sales' 'InconsistentLogXptProps'; Change properties EDIT DATABASE 'DR_Sales' SET PROPERTY 'LogArchiveFormat'='log_%t_%s_%r_%d.arc'; EDIT DATABASE 'DR_Sales' SET STATE='READ-ONLY'; <b>Create/enable configuration<br /></b> CREATE CONFIGURATION 'DRSolution' AS PRIMARY DATABASE IS 'North_Sales' CONNECT IDENTIFIER IS North_Sales.foo.com; ADD DATABASE 'DR_Sales' AS CONNECT IDENTIFIER IS DR_Sales.foo.com MAINTAINED AS PHYSICAL; SHOW CONFIGURATION; ENABLE CONFIGURATION; <b>Stop transmit of dbs from primary <br /></b> EDIT DATABASE North_Sales SET STATE=LOG-TRANSPORT-OFF <b>Temporarily stop broker managing and monitoring a standby database.<br /></b> DISABLE DATABASE 'DR_Sales'; Switchover SWITCHOVER TO DR_Sales; SHOW CONFIGURATION; <b>Manual Failover<br /></b> FAILOVER TO "DR_Sales"; SHOW CONFIGURATION;