srvctl relocate database

The srvctl relocate database command initiates the relocation of an Oracle RAC One Node database from one node to another node. This command also cleans up after a failed relocation.

The srvctl relocate database command can only be used for relocating Oracle RAC One Node databases.

Syntax and Parameters

Use the srvctl relocate database command with one of these syntax models:

srvctl relocate database -db db_unique_name [-node target_node]
     [-timeout timeout] [-stopoption NORMAL] [-verbose]

srvctl relocate database -db db_unique_name -abort [-revert] [-verbose]

Table A-112 srvctl relocate database Parameters

Parameter Description 
-db db_unique_name

Unique name of the database to relocate.

 
-node target

Target node to which to relocate the Oracle RAC One Node database.

Note: You must supply this parameter if you are relocating an administrator-managed Oracle RAC One Node database.

 
-timeout timeout

Online database relocation timeout, in minutes, for Oracle RAC One Node databases. The default is 30.

 
-stopoption NORMAL

Use this parameter to shut down an existing database instance using SHUTDOWN NORMAL instead of the default of SHUTDOWN TRANSACTIONAL LOCAL for a primary database or SHUTDOWN IMMEDIATE for a standby database.

 
-abort

Abort failed online database relocation.

 
-revert

Removes the target node of a failed online relocation request from the candidate server list of an administrator-managed Oracle RAC One Node database.

 
-verbose

Verbose output.

Usage Notes

  • If the Oracle RAC One Node database you want to relocate is not running, then the command returns an error.

  • If another online database relocation is active for this Oracle RAC One Node database, then the command returns an error.

  • If an online database relocation for this Oracle RAC One Node database has failed and the target nodes are not the same for either relocation, then the command returns an error instructing you to abort the failed online database relocation and then initiate a new one.

  • If an online database relocation for this Oracle RAC One Node database has failed and the target nodes are the same (or you do not specify the target), then the command attempts to relocate the database.

Example

The following example relocates an administrator-managed Oracle RAC One Node database named rac1 to a server called node7.

srvctl relocate database -db rac1 -node node7