dg_remove_standby_database

Removes a standby database from a Data Guard configuration.

Format

emcli dg_remove_standby_database
	-primary_target_name="<primary target name>"
	-primary_target_type="oracle_database|rac_database"
	-standby_target_name="<standby target name>"
	-standby_target_type="oracle_database|rac_database"
	[-primary_db_creds_name="<primary database credential name>"]
	[-primary_host_creds_name="<primary database host credential name>"] 
	[-standby_db_creds_name="<standby database credential name>"]
	[-standby_host_creds_name="<standby database host credential name>"]
	[-preserve_redo_dests]

[ ]  indicates that the parameter is optional.

Options

• primary_target_name

  Primary database Enterprise Manager target name. This can be either a single-instance database or a cluster database.

• primary_target_type

  Primary database target type. The following values are allowed:

  • oracle_database: Single instance database

  • rac_database: Cluster database

• standby_target_name

  Standby database Enterprise Manager target name. This can be either a single-instance database or a cluster database.

• standby_target_type

  Standby database target type. The following values are allowed:

  • oracle_database: Single instance database

  • rac_database: Cluster database

• primary_db_creds_name

  Primary database named credential for a user with SYSDBA or SYSDG role. Default Value: Preferred credentials will be used.

• primary_host_creds_name

  Primary database host named credential for an operating system user who can access the primary database Oracle home. Default Value: Preferred credentials will be used.

• standby_db_creds_name

  Standby database named credential for a user with SYSDBA or SYSDG role. Default Value: Preferred credentials will be used.

• standby_host_creds_name

  Standby database host named credential for an operating system user who can access the standby database Oracle home. Default Value: Preferred credentials will be used.

• preserve_redo_dests

  Preserve the archived log destination configured on the primary database for this standby database after it is removed from the Data Guard broker configuration. Redo will continue to be shipped to this standby database. Default Value: Not enabled.

Examples

Example 1

The following example removes the standby single-instance database named "database1" from the Data Guard configuration associated with the primary single-instance database named "database".

emcli dg_remove_standby_database 
	-primary_target_name="database"  
	-primary_target_type="oracle_database"
	-standby_target_name="database1"
	-standby_target_type="oracle_database"

Example 2

The following example removes the standby cluster database named "database1" from the Data Guard configuration associated with the primary cluster database named "database" and the redo continues to be shipped to this standby database.

 emcli dg_remove_standby_database 
	-primary_target_name="database"
	-primary_target_type="rac_database"
	-standby_target_name="database1"
	-standby_target_type="rac_database"
	-preserve_redo_dests