Scripts to shutdown standby and primary on different servers
We have a dataguard environment configure with Oracle 10g R2. The configuration is as follow :
ServerA, Primary Database
ServerB, Logical Standby Database
From time to time, we need to shutdown both standby and primary to do a backup. At the moment we are doing it manually.
We need some scripts to automate this task. I mean, shutdown the primary database on ServerA then shutdown standby database on ServerB.
The reason we don't use the standby to do the backup is because is Logical.