Stop/Start all RAC databases at once

Cyrille Modiano

OCP Oracle DBA in Montreal at DBSoft

Latest posts by Cyrille Modiano (see all)

Introduction

Stopping all RAC databases running on an ORACLE_HOME at once and saving the state before shutting them down is really helpfull 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.

Starting all RAC databases of an ORACLE_HOME

This command uses a state file to restart all databases previously running on a node.

 

One thought on “Stop/Start all RAC databases at once

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.