Script which sends a mail when failover happens
Hi DBA's
I need a logic to write a shell script which sends a mail whenever failover happens.
Currently I know that whenever failover happens database_role gets changed and scn number will be set 1. using this I can write a script . I am just asking if there is any other better logic using that script can be prepared .?
Thanks