Home > TroubleShooting > RMAN-06207: WARNING: 2 objects could not be deleted for DISK channel(s) due to mismatched status

RMAN-06207: WARNING: 2 objects could not be deleted for DISK channel(s) due to mismatched status

Problem Symptoms

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: Backup Piece    /export/home/oracle/bkup/vstbqa/bkup_VSTBQA_2_1_703089741.dat
RMAN-06214: Backup Piece    /export/home/oracle/bkup/vstbqa/bkup_VSTBQA_3_1_703089956.dat

Fix

RMAN> crosscheck backup;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=264 instance=vstbqa1 device type=DISK
crosschecked backup piece: found to be ‘EXPIRED’
backup piece handle=/export/home/oracle/bkup/vstbqa/bkup_VSTBQA_2_1_703089741.dat RECID=2 STAMP=703089744
crosschecked backup piece: found to be ‘EXPIRED’
backup piece handle=/export/home/oracle/bkup/vstbqa/bkup_VSTBQA_3_1_703089956.dat RECID=3 STAMP=703089956
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/bkuppool/oracle/bkup/databases/vstbqa/bkup_VSTBQA_250_1_713655198.dat RECID=248 STAMP=713655198
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/bkuppool/oracle/bkup/databases/vstbqa/bkup_VSTBQA_251_1_713655384.dat RECID=249 STAMP=713655385
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/bkuppool/oracle/bkup/databases/vstbqa/bkup_ctl_c-3621525582-20100314-00.dat RECID=250 STAMP=713655386
Crosschecked 5 objects

RMAN> delete expired backup;

using channel ORA_DISK_1

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
——- ——- — — ———– ———– ———-
2       2       1   1   EXPIRED     DISK        /export/home/oracle/bkup/vstbqa/bkup_VSTBQA_2_1_703089741.dat
3       3       1   1   EXPIRED     DISK        /export/home/oracle/bkup/vstbqa/bkup_VSTBQA_3_1_703089956.dat

Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=/export/home/oracle/bkup/vstbqa/bkup_VSTBQA_2_1_703089741.dat RECID=2 STAMP=703089744
deleted backup piece
backup piece handle=/export/home/oracle/bkup/vstbqa/bkup_VSTBQA_3_1_703089956.dat RECID=3 STAMP=703089956
Deleted 2 EXPIRED objects

About these ads
Categories: TroubleShooting Tags:
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: