dg_convert_standby

It converts a physical standby database to snapshot standby database. Conversely, converts a snapshot standby database to a physical standby database.

Format

emcli dg_convert_standby
	-standby_target_name="<standby target name>"
	-standby_target_type="oracle_database|rac_database"
	[-standby_db_creds_name="<standby database credential name>"]
	[-standby_host_creds_name="<standby database host credential name>"]
	[-convert_to="<standby database role>"]

[ ]  indicates that the parameter is optional

Options

  • standby_target_name

    Standby database Enterprise Manager target name. It 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

  • 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.

  • convert_to

    Role the standby database will be converted to. The following values are allowed:

    • physical

    • snapshot

    • physical standby

    • snapshot standby

    Default Value: snapshot standby if the current standby database role is physical standby and conversely physical standby if the current standby database role is snapshot standby.

Example

The following example converts the physical single-instance standby database named 'database' to snapshot standby database.

emcli dg_convert_standby  
       -standby_target_name="database"
       -standby_target_type="oracle_database"
       -convert_to="snapshot"