mapletree

an Oracle player in Ottawa
正文

CPU patch & 10.2.0.3 patchset

(2007-08-11 19:59:54) 下一個

  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.

[ 打印 ]
閱讀 ()評論 (1)
評論
目前還沒有任何評論
登錄後才可評論.