AWR Warehouse Operations

Listing databases added to an AWR Warehouse with EMCLI

$ emcli login username=username
Enter password

Login successful

$ emcli awrwh_list_src_dbs

Databases uploading to the AWR Warehouse:
Target Name               Target Type      Owner   Version          Snapshot Upload Status  Snapshots Uploaded
db1.business.com          rac_database     DMANN   11.2.0.4.180116  Enabled                 123
db2.business.com          rac_database     DMANN   12.1.0.2.0       Enabled                 456

Adding a DB to AWR Warehouse with EMCLI

Ensure preferred credentials are set and owned by desired user.

TODO

Add using emcli verb

$ emcli login username=username
Enter password

Login successful
$ emcli awrwh_add_src_db -target_name=db1.business.com -target_type=rac_database
Target db1.business.com successfully added to the AWR warehouse.

Kick off upload job

TODO

Removing a DB from AWR Warehouse with EMCLI

remove using emcli verb

$ emcli login username=username
Enter password

Login successful

$ emcli awrwh_remove_src_db -target_name=db1.business.com -target_type=rac_database