fishcat论 RMAN使用crosscheck archivelog all注意

本帖最后由 fishcat 于 2013-1-30 10:20 编辑

fishcat论 RMAN使用crosscheck archivelog all注意;

RAC环境当归档目录在本地的情况下,在一个节点crosscheck archivelog all会把另外一个节点的日志验证failed,然后delete expired archivelog all 则会将RMAN中这些日志的信息清除
导致备份的时候不会备份这些日志,却不报错。而实际情况是这些归档是存在的。

RMAN>  crosscheck archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=128 instance=rac1 devtype=DISK
validation succeeded for archived log
archive log filename=/archive/rac1/1_51_804551593.dbf recid=63 stamp=805063746
validation succeeded for archived log
archive log filename=/archive/rac1/1_52_804551593.dbf recid=66 stamp=805848926
validation failed for archived log
archive log filename=/archive/rac2/2_32_804551593.dbf recid=64 stamp=805063781
validation failed for archived log
archive log filename=/archive/rac2/2_33_804551593.dbf recid=65 stamp=805848931
Crosschecked 4 objects


RMAN> delete expired archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=128 instance=rac1 devtype=DISK

List of Archived Log Copies
Key     Thrd Seq     S Low Time  Name
------- ---- ------- - --------- ----
64      2    32      X 18-JAN-13 /archive/rac2/2_32_804551593.dbf
65      2    33      X 18-JAN-13 /archive/rac2/2_33_804551593.dbf

Do you really want to delete the above objects (enter YES or NO)? no
标签: 暂无标签
fishcat

写了 55 篇文章,拥有财富 503,被 40 人关注

oracle爱好者
转播转播 分享分享 分享淘帖
回复

使用道具

成为第一个吐槽的人

您需要登录后才可以回帖 登录 | 加入社区

本版积分规则

意见
反馈