CPU patch is security-related, applying it needs downtime. here's an vulnerability fiexed in CPU Jul2007: a bug related with FRA fixed in 10.2.0.3 patch. the symptom is: v$recovery_file_dest.space_reclaimable(0) is not consistent with V$FLASH_RECOVERY_AREA_USAGE.percent_space_reclaimable so, although there's enough space in FRA, we still got alarmed that the FRA is over 85% SQL> select name, 2 round(space_limit/(1024*1024),1) as limitMB, round(space_used/(1024*1024),1) as UsedMB, round(space_used/space_limit*100,2) as space_perc, round(space_reclaimable/(1024*1024),1) as ReclaimMB, round(space_reclaimable/space_limit*100,2) as space_reclaim_perc, number_of_files as files from V$RECOVERY_FILE_DEST where space_limit > 0; 7 8 9 NAME LIMITMB USEDMB SPACE_PERC RECLAIMMB SPACE_RECLAIM_PERC FILES ------------------------- ---------- ---------- ---------- ---------- ------------------ ---------- /oradata/flashback 43008 42994.1 99.97 0 0 430 SQL> SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE; FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES ------------ ------------------ ------------------------- --------------- CONTROLFILE 0 0 0 ONLINELOG 0 0 0 ARCHIVELOG 0 0 0 BACKUPPIECE 0 0 0 IMAGECOPY 0 0 0 FLASHBACKLOG 99.97 99.45 430 refer to metalink 392430.1, we hit Bug 5106952 here: Workaround : 1. shutdown immediate 2. startup mount 3. alter session set events 'immediate trace name KRA_OPTIONS level 1'; 4. select from V$FLASH_RECOVERY_AREA_USAGE shows 0 files for flashbacklog. Fix : Apply one-off patch for BUG:5106952 / Apply 10.2.0.3 patchset once available OR Issue fixed in Oracle 11.
|