Unfortunately AWR Warehouse and Data Guard do not work together seamlessly, however by understanding some of the implementation details, and following some simple steps you can help to mitigate most problems that may be encountered. It is not possible to add an instance to AWRW when it is in standby mode, worse still if you …
After a brief interlude I wanted to follow up on something I noticed on John Hallas’s blog. He mentioned that specifying a shared location for the extract metadata did not work, and was waiting on a fix for bug number 21826657. I checked that this bug should be fixed in db plugins version 13.2.2 and …
Note, in preparing next entry, I reviewed the results from previous entries and found that although extracts were being transferred successfully they had all failed to load; I should have noticed they had status 4 (IMPORT_FAILED), in the load metadata table. Reviewing dbms_scheduler_job_run_details of the load task revealed the following error: “move error: ORA-20105: Unable …