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