Some times you may notice to stop all the databases running on oracle rac cluster as soon as possible, and assume there are 50+ databases are running on same host, then manually stoping all the databases will take lots of time.
So, Stopping all RAC databases running on an ORACLE_HOME at once and saving the state before shutting them down is really helpful when you are doing patching on a server.
In my case I have databases running on some nodes and not the others, it’s getting complicated to keep track of which database is running where. With this method you will shutdown all databases at once and keep track of the databases running on that node before shutting them down.
Stopping all RAC databases of an ORACLE_HOME
This command will stop all databases running on the ORACLE_HOME specified and save the state before the shutdown in a state file.
$ srvctl stop home -oraclehome
/u01/app/oracle/product/12.1.0/dbhome_1 -node node1 -statefile
/tmp/node1_stop.dmp
Starting all RAC databases of an ORACLE_HOME
This command uses a state file to restart all databases previously running on a node.
srvctl start home -oraclehome
/u01/app/oracle/product/12.1.0/dbhome_1 -node node1 -statefile
/tmp/node1_stop.dmp
No comments:
Post a Comment