switchover (deprecated)

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

Note:

Since switchover is deprecated, use dg_switchover instead.

Format

emcli 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]  

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.

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 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 "primary" and a standby single-instance database named "standby". The scheduled jobs and the monitoring settings on "primary" will be moved to "standby" after the switchover is complete.

emcli switchover 
      -primary_target_name="primary"
      -primary_target_type="rac_database"
      -standby_target_name="standby"
      -standby_target_type="rac_database"
      -swap_jobs
      -swap_thresholds