Oracle Dataguard has his own command-line dgmgrl<\/i> to check the whole dataguard configuration status.
\nAt least you should check that the show configuration<\/i> command returns SUCCESS<\/b>.<\/p>\n
This is an hypothetic script:<\/p>\n
\r\n#!\/bin\/bash\r\nexport ORACLE_HOME=\/u1\/app\/oracle\/product\/10.2.0\r\nexport ORACLE_SID=orcldg\r\nresult=`echo \"show configuration;\" | \\\r\n $ORACLE_HOME\/bin\/dgmgrl sys\/strongpasswd | \\\r\n grep -A 1 \"Current status for\" | grep -v \"Current status for\"`\r\nif [ \"$result\" = \"SUCCESS\" ] ; then\r\n exit 0\r\nelse\r\n exit 1\r\nfi\r\n<\/pre>\nAnother script should check for the gap between production online log and the log stream received by the standby database. This can be accomplished with v$managed_standby view.
\nThe Total Block Gap between production and standby can be calculated this way:
\nSum all blocks from v$archived_logs where seq# between Current Standby Seq# and Current Production Seq#. Then add current block# of the production LGWR process and subtract current block# from RFS standby process. This gives you total blocks even if there is a log sequence gap between sites.
\nThis is NOT the gap of online log APPLIED to the standby database. THIS IS THE GAP OF ONLINE LOG TRANSMITTED TO THE STANDBY RFS PROCESS and can be used to monitor your dataguard transmission from production to disaster recovery environment.<\/p>\n
This is an excerpt of such script (please take care that it does not check against RFS failures, so it can fails when RFS is not alive):<\/p>\n
\r\n#!\/u1\/app\/oracle\/product\/10.2.0\/perl\/bin\/perl -w\r\nuse DBI;\r\nuse DBD::Oracle qw(:ora_session_modes);\r\n# DB connection #\r\nmy $prod = \"orclprod\";\r\nmy $stby = \"orcldr\";\r\nmy $prodh;\r\nunless ($prodh = DBI->connect('dbi:Oracle:'.$prod,\r\n 'sys', 'strongpassword',\r\n {PrintError=>0, AutoCommit => 0,\r\n ora_session_mode => ORA_SYSDBA})) {\r\n print \"Error connecting to DB: $DBI::errstr\\n\";\r\n exit(1);\r\n}\r\n$prodh->{RaiseError}=1;\r\n\r\nmy $stbyh;\r\nunless ($stbyh = DBI->connect('dbi:Oracle:'.$stby,\r\n 'sys', 'strongpassword',\r\n {PrintError=>0, AutoCommit => 0,\r\n ora_session_mode => ORA_SYSDBA})) {\r\n print \"Error connecting to DB: $DBI::errstr\\n\";\r\n $prodh->disconnect;\r\n exit(1);\r\n}\r\n$stbyh->{RaiseError}=1;\r\n\r\nmy $sth;\r\n### query prod\r\n$sth = $prodh->prepare( < execute();\r\nmy ($psequence, $pblock) = $sth->fetchrow_array();\r\n$sth->finish();\r\n### query stdby\r\n$sth = $stbyh->prepare( < <\/eosql>execute();\r\nmy ($ssequence, $sblock) = $sth->fetchrow_array();\r\n$sth->finish();\r\n\r\nprintf (\"PROD : %10d %10d\\n\", $psequence, $pblock);\r\nprintf (\"STANDBY: %10d %10d\\n\", $ssequence, $sblock);\r\n\r\n$sth = $stbyh->prepare( < <\/eosql>execute();\r\nmy ($blockgap) = $sth->fetchrow_array();\r\n$sth->finish();\r\nprintf (\"%-10d blocks gap\\n\", $blockgap);\r\n\r\n$stbyh->disconnect;\r\n$prodh->disconnect;\r\n<\/eosql><\/pre>\nAny comment is appreciated!<\/p>\n","protected":false},"excerpt":{"rendered":"
Oracle Dataguard has his own command-line dgmgrl to check the whole dataguard configuration status. At least you should check that the show configuration command returns SUCCESS. This is an hypothetic script: #!\/bin\/bash export ORACLE_HOME=\/u1\/app\/oracle\/product\/10.2.0 export ORACLE_SID=orcldg result=`echo “show configuration;” | … Continue reading