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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/175005/viewspace-207597/