RAC database administration

Managing a RAC database is nearly identical to managing a standalone database, in terms of creating and administering tablespaces, datafiles, users, and other database operations. Like a standalone database, the RAC database and its instances can be started up and shut down using the startup and shutdown SQL commands. However, the recommended way to administer an Oracle RAC database is to use the Server Control Utility.

Using the Server Control Utility

The Server Control Utility (SRVCTL), srvctl, is a cluster command-line utility that is installed by default on all nodes and is used to administer and manage the RAC database and its associated instances for operations such as start and stop, enable and disable, moving a database and instances across nodes, and adding and removing instances/database. When srvctl is used for some of the operations such as add, remove, enable, disable, and move a database and its instances, the information is stored in the Oracle Cluster...