ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Fix RMAN-06207

Fix RMAN-06207

原创 Linux操作系统 作者:lwitpub 时间:2011-03-22 13:45:33 0 删除 编辑
The script. of RMAN backup is as follows:
run
{
BACKUP FORMAT '/home/oracle/backup_rman/dbf_%U' DATABASE TAG Full_bk;
BACKUP CURRENT ControlFile FORMAT '/home/oracle/backup_rman/ctl_%U';
BACKUP FORMAT '/home/oracle/backup_rman/arch_%U' ARCHIVELOG ALL TAG Archivelog_bk;
RESTORE DATABASE VALIDATE;
CROSSCHECK BACKUP OF DATABASE;
REPORT OBSOLETE;
}
LIST BACKUP SUMMARY;
DELETE NOPROMPT OBSOLETE;
CROSSCHECK ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-8';
Errors are as follows:
RMAN-06207: WARNING: 2 objects could not be deleted for DISK channel(s) due
RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212:   Object Type   Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Archivelog      +BACKUP_DG/pwiuim/archivelog/2011_03_08/thread_3_seq_1545.5219.745259239
RMAN-06214: Archivelog      +BACKUP_DG/pwiuim/archivelog/2011_03_08/thread_1_seq_1626.3205.745259239
 
#如果Object Type是Backup Piece, 那么执行
MAN> CROSSCHECK BACKUP;
#因为这里Object Type都是Archivelog, 所以
RMAN> CROSSCHECK Archivelog all;
#或者指定过期日期
RMAN> CROSSCHECK ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-1';
...............................
Crosschecked 22 objects
RMAN> REPORT OBSOLETE;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log          9670   08-MAR-11          +BACKUP_DG/pwiuim/archivelog/2011_03_08/thread_3_seq_1545.5219.745259239
Archive Log          9669   08-MAR-11          +BACKUP_DG/pwiuim/archivelog/2011_03_08/thread_1_seq_1626.3205.745259239
 
RMAN> DELETE NOPROMPT OBSOLETE;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log          9670   08-MAR-11          +BACKUP_DG/pwiuim/archivelog/2011_03_08/thread_3_seq_1545.5219.745259239
Archive Log          9669   08-MAR-11          +BACKUP_DG/pwiuim/archivelog/2011_03_08/thread_1_seq_1626.3205.745259239
deleted archive log
archive log filename=+BACKUP_DG/pwiuim/archivelog/2011_03_08/thread_3_seq_1545.5219.745259239 recid=9670 stamp=745259243
deleted archive log
archive log filename=+BACKUP_DG/pwiuim/archivelog/2011_03_08/thread_1_seq_1626.3205.745259239 recid=9669 stamp=745259243
Deleted 2 objects
RMAN> REPORT OBSOLETE;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
no obsolete backups found

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

请登录后发表评论 登录
全部评论

注册时间:2009-05-08

  • 博文量
    107
  • 访问量
    389397