Last week i had to investigate a perf issue on the ACCEPTANCE environment which is a restore of the production database, I had to compare the awr reports of a monthly job.

On production I’ve set a retention of 40 days in order to be able to debug issues with a monthly job and to have some buffer.

We restore ACCEPTANCE from PRODUCTION backups and the change dbname and dbid with nid (for some reason aka bug we are not able to duplicate the db with rman)

as you can see from the sql hereunder the retentention is different for the PROD db (dbid 2789041670)
as for it’s cloned brother ACC (1857427655)

select * from DBA_HIST_WR_CONTROL;

——–             ————————–        ——————-      —————
2789041670 0 0:20:0.0                           40 0:0:0.0            DEFAULT
1857427655 0 1:0:0.0                             7 0:0:0.0               DEFAULT

so AWR reset to the defaults after using nid and opening with resetlogs.

adapt your procedures to change the retention again after a clone … 

Leave a Reply