EDIT DATABASE (Property)

The EDIT DATABASE command changes the value of the specified configurable property for a database member.

Format

EDIT DATABASE <db_unique_name> SET PROPERTY <property_name>=value;

Command Parameters

db_unique_name

The DB_UNIQUE_NAME initialization parameter value of the database whose configurable property value is to be changed.

property_name

The name of an existing database-specific property. If this is an Oracle RAC database, this property change affects all instances of the database.

See Also:

Managing the Members of a Broker Configuration and Oracle Data Guard Broker Properties for information about properties.

value

The new value for the property.

Note:

This command can be used to change the value of an instance-specific property if and only if just one instance is known by the broker for the named database. An attempt to use this command to change an instance-specific property when the broker knows of multiple instances of the database will be rejected. It is recommended to only use EDIT INSTANCE (property) to change the value of an instance-specific property.

Command Examples

Example 1: Editing a Configurable Property at the Database Level

The following example edits a configurable property at the database level.

DGMGRL> EDIT DATABASE 'North_Sales' SET PROPERTY 'LogXptMode'='SYNC';
Property "LogXptMode" updated

Example 2: Editing a List of Fast-Start Failover Targets

The following examples show how to specify a list of fast-start failover targets.

DGMGRL> EDIT DATBASE db1 SET PROPERTY FastStartFailoverTarget='db2, db3';

DGMGRL> EDIT DATABASE db2 SET PROPERTY FastStartFailoverTarget='db1,db3';

DGMGRL> EDIT DATABASE db3 SET PROPERTY FastStartFailoverTarget='db1';