RMAN-06061 WARNING skipping archivelog compromises recoverability处理

本文介绍了解决Oracle RMAN备份过程中出现的RMAN-06061警告的方法。通过执行crosscheck验证归档日志状态,并使用delete命令清理控制文件中已丢失的归档记录。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

--RMAN-06061处理
--例行进行数据库备份检查的时候发现一个库的备份状态是completed with errors
--所以进到操作系统进行查看,发现全备日志中出现了如下的告警
archived log /opt/oracle/cisdb/archdb1/bak/cisdb2_127732_673050541.arc not found or out of sync with catalog
skipping inaccessible file /opt/oracle/cisdb/archdb1/bak/cisdb2_127732_673050541.arc
RMAN-06061: WARNING: skipping archivelog compromises recoverability


--search了一下发现该错误一般是由于手动删除了归档导致备份时无法找到对应的归档文件导致的,
--正好想到这周一备份出错时正是由于归档目录满了所导致,可能相关人员删除了部分归档文件。
--使用rman进行crosscheck


$ rman target /


Recovery Manager: Release 10.2.0.5.0 - Production on Thu May 7 10:30:56 2015


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


connected to target database: CISDB (DBID=3992919346)


RMAN> crosscheck archivelog all;


using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=6542 instance=cisdb2 devtype=DISK
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127703_673050541.arc recid=402622 stamp=878555473
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127704_673050541.arc recid=402623 stamp=878555879
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127705_673050541.arc recid=402624 stamp=878556416
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127706_673050541.arc recid=402625 stamp=878556623
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127707_673050541.arc recid=402626 stamp=878556637
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127708_673050541.arc recid=402627 stamp=878556651
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127709_673050541.arc recid=402628 stamp=878556662
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127710_673050541.arc recid=402629 stamp=878556674
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127711_673050541.arc recid=402630 stamp=878556686
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127712_673050541.arc recid=402631 stamp=878556693
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127713_673050541.arc recid=402632 stamp=878556701
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127714_673050541.arc recid=402633 stamp=878556934
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127715_673050541.arc recid=402634 stamp=878558519
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127716_673050541.arc recid=402635 stamp=878560954
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127717_673050541.arc recid=402636 stamp=878562006
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127718_673050541.arc recid=402637 stamp=878562008
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127719_673050541.arc recid=402638 stamp=878562838
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127720_673050541.arc recid=402639 stamp=878563486
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127721_673050541.arc recid=402640 stamp=878563786
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127722_673050541.arc recid=402641 stamp=878563801
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127723_673050541.arc recid=402642 stamp=878563814
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127724_673050541.arc recid=402643 stamp=878563818
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127725_673050541.arc recid=402644 stamp=878563827
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127726_673050541.arc recid=402645 stamp=878563844
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127727_673050541.arc recid=402646 stamp=878563861
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127728_673050541.arc recid=402647 stamp=878563901
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127729_673050541.arc recid=402648 stamp=878563949
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127730_673050541.arc recid=402649 stamp=878563992
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127731_673050541.arc recid=402650 stamp=878564546
validation failed for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127732_673050541.arc recid=402651 stamp=878565920
validation succeeded for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_128071_673050541.arc recid=402990 stamp=879066010
validation succeeded for archived log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_128072_673050541.arc recid=402991 stamp=879066011
Crosschecked 32 objects


--列出所有失效的归档
RMAN> list expired archivelog all;




