dg_change_protection_mode

Changes the protection mode of a Data Guard configuration associated with the specified primary database.

Format

emcli dg_change_protection_mode
      -new_protection_mode="maximum_protection|maximum_availability|maximum_performance"
      -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>"]
      [-tde_wallet_creds_name="<transparent data encryption wallet credentials of the primary database>"]

Options

  • new_protection_mode

    Type of the new protection mode. Allowed values:

    • maximum_protection: Maximum Protection

    • maximum_availability: Maximum Availability

    • maximum_performance: Maximum Performance

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

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

  • primary_host_cred_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_cred_name

    Named credential of a standby database for a user with a SYSDBA role or a SYSDG role.

    Default value: Preferred credentials will be used.

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

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

Example

The following example changes the Data Guard protection mode between the primary single-instance database named 'database' and the standby single-instance database named 'database1' to Maximum Performance mode.

emcli dg_change_protection_mode
 -new_protection_mode="max_performance"
 -primary_target_name="database"
 -primary_target_type="oracle_database"
 -standby_target_name="database1"
 -standby_target_type="oracle_database"