REMOVE INSTANCE

The REMOVE INSTANCE command removes the specified instance from the broker configuration.

Format

REMOVE INSTANCE instance_name  [ON { DATABASE | FAR_SYNC } <db_unique_name>];

Command Parameters

instance_name

The name of the instance (SID) that you want to remove from the broker configuration.

db_unique_name

The DB_UNIQUE_NAME initialization parameter value of the member with which the instance-name is associated.

Usage Notes

  • The broker automatically adds started instances to the broker configuration. However, the broker does not automatically remove instances from the database. The REMOVE INSTANCE command can be used to manually remove any instance that no longer exists from the configuration.

  • If the instance_name is not unique within the configuration, then you must specify both the DB_UNIQUE_NAME initialization parameter value of the member, and the instance_name to fully identify the instance.

  • This command is rejected for an instance that is currently active in the broker configuration.

  • This command is rejected if this is the only instance currently associated with a database or far sync.

Command Example

The following example shows how to remove an instance of the database.

DGMGRL> REMOVE INSTANCE 'south_sales3' ON DATABASE 'South_Sales';
Removed instance "south_sales3" from the database "South_Sales"