dg_switchover

Performs a Data Guard switchover between a primary database and a standby database.

Format

emcli dg_switchover
      -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>"] 
      [-swap_jobs] 
      [-swap_thresholds]
      [-tde_wallet_creds_name="<transparent data encryption wallet credentials of the primary database>"]  

Options

• primary_target_name

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

• primary_target_type

  Primary database target type. Specify oracle_database for single instance, or rac_database for cluster.

• standby_target_name

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

• standby_target_type

  Standby database target type. Specify oracle_database for single instance, or rac_database for cluster.

• primary_db_creds_name

  Primary database named credential for a user with SYSDBA or SYSDG role. Default is to use preferred credential.

• primary_host_creds_name

  Primary database host named credential for an operating system user who can access the primary database Oracle home. Default is to use preferred credential.

• standby_db_creds_name

  Standby database named credential for a user with SYSDBA or SYSDG role. Default is to use preferred credential.

• standby_host_creds_name

  Standby database host named credential for an operating system user who can access the standby database Oracle home. Default is to use preferred credential.

• swap_jobs

  Specifies that scheduled jobs on either the primary or standby database that are of a transferable type (Backup, RMAN Script, and SQL Script) will be moved to the other database after Enterprise Manager detects a fast-start failover. Default is not enabled.

• swap_thresholds

  Specifies that monitoring settings will be swapped between the primary and standby databases after Enterprise Manager detects a fast-start failover. Default is not enabled.

• tde_wallet_creds_name

  Transparent Data Encryption wallet credentials for the primary database. Use create_named_credential verb to create these credentials as shown below:

  emcli create_named_credential
  	-cred_name=WC1
  	-cred_type=GenericPassword
  	-auth_target_type='<system>'
  	-attributes="GENERIC_PASSWORD:<Primary Database TDE Wallet Password>"

Examples

Example 1

The following command performs a switchover between a primary single-instance database named "database" and a standby single-instance database named "database1".

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

Example 2

The following command performs a switchover between a primary single-instance database named "database" and a standby single-instance database named "database1". The scheduled jobs and the monitoring settings on "database" will be moved to "database1" after the switchover is complete.

emcli dg_switchover 
      -primary_target_name="database"
      -primary_target_type="rac_database"
      -standby_target_name="database1"
      -standby_target_type="rac_database"
      -swap_jobs
      -swap_thresholds