ITPub博客

首页 > 数据库 > Oracle > RMAN-06207 and RMAN-06208 deleting RMAN backups

RMAN-06207 and RMAN-06208 deleting RMAN backups

原创 Oracle 作者:tianya_2011 时间:2014-06-18 16:21:51 0 删除 编辑
问题描述,在RMAN备份日志中报如下错误:

RMAN-06207: WARNING: 3 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: Backup Piece    /backdb/arch-s8607-p1-t806378447_20130203.bak
RMAN-06214: Backup Piece    /backdb/arch-s8603-p1-t806378447_20130203.bak
RMAN-06214: Backup Piece    /backdb/arch-s8602-p1-t806378447_20130203.bak

参照MOS:
Symptoms:
~~~~~~~~~~
1) RMAN-6207 and RMAN-6208 errors when issuing 'delete obsolete' in 10g

2) The target database alert log shows:

 WARNING: Files may exists in db_recovery_file_dest that are not known to the 
 database. Use the RMAN command CATALOG RECOVERY AREA to re-catalog any such 
 files.

 One of the following events caused this:
 1. A backup controlfile was restored.
 2. A standby controlfile was restored.
 3. The controlfile was re-created.
 4. db_recovery_file_dest had previously been enabled and then disabled.


Changes:
~~~~~~~~~
Backups from the Flash Recovery Area have been deleted manually (operating 
system remove command for example) and /or backups are taken using nocatalog 
mode.


Cause:
~~~~~~~
1) The backups yet remaining in the Flash Recovery Area are not known 
   to the rebuilt controlfile. 

2) Backups manually removed are, as far as the database is concerned, using 
   space and will cause a mis-match condition. 

Fix
~~~~~
The fix for a rebuild of the controlfile is stated in the alert log (as 
already shown above) :

"Use the RMAN command CATALOG RECOVERY AREA to re-catalog any such files."

For files manually deleted from the operating system run the CROSSCHECK 
command.

问题解决:

$cusdb/backdb>rman target / 
Recovery Manager: Release 10.2.0.5.0 - Production on De  23 06:31:39 2014
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
connected to target database: CUSDB (DBID=2658984516)

RMAN> crosscheck backuppiece '/backdb/arch-s8607-p1-t806378447_20130203.bak';
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1802 devtype=DISK
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/backdb/arch-s8607-p1-t806378447_20130203.bak recid=8590 stamp=806378447
Crosschecked 1 objects

RMAN> crosscheck backuppiece '/backdb/arch-s8603-p1-t806378447_20130203.bak' ;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/backdb/arch-s8603-p1-t806378447_20130203.bak recid=8591 stamp=806378447
Crosschecked 1 objects

RMAN> crosscheck backuppiece '/backdb/arch-s8602-p1-t806378447_20130203.bak';
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/backdb/arch-s8602-p1-t806378447_20130203.bak recid=8592 stamp=806378447
Crosschecked 1 objects


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           46556  03-2?? -13        
  Backup Piece       46564  03-2?? -13         /backdb/arch-s8607-p1-t806378447_20130203.bak
Backup Set           46557  03-2?? -13        
  Backup Piece       46565  03-2?? -13         /backdb/arch-s8603-p1-t806378447_20130203.bak
Backup Set           46558  03-2?? -13        
  Backup Piece       46566  03-2?? -13         /backdb/arch-s8602-p1-t806378447_20130203.bak

Do you really want to delete the above objects (enter YES or NO)? yes

deleted backup piece
backup piece handle=/backdb/arch-s8607-p1-t806378447_20130203.bak recid=8590 stamp=806378447
deleted backup piece
backup piece handle=/backdb/arch-s8603-p1-t806378447_20130203.bak recid=8591 stamp=806378447
deleted backup piece
backup piece handle=/backdb/arch-s8602-p1-t806378447_20130203.bak recid=8592 stamp=806378447
Deleted 3 objects


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

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

注册时间:2011-04-11

  • 博文量
    85
  • 访问量
    631249