The procedure for shutting down Oracle RAC instances is identical to shutting down instances in noncluster Oracle databases, with the following exceptions:
In Oracle RAC, shutting down one instance does not interfere with the operation of other running instances.
To shut down an Oracle RAC database completely, shut down every instance that has the database open or mounted.
After a NORMAL
or IMMEDIATE
shutdown, instance recovery is not required. Recovery is required, however, after you issue the SHUTDOWN ABORT
command or after an instance terminates abnormally. An instance that is still running performs instance recovery for the instance that shut down. If no other instances are running, the next instance to open the database performs instance recovery for any instances needing it.
Using the SHUTDOWN TRANSACTIONAL
command with the LOCAL
option is useful to shut down a particular Oracle RAC database instance. Transactions on other instances do not block this operation. If you omit the LOCAL
option, then this operation waits until transactions on all other instances that started before you ran the SHUTDOWN
command either commit or rollback, which is a valid approach, if you intend to shut down all instances of an Oracle RAC database.
Note:
SHUTDOWN TRANSACTIONAL
and SHUTDOWN TRANSACTIONAL LOCAL
both perform the same action on a nonclustered database but the two commands are different on an Oracle RAC database.
See Also:
Oracle Database Concepts for more information about shutting down a database
Use SRVCTL to shut down an Oracle RAC database or database instance. The respective SRVCTL commands (srvctl stop database
or srvctl stop instance
) provide shutdown options to perform an optimized transactional shutdown. Use the TRANSACTIONAL
stop option with the srvctl stop database
command and the TRANSACTIONAL LOCAL
stop option with the srvctl stop instance
command.
See Also:
Oracle Database Administrator's Guide for more information about shutting down Oracle databases