AWR Warehouse Operations
Submitted by dave on Fri, 04/13/2018 - 12:20
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