Stopping, Starting, and Removing Database Instances

From the Oracle Database Cloud Service console, you can stop or start a database instance on a specific compute node. You can also remove a database instance from a compute node.

Topics

Stopping a Database Instance

You can stop individual database instances associated with an Exadata Cloud Service database deployment from the Oracle Database Cloud Service console. When you stop a database instance, the database instance is shut down but remains as a cluster resource that is associated with the compute node.

To stop a database instance:

Open the Oracle Database Cloud Service console.

For detailed instructions, see Accessing the My Services Dashboard and the Oracle Database Cloud Service Console.
In the list, click the name of a database deployment that is associated with the database instance that you want to stop.

The Oracle Database Cloud Service Overview page is displayed. The page contains the list of compute node resources, with a separate action menu () for each entry.
Locate the compute node that hosts the database instance that you want to stop. From the associated action menu, select Stop DB Instance and then confirm the action.

While the database instance is being stopped, the database deployment is placed into a maintenance state. After the database instance is stopped, the associated compute node shows an icon containing a red alert triangle to indicate that the instance is stopped ().

Starting a Database Instance

You can start individual database instances associated with an Exadata Cloud Service database deployment from the Oracle Database Cloud Service console. You can start a previously stopped database instance that is already associated with a compute node. Or, you can also start a database instance on a node that is not associated with the database deployment, which is displayed in the Oracle Database Cloud Service console with a shaded appearance.

Before you start a database instance, particularly on a new node, you should check to ensure that there is sufficient memory available to support the database instance. You can examine a running database instance on another node to determine its memory use and then check the node where you want to start the database instance.

To start a database instance:

Open the Oracle Database Cloud Service console.

For detailed instructions, see Accessing the My Services Dashboard and the Oracle Database Cloud Service Console.
In the list, click the name of a database deployment for which you want to start a database instance.

The Oracle Database Cloud Service Overview page is displayed. The page contains the list of compute node resources, with a separate action menu () for each entry.
Locate the compute node that you want to start the database instance on. From the associated action menu, select Start DB Instance and then confirm the action.

While the database instance is being started, the database deployment is placed into a maintenance state.

Removing a Database Instance

When you remove a database instance, the database instance is removed as a clustered database resource. If the database instance is running, it is automatically shut down before it is removed.

Note:

You cannot remove a database instance if it is the only preferred instance for an Oracle Database service.
You cannot remove a database instance while a backup operation is running on the corresponding compute node.

To remove a database instance:

Open the Oracle Database Cloud Service console.

For detailed instructions, see Accessing the My Services Dashboard and the Oracle Database Cloud Service Console.
In the list, click the name of a database deployment that is associated with the database instance that you want to remove.

The Oracle Database Cloud Service Overview page is displayed. The page contains the list of compute node resources, with a separate action menu () for each entry.
Locate the compute node that contains the database instance that you want to remove. From the associated action menu, select Remove DB Instance and then confirm the action.

While the database instance is being removed, the database deployment is placed into a maintenance state. After the operation is completed, the database instance is removed from the database definition in Oracle Clusterware, and the associated compute node is displayed with a shaded appearance in the Oracle Database Cloud Service console.