dg_verify_config

Verifies the health of the Data Guard configuration of a primary database and performs the following checks:

- Obtains detailed status information from Data Guard broker for each database.

- Verifies that the redo transport is functioning between the primary and standby databases.

- Verifies the proper configuration of the standby redo log files.

- Verifies that the Data Guard broker properties are consistent with underlying database properties.

- Verifies the status of the Agents for all databases.

- Verifies that the preferred credentials are set for all databases.

When the verification process ends, the following fixes are performed automatically:

- Resolves inconsistencies between broker and database properties.

- Creates standby redo log files for any databases when needed.

Format

emcli dg_verify_config
      -primary_target_name="<primary target name>"
      -primary_target_type="oracle_database|rac_database"  
      [-primary_db_creds_name="<primary database credential name>"] 
      [-primary_host_creds_name="<primary database host credential name>"]  
      [-reset_inconsistent_props="broker|database"]
      [-create_srls] 
      [-verify_only]

Options

• primary_target_name

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

• primary_target_typ

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

• reset_inconsistent_props

  Resets the inconsistent properties to the broker or the database values. Allowed values:

  • broker

  • database

  Default is broker.

• create_srls

  Creates standby redo log files for any database that either have none or do not have the proper number and/or sizes. The files will be created as Oracle-managed files (OMF) for any databases that are configured with OMF.

• verify_only

  Runs a verification. Neither resolves automatically inconsistent properties nor creates standby redo log files.

Examples

Example 1

The following command verifies the health of the Data Guard configuration associated with the primary single-instance database named "database" and resolves the inconsistencies between the database and the broker properties if any.

emcli dg_verify_config 
      -primary_target_name="database"
      -primary_target_type="oracle_database"

Example 2

The following command only verifies the health of the primary single-instance database named "database".

emcli dg_verify_config 
      -primary_target_name="database"
      -primary_target_type="rac_database"
      -verify_only