List of Archived Log Copies
Key     Thrd Seq     S Low Time  Name
------- ---- ------- - --------- ----
402622  2    127703  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127703_673050541.arc
402623  2    127704  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127704_673050541.arc
402624  2    127705  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127705_673050541.arc
402625  2    127706  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127706_673050541.arc
402626  2    127707  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127707_673050541.arc
402627  2    127708  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127708_673050541.arc
402628  2    127709  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127709_673050541.arc
402629  2    127710  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127710_673050541.arc
402630  2    127711  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127711_673050541.arc
402631  2    127712  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127712_673050541.arc
402632  2    127713  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127713_673050541.arc
402633  2    127714  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127714_673050541.arc
402634  2    127715  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127715_673050541.arc
402635  2    127716  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127716_673050541.arc
402636  2    127717  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127717_673050541.arc
402637  2    127718  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127718_673050541.arc
402638  2    127719  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127719_673050541.arc
402639  2    127720  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127720_673050541.arc
402640  2    127721  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127721_673050541.arc
402641  2    127722  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127722_673050541.arc
402642  2    127723  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127723_673050541.arc
402643  2    127724  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127724_673050541.arc
402644  2    127725  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127725_673050541.arc
402645  2    127726  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127726_673050541.arc
402646  2    127727  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127727_673050541.arc
402647  2    127728  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127728_673050541.arc
402648  2    127729  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127729_673050541.arc
402649  2    127730  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127730_673050541.arc
402650  2    127731  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127731_673050541.arc
402651  2    127732  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127732_673050541.arc


--删除对应的归档文件(不是真正删除归档,因为归档本来就不在了,只是从控制文件中删除对应的记录)
RMAN> delete expired archivelog all;


released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=6542 instance=cisdb2 devtype=DISK


List of Archived Log Copies
Key     Thrd Seq     S Low Time  Name
------- ---- ------- - --------- ----
402622  2    127703  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127703_673050541.arc
402623  2    127704  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127704_673050541.arc
402624  2    127705  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127705_673050541.arc
402625  2    127706  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127706_673050541.arc
402626  2    127707  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127707_673050541.arc
402627  2    127708  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127708_673050541.arc
402628  2    127709  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127709_673050541.arc
402629  2    127710  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127710_673050541.arc
402630  2    127711  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127711_673050541.arc
402631  2    127712  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127712_673050541.arc
402632  2    127713  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127713_673050541.arc
402633  2    127714  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127714_673050541.arc
402634  2    127715  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127715_673050541.arc
402635  2    127716  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127716_673050541.arc
402636  2    127717  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127717_673050541.arc
402637  2    127718  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127718_673050541.arc
402638  2    127719  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127719_673050541.arc
402639  2    127720  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127720_673050541.arc
402640  2    127721  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127721_673050541.arc
402641  2    127722  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127722_673050541.arc
402642  2    127723  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127723_673050541.arc
402643  2    127724  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127724_673050541.arc
402644  2    127725  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127725_673050541.arc
402645  2    127726  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127726_673050541.arc
402646  2    127727  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127727_673050541.arc
402647  2    127728  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127728_673050541.arc
402648  2    127729  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127729_673050541.arc
402649  2    127730  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127730_673050541.arc
402650  2    127731  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127731_673050541.arc
402651  2    127732  X 01-MAY-15 /opt/oracle/cisdb/archdb1/bak/cisdb2_127732_673050541.arc


Do you really want to delete the above objects (enter YES or NO)? yes
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127703_673050541.arc recid=402622 stamp=878555473
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127704_673050541.arc recid=402623 stamp=878555879
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127705_673050541.arc recid=402624 stamp=878556416
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127706_673050541.arc recid=402625 stamp=878556623
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127707_673050541.arc recid=402626 stamp=878556637
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127708_673050541.arc recid=402627 stamp=878556651
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127709_673050541.arc recid=402628 stamp=878556662
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127710_673050541.arc recid=402629 stamp=878556674
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127711_673050541.arc recid=402630 stamp=878556686
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127712_673050541.arc recid=402631 stamp=878556693
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127713_673050541.arc recid=402632 stamp=878556701
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127714_673050541.arc recid=402633 stamp=878556934
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127715_673050541.arc recid=402634 stamp=878558519
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127716_673050541.arc recid=402635 stamp=878560954
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127717_673050541.arc recid=402636 stamp=878562006
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127718_673050541.arc recid=402637 stamp=878562008
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127719_673050541.arc recid=402638 stamp=878562838
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127720_673050541.arc recid=402639 stamp=878563486
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127721_673050541.arc recid=402640 stamp=878563786
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127722_673050541.arc recid=402641 stamp=878563801
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127723_673050541.arc recid=402642 stamp=878563814
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127724_673050541.arc recid=402643 stamp=878563818
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127725_673050541.arc recid=402644 stamp=878563827
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127726_673050541.arc recid=402645 stamp=878563844
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127727_673050541.arc recid=402646 stamp=878563861
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127728_673050541.arc recid=402647 stamp=878563901
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127729_673050541.arc recid=402648 stamp=878563949
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127730_673050541.arc recid=402649 stamp=878563992
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127731_673050541.arc recid=402650 stamp=878564546
deleted archive log
archive log filename=/opt/oracle/cisdb/archdb1/bak/cisdb2_127732_673050541.arc recid=402651 stamp=878565920
Deleted 30 EXPIRED objects


