awrwh_remove_src_db

Removes an existing database from the AWR Warehouse.

Prerequisites:

  • AWR Warehouse should be configured.

  • Database specified should be uploading to the AWR Warehouse.

Format

emcli awrwh_remove_src_db
            -target_name=<target_database_name>
            -target_type=<target_database_type>
            [-retain_data_in_warehouse]
[ ] 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.

  • retain_data_in_warehouse

    If this flag is added, then the already collected AWR data is retained in the warehouse but all upload activity is stopped.

Output

Success/Error

Example

The following example removes the target database sample_database from the AWR Warehouse: 

emcli awrwh_remove_src_db 
            -target_name=sample_database 
            -target_type=oracle_database
            -retain_data_in_warehouse