Rman Crosscheck删除失效归档-备份恢复

当手工删除了归档日志以后，Rman备份会检测到日志缺失，从而无法进一步继续执行。

    所以此时需要手工执行crosscheck过程，之后Rman备份可以恢复正常。

    1.Crosscheck日志

$ rman target / Recovery Manager: Release 9.2.0.4.0 - 64bit Production Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved. connected to target database: AVATAR2 (DBID=2480694409) RMAN> crosscheck archivelog all; using target database controlfile instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=25 devtype=DISK validation failed for archived log archive log filename=/opt/oracle/oradata/avatar2/archive/1_2714.dbf recid=2702 stamp=545107659 validation failed for archived log archive log filename=/opt/oracle/oradata/avatar2/archive/1_2715.dbf recid=2703 stamp=545108268 ........... validation failed for archived log archive log filename=/opt/oracle/oradata/avatar2/archive/1_2985.dbf recid=2973 stamp=545399327 validation succeeded for archived log archive log filename=/opt/oracle/oradata/avatar2/archive/1_2986.dbf recid=2974 stamp=545400820 validation succeeded for archived log archive log filename=/opt/oracle/oradata/avatar2/archive/1_2987.dbf recid=2975 stamp=545401757 validation succeeded for archived log archive log filename=/opt/oracle/oradata/avatar2/archive/1_2988.dbf recid=2976 stamp=545402716 validation succeeded for archived log archive log filename=/opt/oracle/oradata/avatar2/archive/1_2989.dbf recid=2977 stamp=545403661 validation succeeded for archived log archive log filename=/opt/oracle/oradata/avatar2/archive/1_2990.dbf recid=2978 stamp=545404946 validation succeeded for archived log archive log filename=/opt/oracle/oradata/avatar2/archive/1_2991.dbf recid=2979 stamp=545406220 Crosschecked 278 objects RMAN>

    2.使用delete expired archivelog all 命令删除所有过期归档日志：

RMAN> delete expired archivelog all; released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=12 devtype=DISK List of Archived Log Copies Key     Thrd Seq     S Low Time  Name ------- ---- ------- - --------- ---- 376     1    2714     X 23-NOV-04 =/opt/oracle/oradata/avatar2/archive/1_2714.dbf .....

    3.简要介绍一下report obsolete命令

    使用report obsolete命令报告过期备份

RMAN> report obsolete; RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 1 Report of obsolete backups and copies Type                 Key    Completion Time    Filename/Handle -------------------- ------ ------------------ -------------------- Backup Set           125    01-NOV-04           Backup Piece       125    01-NOV-04          /data1/oracle/orabak/full_1_541045804 Backup Set           131    04-NOV-04           Backup Piece       131    04-NOV-04          /data1/oracle/orabak/full_AVATAR2_20041104_131 .... Backup Set           173    06-DEC-04           Backup Piece       173    06-DEC-04          /data1/oracle/orabak/full_AVATAR2_20041206_173 Backup Set           179    11-DEC-04           Backup Piece       179    11-DEC-04          /data1/oracle/orabak/arch544588206.arc .....   Backup Piece       189    17-DEC-04          /data1/oracle/orabak/arch545106606.arc Backup Set           190    17-DEC-04           Backup Piece       190    17-DEC-04          /data1/oracle/orabak/arch545106665.arc Backup Set           191    20-DEC-04           Backup Piece       191    20-DEC-04          /data1/oracle/orabak/arch_AVATAR2_20041220_194 Archive Log          2973   20-DEC-04          /opt/oracle/oradata/avatar2/archive/1_2985.dbf Archive Log          2971   20-DEC-04          /opt/oracle/oradata/avatar2/archive/1_2984.dbf ..... Archive Log          2705   17-DEC-04          /opt/oracle/oradata/avatar2/archive/1_2717.dbf Archive Log          2704   17-DEC-04          /opt/oracle/oradata/avatar2/archive/1_2716.dbf Archive Log          2703   17-DEC-04          /opt/oracle/oradata/avatar2/archive/1_2715.dbf Archive Log          2702   17-DEC-04          /opt/oracle/oradata/avatar2/archive/1_2714.dbf

    4.使用delete obsolete命令删除过期备份：

RMAN> delete obsolete; RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 1 using channel ORA_DISK_1 Deleting the following obsolete backups and copies: Type Key Completion Time Filename/Handle -------------------- ------ ------------------ -------------------- Backup Set 125 01-NOV-04 Backup Piece 125 01-NOV-04 /data1/oracle/orabak/full_1_541045804 .... Archive Log 2704 17-DEC-04 /opt/oracle/oradata/avatar2/archive/1_2716.dbf Archive Log 2703 17-DEC-04 /opt/oracle/oradata/avatar2/archive/1_2715.dbf Archive Log 2702 17-DEC-04 /opt/oracle/oradata/avatar2/archive/1_2714.dbf Do you really want to delete the above objects (enter YES or NO)? yes deleted backup piece backup piece handle=/data1/oracle/orabak/full_AVATAR2_20041206_173 recid=173 stamp=544156241 ..... deleted archive log archive log filename=/opt/oracle/oradata/avatar2/archive/1_2715.dbf recid=2703 stamp=545108268 deleted archive log archive log filename=/opt/oracle/oradata/avatar2/archive/1_2714.dbf recid=2702 stamp=545107659 Deleted 286 objects RMAN> crosscheck archivelog all; released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=19 devtype=DISK specification does not match any archive log in the recovery catalog

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/90618/viewspace-668869/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/90618/viewspace-668869/