How to recover AWR history ?
Hi, I'm dealing with an instance that was moving from another server due to a hardware upgrade. I did not realize this procedure, and not know how they performed, but all in the database is OK except for the AWR Reports: After the ask for num_days the awrrpti is frozen
I think the problem is that there are repeated values for DBID and INSTANCE_NUM in the dba_hist_database_instance, with different HOST_NAME (the old "prod.myorg.com" and the new "DBTIER"):
SQL> select distinct dbid, db_name, instance_num, instance_name, host_name from dba_hist_database_instance;
DBID DB_NAME INSTANCE_NUM INSTANCE_NAME HOST_NAME
68402211 PROD 1 prod prod.myorg.com
68402211 PROD 1 prod DBTIER
The simple solution is to change the DBID with nid, but in this way I'll loose the history of AWR reports
How can I tell Oracle that "prod.myorg.com" is now "DBTIER" (maybe update in the AWR base tables) ?
Edited by: Alfonso Vicente on Jan 24, 2012 5:31 PM