awrwh_add_src_db

Adds a database as a source to the AWR Warehouse.

Prerequisites:

  • AWR Warehouse should be configured.

  • The database being added cannot be:

    • An instance of a RAC database

    • The AWR Warehouse

  • The database user should be a DBA.

  • The database user should have execute privilege on SYS.DBMS_SWRF_INTERNAL.

Format

emcli awrwh_add_src_db
        -target_name=<target_database_name> 
        -target_type=<target_database_type>
        -db_cred=<target_database_named_credential> 
        -db_host_cred=<target_database_host_named_credential> 
        [-retention_days=<number_of_retention_days>]
        [-upload_interval=<snapshot_upload_interval>]
        -src_dir=<directory_to_store_extracted_dump_files>
[ ] indicates that the parameter is optional

Options

  • target_name

    Name of the target database added as a source to the AWR Warehouse.

  • target_type

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

  • db_cred

    Named credential for the target database.

  • db_host_cred

    Named credential for the target database host.

  • retention_days

    Number of days the AWR data will be retained in warehouse. The default value is one year.

  • upload_interval

    Snapshot upload interval for the source database in AWR Warehouse. The default value is 24 hours.

  • src_dir

    Directory to store extracted dump files. This is an optional parameter except for PDBs on cluster and by default the default agent directory is used.

Output

Success/Error message

Example

The following example adds the target database sample_database as a source to the AWR Warehouse: 

emcli awrwh_add_src_db  
          -target_name=sample_database 
          -target_type=oracle_database
          -db_cred=DB1_NAMED_CRED 
          -db_host_cred=TEST_HOST_CRED