Hendry's "Oracle and SQL Server DBA Stuff"

Oracle and SQL Server Database Solutions for DBA's please visit http://hendrydba.com for the latest posts. Thanks

RMAN Delete failures due to Mismatched status RMAN-06207,RMAN-06214

Posted by Hendry chinnapparaj on May 31, 2010

Problem

————

The Delete obsolete command could not delete some files due to mismatched status.

RMAN> delete obsolete;

RMAN retention policy will be applied to the command

RMAN retention policy is set to recovery window of 30 days

allocated channel: ORA_SBT_TAPE_1

channel ORA_SBT_TAPE_1: sid=760 devtype=SBT_TAPE

channel ORA_SBT_TAPE_1: Data Protection for Oracle: version 5.4.1.0

using channel ORA_DISK_1

Deleting the following obsolete backups and copies:

Type                 Key    Completion Time    Filename/Handle

——————– —— —————— ——————–

Backup Set           16778666 30-04-2010 10:21:19

Backup Piece       16778668 30-04-2010 10:21:19 CF_c-183511008-20100430-04

Backup Set           16779716 30-04-2010 12:27:07

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

RMAN-06207: WARNING: 13 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    /u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20091130-00

RMAN-06214: Backup Piece    /u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20091130-01

RMAN-06214: Backup Piece    /u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20091130-02

RMAN-06214: Backup Piece    /u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20091208-01

RMAN-06214: Backup Piece    /u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20091218-00

RMAN-06214: Backup Piece    /u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20091218-01

RMAN-06214: Backup Piece    /u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20091218-02

RMAN-06214: Backup Piece    /u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20091218-03

RMAN-06214: Backup Piece    /u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20100112-00

RMAN-06214: Backup Piece    /u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20100112-01

RMAN-06214: Backup Piece    /u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20100112-02

RMAN-06214: Backup Piece    /u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20100112-03

RMAN-06214: Backup Piece    /u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20100112-04

Solution

———–

Do a crosscheck of the backuppiece which has the issue a

RMAN> crosscheck backuppiece ‘/u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20091130-00’;

using channel ORA_SBT_TAPE_1

using channel ORA_DISK_1

crosschecked backup piece: found to be ‘EXPIRED’

backup piece handle=/u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20091130-00 recid=18616 stamp=704280485

Crosschecked 1 objects

crosscheck backuppiece ‘/u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20091130-01’;

crosscheck backuppiece ‘/u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20091130-02’;

crosscheck backuppiece ‘/u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20091208-01’;

crosscheck backuppiece ‘/u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20091218-00’;

crosscheck backuppiece ‘/u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20091218-01’;

crosscheck backuppiece ‘/u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20091218-02’;

crosscheck backuppiece ‘/u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20091218-03’;

crosscheck backuppiece ‘/u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20100112-00’;

crosscheck backuppiece ‘/u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20100112-01’;

crosscheck backuppiece ‘/u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20100112-02’;

crosscheck backuppiece ‘/u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20100112-03’;

crosscheck backuppiece ‘/u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20100112-04’;

crosscheck backuppiece ”;

crosscheck backuppiece ”;

After crosscheck, run the delete obsolete again

RMAN> delete obsolete;

RMAN retention policy will be applied to the command

RMAN retention policy is set to recovery window of 30 days

using channel ORA_SBT_TAPE_1

using channel ORA_DISK_1

Deleting the following obsolete backups and copies:

Type                 Key    Completion Time    Filename/Handle

——————– —— —————— ——————–

Backup Set           16795362 01-05-2010 10:21:30

Backup Piece       16795364 01-05-2010 10:21:30 CF_c-183511008-20100501-05

Backup Set           17277715 30-11-2009 09:28:06

Backup Piece       17277743 30-11-2009 09:28:06 /u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20091130-00

Backup Set           17277716 30-11-2009 09:29:02

backup piece handle=/u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20091130-00 recid=18616 stamp=704280485

deleted backup piece

backup piece handle=/u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20091130-01 recid=18617 stamp=704280541

deleted backup piece

backup piece handle=/u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20091130-02 recid=18618 stamp=704280591

deleted backup

RMAN> delete obsolete;

RMAN retention policy will be applied to the command

RMAN retention policy is set to recovery window of 30 days

using channel ORA_SBT_TAPE_1

using channel ORA_DISK_1

no obsolete backups found

other commands to delete are

————————————–

RMAN> crosscheck backuppiece ‘/u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20100511-49’;

allocated channel: ORA_SBT_TAPE_1

channel ORA_SBT_TAPE_1: sid=689 devtype=SBT_TAPE

channel ORA_SBT_TAPE_1: Data Protection for Oracle: version 5.4.1.0

using channel ORA_DISK_1

crosschecked backup piece: found to be ‘AVAILABLE’

backup piece handle=/u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20100511-49 recid=25248 stamp=718721036

Crosschecked 1 objects

RMAN> delete force backuppiece ‘/u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20100511-49’;

using channel ORA_SBT_TAPE_1

using channel ORA_DISK_1

List of Backup Pieces

BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name

——- ——- — — ———– ———– ———-

16971260 16971238 1   1   AVAILABLE   DISK        /u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20100511-49

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

deleted backup piece

backup piece handle=/u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20100511-49 recid=25248 stamp=718721036

Deleted 1 objects

RMAN> delete noprompt backuppiece       ‘/u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20100511-08’;

using channel ORA_SBT_TAPE_1
using channel ORA_DISK_1

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
——- ——- — — ———– ———– ———-
16970426 16970385 1   1   AVAILABLE   DISK        /u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20100511-08
deleted backup piece
backup piece handle=/u01/oracle/product/10.2/db_1/dbs/CF_c-183511008-20100511-08 recid=25182 stamp=718719698
Deleted 1 objects

Advertisements

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

 
%d bloggers like this: