How to Recreate AWR Jobs in OEM to upload data to AWR Repository without Dropping DB from AWR (Doc ID 2599586.1)

Last updated on DECEMBER 03, 2019

Applies to:

Symptoms

A database in OEM is configured as a repository for AWR Warehouse. This AWR repository can be single instance database or RAC with multiple instances.

The databases which are added as source databases to AWR, will upload AWR data to this AWR Warehouse repository. These source databases can be single instance database or RAC with multiple instances. All these source databases will have a CAW_TRANSFER job to upload the AWR dumpfiles per instance. 

But some of the databases have not been uploading as expected. When verified these databases, found that these have lost the CAW_TRANSFER jobs. No upload is happening to AWR repository database.

Now you need to restart/re-create these CAW_TRANSFER job on every source database/instance where it is not running, to make sure the AWR data upload happening fine. Restarting/re-creating these CAW_TRANSFER job will not erase/loose any historic data uploaded to AWR repository database so far. 

Note: Removing the database from AWR and adding it back will restart the CAW_TRANSFER job, but it will erase all the historic data of that particular database uploaded so far to AWR repository warehouse. So this is not recommended. 

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.