Home > TroubleShooting > Fix mismatched backup pieces at RMAN

Fix mismatched backup pieces at RMAN

Symptoms

RMAN-06207: WARNING: 119 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/sgptqa/bkup_SGPTQA_611_1_708325704.dat
RMAN-06214: Backup Piece    /export/home/oracle/bkup/sgptqa/bkup_SGPTQA_612_1_708325913.dat
RMAN-06214: Backup Piece    /export/home/oracle/bkup/sgptqa/bkup_ctl_c-3621525582-20100115-00.dat
RMAN-06214: Backup Piece    /export/home/oracle/bkup/sgptqa/bkup_SGPTQA_627_1_708411652.dat
RMAN-06214: Backup Piece    /export/home/oracle/bkup/sgptqa/bkup_SGPTQA_628_1_708411719.dat
RMAN-06214: Backup Piece    /export/home/oracle/bkup/sgptqa/bkup_SGPTQA_629_1_708411786.dat
RMAN-06214: Backup Piece    /export/home/oracle/bkup/sgptqa/bkup_SGPTQA_630_1_708411852.dat
RMAN-06214: Backup Piece    /export/home/oracle/bkup/sgptqa/bkup_SGPTQA_631_1_708411918.dat
RMAN-06214: Backup Piece    /export/home/oracle/bkup/sgptqa/bkup_SGPTQA_632_1_708411985.dat
RMAN-06214: Backup Piece    /export/home/oracle/bkup/sgptqa/bkup_SGPTQA_633_1_708412041.dat
RMAN-06214: Backup Piece    /export/home/oracle/bkup/sgptqa/bkup_SGPTQA_634_1_708412098.dat
RMAN-06214: Backup Piece    /export/home/oracle/bkup/sgptqa/bkup_SGPTQA_635_1_708412109.dat

Fixed Procedure

$ env|grep SID
ORACLE_SID=cviqa1
$ ORACLE_SID=sgptqa1;export ORACLE_SID
$ rman target /

Recovery Manager: Release 11.1.0.7.0 – Production on Mon Feb 1 12:33:04 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: SGPTQA (DBID=3621525582)

RMAN> crosscheck backup;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=273 instance=sgptqa1 device type=DISK
crosschecked backup piece: found to be ‘EXPIRED’
backup piece handle=/export/home/oracle/bkup/sgptqa/bkup_SGPTQA_611_1_708325704.dat RECID=611 STAMP=708325707
crosschecked backup piece: found to be ‘EXPIRED’
backup piece handle=/export/home/oracle/bkup/sgptqa/bkup_SGPTQA_612_1_708325913.dat RECID=612 STAMP=708325913
crosschecked backup piece: found to be ‘EXPIRED’
backup piece handle=/export/home/oracle/bkup/sgptqa/bkup_ctl_c-3621525582-20100115-00.dat RECID=613 STAMP=708325915
crosschecked backup piece: found to be ‘EXPIRED’
backup piece handle=/export/home/oracle/bkup/sgptqa/bkup_SGPTQA_627_1_708411652.dat RECID=627 STAMP=708411653
crosschecked backup piece: found to be ‘EXPIRED’
backup piece handle=/export/home/oracle/bkup/sgptqa/bkup_SGPTQA_628_1_708411719.dat RECID=628 STAMP=708411720
crosschecked backup piece: found to be ‘EXPIRED’

Advertisements
Categories: TroubleShooting
  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

%d bloggers like this: