问题描述,在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/
,如需转载,请注明出处,否则将追究法律责任。