Rman Crosscheck删除失效归档

红太狼 2022-06-16 11:13 219阅读 0赞

文章原地址：http://www.eygle.com/archives/2004/12/rman\_crosscheck.html

手工删除 归档文件后需要进行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  
>

\-The End-