srvctl modify database

Modifies the configuration for a database.

Syntax and Parameters

Use the srvctl modify database command with the following syntax:

srvctl modify database -db db_unique_name [-eval] [-dbname db_name] 
     [-instance instance_name] [-oraclehome oracle_home] [-user user_name] 
     [-server server_list] [-timeout timeout] [-domain db_domain] 
     [-spfile spfile] [-pwfile password_file_path]
     [-role {PRIMARY|PHYSICAL_STANDBY|LOGICAL_STANDBY|SNAPSHOT_STANDBY}]
     [-startoption start_options] [-stopoption stop_options] 
     [-policy {AUTOMATIC | MANUAL | NORESTART}]
     [-serverpool "server_pool_list" [-node node_name]] 
     [-pqpool pq_server_pools] [{-diskgroup "diskgroup_list" | -nodiskgroup}]
     [-acfspath "acfs_path_list"] [-force]

Table A-77 srvctl modify database Parameters

Parameter Description
-db db_unique_name

Unique name for the database.

-eval

Use this parameter to hypothetically evaluate the impact of the command on the system.

-dbname db_name

Name of the database (as specified by the DB_NAME initialization parameter), if it is different from the database unique name specified with the -database parameter.

-instance instance_name

Instance name prefix; this parameter is required for administrator-managed Oracle RAC One Node databases.

-oraclehome oracle_home

Path for the Oracle home for the database.

-user user_name

The name of the user that owns the Oracle home directory.

Note: If you specify the -user parameter, you must run this command in privileged mode.

-server "server_list"

List candidate servers for Oracle RAC One Node databases.

Notes: You can use this parameter only with administrator-managed Oracle RAC One Node databases. If your Oracle RAC One Node database is policy managed, you cannot use this parameter.

-timeout timeout

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

-domain db_domain

Specify a domain for the database.

Note: If the database has the initialization parameter DB_DOMAIN set, then you must specify this parameter.

-spfile spfile

The full path to the location of the database server parameter file in an Oracle ASM disk group.

-pwfile password_file_path

The full path to the location of the password file in an Oracle ASM disk group.

-role [PRIMARY | PHYSICAL_STANDBY
 | LOGICAL_STANDBY
 | SNAPSHOT_STANDBY]

Role of the database in an Oracle Data Guard configuration role (PRIMARY, PHYSICAL_STANDBY, LOGICAL_STANDBY, or SNAPSHOT_STANDBY).

-startoption start_options

Startup options for the database, such as OPEN, MOUNT, or NOMOUNT.

Notes:

  • For multi-word startup options, such as read only and read write, separate the words with a space and enclose in double quotation marks (""). For example, "read only".

  • When performing a switchover in an Oracle Data Guard configuration, the -startoption for a standby database that becomes a primary database is always set to OPEN after the switchover.

See Also: SQL*Plus User's Guide and Reference for more information about startup options

-stopoption stop_options

Stop options for the database, such as NORMAL, TRANSACTIONAL, IMMEDIATE, or ABORT.

See Also: SQL*Plus User's Guide and Reference for more information about shutdown options

-policy [AUTOMATIC
 | MANUAL | NORESTART

Management policy for the database resource.

-serverpool "server_pool_list"

A comma-delimited list of the names of server pools to use for a policy-managed database.

Notes:

  • If the database you are modifying is administrator managed, then this parameter changes it to be policy managed, in addition to changing all the database's services to run as uniform services in the specified server pool. You can specify only one server pool for converting an administrator-managed database to policy managed.

  • This parameter can be used only with Oracle Clusterware and Oracle RAC.

-node node_name

The name of the node in the specified server pool on which to run a single-instance database. This parameter can only be specified with the -serverpool parameter.

-diskgroup "diskgroup_list"

Comma-delimited list of Oracle ASM disk groups.

-nodiskgroup

To remove the database's dependency on Oracle ASM disk groups.

-acfspath "acfs_path_list"

A single Oracle ACFS path or a comma-delimited list of Oracle ACFS paths enclosed in double quotation marks ("") where the database's dependency is set.

Use this parameter to create dependencies on Oracle ACFS file systems other than ORACLE_HOME, such as for when the database uses ORACLE_BASE on a file system that is different from the ORACLE_HOME file system.

-force

Force the operation even though the some resources might be stopped.

Usage Notes

  • The srvctl modify database command can convert administrator-managed databases to policy-managed databases. For a running administrator-managed database, if the server list is supplied, then the node where the database is running must be on that list. The instance name prefix cannot be modified after running the srvctl add database command.

  • You cannot change the management policy from AUTOMATIC (using the -policy parameter) for Oracle RAC One Node databases. Any attempt to do so results in an error message. The same is true for the -node parameter, which is used to change the node on which a noncluster database runs.

  • For policy-managed Oracle RAC One Node databases, you can use the -serverpool parameter to move an Oracle RAC One Node database between server pools but you can only specify one server pool. Specifying a list of server pools returns an error.

Examples

The following example changes the role of a database to a logical standby:

$ srvctl modify database -db crm -role logical_standby

The following example directs the racTest database to use the SYSFILES, LOGS, and OLTP Oracle ASM disk groups.

$ srvctl modify database -db racTest -diskgroup "SYSFILES,LOGS,OLTP"