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