Monthly Archives: February 2014

11g ora-1555 on activated standby after migration from 10g

Switched over or failed over Standby is compromised by ora-1555. Version 11.2.0.4 Migrated from 10.2.0.4 Thousands of standby index pages (blocks) corrupted by “Page 424697 failed with check code 6056” as reported by dbv and the corrupted page count increasing. … Continue reading

Posted in Uncategorized | 2 Comments

licensing: force collection of dba_feature_usage_statistics

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=440761110506259&id=1291296.1&displayIndex=5&_afrWindowMode=0&_adf.ctrl-state=7k10hj6ru_37 — Force FUS collection alter session set events ‘immediate trace name mmon_test level 6’;

Posted in Uncategorized | Leave a comment

v$rman_status slow 11gR2

SQL> exec dbms_stats.DELETE_TABLE_STATS(‘SYS’,’X$KCCRSR’) SQL> select p, NULL, NULL from (select count(*) p from v$rman_status where operation = ‘BACKUP COPYROLLFORWARD’);

Posted in Uncategorized | 1 Comment