ITPub博客

利用rman删除硬盘上丢失的archivelog

原创 Linux操作系统 作者:paulyibinyi 时间:2007-12-20 15:50:44 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
oracle 10g ocm oracle 10g/11g/12c ocp aix 6.1 administrator,ogg expert,ITSS 技术交流群 201703254 微信公众号 paulyibin 探讨技术,开心工作 电话 13719354869 ,深入研究数据库和开始研究big data

注册时间:2007-12-11

  • 博文量
    905
  • 访问量
    6484723