awrwh_reconfigure

Reconfigures AWR Warehouse database parameters.

Prerequisite: AWR Warehouse should be configured.

Format

emcli awrwh_reconfigure
            [-upload_interval=<upload_interval>]
            [-retention=<retention_period>]
            [-dest_dir=<dump_location>]
            [-db_cred=<target_database_named_credential>]     
            [-db_host_cred=<target_database_host_named_credential>]
            [-schema_password=<password_for_the_staging_schema>]
            [-list]
[ ] indicates that the parameter is optional

Options

• upload_interval

  New snapshot upload interval in hours.

• retention

  New retention period in years. If set to 0, AWR snapshots are retained permanently.

• dest_dir

  New dump location for storing AWR snapshots. In the case of RAC databases, provide a common location accessible to all instances.

• db_cred

  New named credential for the target database.

• db_host_cred

  New named credential for the target database host.

• schema_password

  If the selected warehouse database has a password policy, then specify a policy compliant password for the staging schema.

• list

  Lists current values of the parameters given above. This is the default when the other options are not specified.

Output

Success/Error

Examples

Example 1

The following example reconfigures the upload interval and dump location parameters:

emcli awrwh_reconfigure 
            -upload_interval=12
            -dest_dir="foo/bar"

Example 2

The following example reconfigures the database credential and database host credential parameters:

emcli awrwh_reconfigure
            -db_cred=DB_CRED_NAME
            -db_host_cred=DB_HOST_CRED_NAME