Flashback area中檢視不到歸檔的資訊

趙宇發表於2008-03-17

C:\Documents and Settings\oracle>set NLS_LANG=ENGLISH

C:\Documents and Settings\oracle>rman target / nocatalog

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Mar 17 16:59:26 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: DEVDB (DBID=537083282)
using target database control file instead of recovery catalog

RMAN> crosscheck archivelog all;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=143 devtype=DISK
validation succeeded for archived log
archive log filename=+DISK_GROUP2/archive/arc00001_0647196042.001 recid=190 stamp=647213032
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DEVDB\ARCHIVELOG\ARC00001_0647196042.001 recid=191 stamp=647213032
validation succeeded for archived log
archive log filename=+DISK_GROUP2/archive/arc00001_0647196042.001 recid=186 stamp=647211584
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DEVDB\ARCHIVELOG\ARC00001_0647196042.001 recid=187 stamp=647211584
validation succeeded for archived log
archive log filename=+DISK_GROUP2/archive/arc00002_0647196042.001 recid=188 stamp=647213030
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DEVDB\ARCHIVELOG\ARC00002_0647196042.001 recid=189 stamp=647213030
validation succeeded for archived log
archive log filename=+DISK_GROUP2/archive/arc00001_0647213028.001 recid=192 stamp=647216448
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DEVDB\ARCHIVELOG\ARC00001_0647213028.001 recid=193 stamp=647216448
validation succeeded for archived log
archive log filename=+DISK_GROUP2/archive/arc00002_0647213028.001 recid=194 stamp=647368269
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DEVDB\ARCHIVELOG\ARC00002_0647213028.001 recid=195 stamp=647368269
validation succeeded for archived log
archive log filename=+DISK_GROUP2/archive/arc00003_0647213028.001 recid=196 stamp=647513322
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DEVDB\ARCHIVELOG\ARC00003_0647213028.001 recid=197 stamp=647513322
validation succeeded for archived log
archive log filename=+DISK_GROUP2/archive/arc00004_0647213028.001 recid=198 stamp=647543886
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DEVDB\ARCHIVELOG\ARC00004_0647213028.001 recid=199 stamp=647543886
validation succeeded for archived log
archive log filename=+DISK_GROUP2/archive/arc00005_0647213028.001 recid=200 stamp=647688784
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DEVDB\ARCHIVELOG\ARC00005_0647213028.001 recid=201 stamp=647688784
validation succeeded for archived log
archive log filename=+DISK_GROUP2/archive/arc00006_0647213028.001 recid=202 stamp=647708721
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DEVDB\ARCHIVELOG\ARC00006_0647213028.001 recid=203 stamp=647708721
validation succeeded for archived log
archive log filename=+DISK_GROUP2/archive/arc00007_0647213028.001 recid=204 stamp=647878693
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DEVDB\ARCHIVELOG\ARC00007_0647213028.001 recid=205 stamp=647878693
validation succeeded for archived log
archive log filename=+DISK_GROUP2/archive/arc00008_0647213028.001 recid=206 stamp=648377724
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DEVDB\ARCHIVELOG\ARC00008_0647213028.001 recid=207 stamp=648377724
validation succeeded for archived log
archive log filename=+DISK_GROUP2/archive/arc00009_0647213028.001 recid=208 stamp=648379320
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DEVDB\ARCHIVELOG\ARC00009_0647213028.001 recid=209 stamp=648379320
validation succeeded for archived log
archive log filename=+DISK_GROUP2/archive/arc00010_0647213028.001 recid=210 stamp=648419061
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DEVDB\ARCHIVELOG\ARC00010_0647213028.001 recid=211 stamp=648419061
validation succeeded for archived log
archive log filename=+DISK_GROUP2/archive/arc00011_0647213028.001 recid=212 stamp=648637401
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DEVDB\ARCHIVELOG\ARC00011_0647213028.001 recid=213 stamp=648637401
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DEVDB\ARCHIVELOG\ARC00012_0647213028.001 recid=215 stamp=649245596
validation succeeded for archived log
archive log filename=+DISK_GROUP2/archive/arc00012_0647213028.001 recid=214 stamp=649245595
validation succeeded for archived log
archive log filename=+DISK_GROUP2/archive/arc00013_0647213028.001 recid=216 stamp=649266526
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DEVDB\ARCHIVELOG\ARC00013_0647213028.001 recid=217 stamp=649266526
validation succeeded for archived log
archive log filename=+DISK_GROUP2/archive/arc00014_0647213028.001 recid=218 stamp=649591744
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DEVDB\ARCHIVELOG\ARC00014_0647213028.001 recid=219 stamp=649591744
validation succeeded for archived log
archive log filename=+DISK_GROUP2/archive/arc00015_0647213028.001 recid=220 stamp=649606973
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DEVDB\ARCHIVELOG\ARC00015_0647213028.001 recid=221 stamp=649606973
validation succeeded for archived log
archive log filename=+DISK_GROUP2/archive/arc00016_0647213028.001 recid=222 stamp=649616258
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DEVDB\ARCHIVELOG\ARC00016_0647213028.001 recid=223 stamp=649616258
validation succeeded for archived log
archive log filename=+DISK_GROUP2/devdb/archivelog/2008_03_17/thread_1_seq_16.282.649616255 recid=224 stamp=649616258
Crosschecked 39 objects

檢查歸檔存在但是在v$flash_recovery_area_usage中查不到歸檔資訊,為什麼呢

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              24.36                     24.24             196

已選擇6行。

SQL> show parameter log_archive_

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_config                   string
log_archive_dest                     string
log_archive_dest_1                   string      LOCATION=+DISK_GROUP2/ARCHIVE/
log_archive_dest_10                  string
log_archive_dest_2                   string      LOCATION=D:\oracle\product\10.2.0\flash_recovery_area\DEVDB\ ARCHIVElog
log_archive_dest_3                   string      LOCATION=+DISK_GROUP2

 

SQL> show parameter db_rec

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +DISK_GROUP2
db_recovery_file_dest_size           big integer 3G
db_recycle_cache_size                big integer 0

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/175005/viewspace-207597/，如需轉載，請註明出處，否則將追究法律責任。

相關文章