awrwh_reconfigure_src

Reconfigures AWR Warehouse source database parameters.

Prerequisites:

• AWR Warehouse should be configured.

• Database specified should be uploading to the AWR Warehouse.

Format

emcli awrwh_reconfigure_src
            -target_name=<target_database_name> 
            -target_type=<target_database_type>     
            [-inst_num=<RAC_instance_number>]     
            [-src_dir=<dump_location>]     
            [-upload_interval_hrs=<upload_interval>]     
            [-retention_days=<retention_period>]     
            [-db_cred=<database_named_credential>]     
            [-host_cred=<database_host_named_credential>]
[ ] indicates that the parameter is optional

Options

• target_name

  Name of existing target database.

• target_type

  Type of target. The possible values for target type are oracle_database, oracle_pdb, and rac_database.

• inst_num

  Instance number in case of a RAC database.

• src_dir

  New dump location for storing AWR snapshots. In the case of RAC databases, either specify an instance using the inst_num parameter or provide a common location accessible to all instances.

• upload_interval_hrs

  New snapshot upload interval in hours.

• retention_days

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

• db_cred

  New named credential for the target database.

• host_cred

  New named credential for the target database host.

Output

Success/Error

Examples

Example 1

The following example reconfigures the AWR Warehouse source database to switch to a new dump location:

emcli awrwh_reconfigure_src 
            -target_name=database 
            -target_type=oracle_database
            -src_dir="foo/bar"

Example 2

The following example changes the retention period of the source database to 30 days:

emcli awrwh_reconfigure_src
            -target_name=database
            -target_type=oracle_database
            -retention_days=30

Example 3

The following example changes the snapshot upload interval of the source database to 15 hours and the host credential to MY_HOST_CRED:

emcli awrwh_reconfigure_src
            -target_name=database 
            -target_type=oracle_database
            -upload_interval_hrs=15 
            -host_cred=MY_HOST_CRED