RMAN> exit


Recovery Manager complete.



--做完之后看了一下最新的归档备份,状态是completed了,对应的问题应该已经解决
在Oracle数据库中使用RMAN(Recovery Manager)进行备份时,如果出现错误 `RMAN-03002`、`RMAN-06059` 和 `ORA-19625`,这些错误通常与归档日志文件丢失或路径不一致有关。以下是针对这些问题的解决方案: ### 错误分析与解决方法 1. **RMAN-03002: failure of backup command** - 该错误表示RMAN备份命令执行失败。它通常作为其他错误(如`RMAN-06059`)的包装错误,指示具体的失败原因。 - 这个错误本身不会提供详细的失败原因,因此需要查看堆栈中的其他错误信息以确定根本原因。 2. **RMAN-06059: expected archived log not found, loss of archived log compromises recoverability** - 该错误表明RMAN期望找到某个归档日志文件,但未找到。这通常是因为归档日志文件已被手动删除或路径不一致导致的。 - 这会直接影响数据库的可恢复性,因为RMAN无法找到必要的归档日志文件来完成备份或恢复操作。 3. **ORA-19625: error identifying file** - 该错误进一步说明了文件路径问题,例如归档日志文件不存在或路径错误。 - 在Linux系统上,错误 `ORA-27037: unable to obtain file status` 和 `Linux-x86_64 Error: 2: No such file or directory` 表明RMAN无法访问指定的归档日志文件路径。 ### 解决方案 1. **验证归档日志文件路径** - 检查归档日志文件的实际存储路径是否与RMAN目录中记录的路径一致。 - 如果归档日志文件已被手动删除,可以使用以下命令从RMAN目录中清除无效的归档日志信息: ```sql RMAN> crosscheck archivelog all; RMAN> delete expired archivelog all; ``` 这些命令会标记无效的归档日志条目,并从RMAN目录中删除它们[^2]。 2. **更新归档日志路径** - 如果归档日志文件被移动到新的路径,需要更新RMAN目录中的路径信息。可以使用以下命令注册新的归档日志文件: ```sql RMAN> catalog start with '/new/archivelog/path/'; ``` 这将重新注册指定路径下的所有归档日志文件。 3. **避免手动删除归档日志文件** - 手动删除归档日志文件可能导致RMAN目录与实际文件状态不一致。建议通过RMAN命令删除归档日志文件,以确保目录信息同步: ```sql RMAN> delete archivelog until time 'sysdate-7'; ``` 这将删除7天前的归档日志文件,并更新RMAN目录。 4. **检查归档日志路径权限** - 确保Oracle数据库实例具有对归档日志文件路径的读写权限。权限不足可能导致RMAN无法访问或写入归档日志文件。 5. **配置归档日志删除策略** - 为了避免归档日志文件占用过多磁盘空间,可以配置RMAN的归档日志删除策略: ```sql RMAN> configure archivelog deletion policy to applied on standby; ``` 这将确保归档日志文件在备用数据库上应用后自动删除。 ### 示例:清理无效归档日志条目 ```sql RMAN> run { crosscheck archivelog all; delete expired archivelog all; } ``` 此脚本会检查所有归档日志文件的状态,并删除RMAN目录中无效的条目。 ### 示例:重新注册归档日志文件 ```sql RMAN> catalog start with '/new/archivelog/path/'; ``` 此命令会重新注册指定路径下的所有归档日志文件。 ### 示例:配置归档日志删除策略 ```sql RMAN> configure archivelog deletion policy to applied on standby; ``` 此命令配置归档日志删除策略,确保归档日志文件在备用数据库上应用后自动删除。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值