i want to code a script which should track the status of standby database . if standby database is down then what are the methods and ways to itrack the status when ever standby database goes dwon . my oracle database version is 11.2 and operating system is linux
you can use EM monitoring if you have grid, or else write a script to check that checks connectivity to the DB. Again you may want to know whether apply is running, how much te standby is lagging etc, you can use dgmgrl and the views like V$archived_log, v$managed_standby to check that.