利用rman刪除硬碟上丟失的archivelog

paulyibinyi發表於2007-12-20

C:\Documents and Settings\Paul Yi>rman target / catalog paultest/paultest@dev89  log=d:\rman.log


Recovery Manager: Release 9.2.0.4.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: PAUL (DBID=1605165889)
connected to recovery catalog database

RMAN> backup archivelog all delete input;
Starting backup at 20-DEC-07
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=9 devtype=DISK
archived log D:\ORA\1_145.DBF not found or out of sync with catalog
trying alternate file for archivelog thread 1, sequence 145
archived log D:\ORA\1_146.DBF not found or out of sync with catalog
trying alternate file for archivelog thread 1, sequence 146
archived log D:\ORA\1_147.DBF not found or out of sync with catalog
trying alternate file for archivelog thread 1, sequence 147
archived log D:\ORA\1_148.DBF not found or out of sync with catalog
trying alternate file for archivelog thread 1, sequence 148
archived log D:\ORA\1_149.DBF not found or out of sync with catalog
trying alternate file for archivelog thread 1, sequence 149
archived log D:\ORA\1_150.DBF not found or out of sync with catalog
trying alternate file for archivelog thread 1, sequence 150
archived log D:\ORA\1_151.DBF not found or out of sync with catalog
trying alternate file for archivelog thread 1, sequence 151
archived log D:\ORA\1_152.DBF not found or out of sync with catalog
trying alternate file for archivelog thread 1, sequence 152
archived log D:\ORA\1_153.DBF not found or out of sync with catalog
trying alternate file for archivelog thread 1, sequence 153
archived log D:\ORA\1_154.DBF not found or out of sync with catalog
trying alternate file for archivelog thread 1, sequence 154
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 12/20/2007 15:38:54
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file D:\ORA\1_155.DBF
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system

RMAN> crosscheck archivelog all;

archive log filename=D:\BACKUP\1_152.DBF recid=658 stamp=641737080
validation failed for archived log
archive log filename=D:\ORA\1_153.DBF recid=659 stamp=641746310
validation succeeded for archived log
archive log filename=D:\BACKUP\1_153.DBF recid=661 stamp=641746310
validation failed for archived log
archive log filename=D:\ORA\1_154.DBF recid=701 stamp=641746343
validation succeeded for archived log
archive log filename=D:\BACKUP\1_154.DBF recid=703 stamp=641746343
validation failed for archived log
archive log filename=D:\ORA\1_155.DBF recid=704 stamp=641746689
validation failed for archived log
archive log filename=D:\ORA\1_156.DBF recid=706 stamp=641746702
validation succeeded for archived log
archive log filename=D:\ARCHPAUL\1_157.DBF recid=708 stamp=641755269
validation succeeded for archived log
archive log filename=D:\ARCHPAUL\1_158.DBF recid=709 stamp=641755309
validation succeeded for archived log
archive log filename=D:\ARCHPAUL\1_159.DBF recid=710 stamp=641755315
validation succeeded for archived log
archive log filename=D:\ARCHPAUL\1_160.DBF recid=714 stamp=641811049
validation succeeded for archived log
archive log filename=D:\ARCHPAUL\1_161.DBF recid=715 stamp=641815669
validation succeeded for archived log
archive log filename=D:\ARCHPAUL\1_162.DBF recid=718 stamp=641817394
validation succeeded for archived log
archive log filename=D:\ARCHPAUL\1_163.DBF recid=720 stamp=641819028
validation succeeded for archived log
archive log filename=D:\ARCHPAUL\1_164.DBF recid=722 stamp=641824798


RMAN> delete expired archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=9 devtype=DISK

List of Archived Log Copies
Key     Thrd Seq     S Low Time  Name
------- ---- ------- - --------- ----
5069    1    145     X 19-DEC-07 D:\ORA\1_145.DBF
5071    1    146     X 19-DEC-07 D:\ORA\1_146.DBF
5073    1    147     X 19-DEC-07 D:\ORA\1_147.DBF
5075    1    148     X 19-DEC-07 D:\ORA\1_148.DBF
5257    1    149     X 19-DEC-07 D:\ORA\1_149.DBF
5259    1    150     X 19-DEC-07 D:\ORA\1_150.DBF
5261    1    151     X 19-DEC-07 D:\ORA\1_151.DBF
5263    1    152     X 19-DEC-07 D:\ORA\1_152.DBF
5265    1    153     X 19-DEC-07 D:\ORA\1_153.DBF
5267    1    154     X 19-DEC-07 D:\ORA\1_154.DBF
5269    1    155     X 19-DEC-07 D:\ORA\1_155.DBF
5270    1    156     X 19-DEC-07 D:\ORA\1_156.DBF

Do you really want to delete the above objects (enter YES or NO)?
Do you really want to delete the above objects (enter YES or NO)?
Do you really want to delete the above objects (enter YES or NO)? deleted archive log
archive log filename=D:\ORA\1_145.DBF recid=428 stamp=641731939
deleted archive log
archive log filename=D:\ORA\1_146.DBF recid=430 stamp=641733977
deleted archive log
archive log filename=D:\ORA\1_147.DBF recid=432 stamp=641734093
deleted archive log
archive log filename=D:\ORA\1_148.DBF recid=437 stamp=641734099
deleted archive log
archive log filename=D:\ORA\1_149.DBF recid=612 stamp=641736652
deleted archive log
archive log filename=D:\ORA\1_150.DBF recid=614 stamp=641737062
deleted archive log
archive log filename=D:\ORA\1_151.DBF recid=636 stamp=641737070
deleted archive log
archive log filename=D:\ORA\1_152.DBF recid=656 stamp=641737080
deleted archive log
archive log filename=D:\ORA\1_153.DBF recid=659 stamp=641746310
deleted archive log
archive log filename=D:\ORA\1_154.DBF recid=701 stamp=641746343
deleted archive log
archive log filename=D:\ORA\1_155.DBF recid=704 stamp=641746689
deleted archive log
archive log filename=D:\ORA\1_156.DBF recid=706 stamp=641746702
Deleted 12 EXPIRED objects

然後再次備份成功

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

相關文章