Archive

Posts Tagged ‘RMAN’

RMAN-06207: WARNING: 20 objects could not be deleted for DISK channel(s)

April 8, 2011 Leave a comment

Symptoms

RMAN-06207: WARNING: 20 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 /rcdb/oracle/bkup/viqa/bkup_VI_4710_1_746949640.dat RMAN-06214: Backup Piece /rcdb/oracle/bkup/viqa/bkup_VI_4711_1_746949640.dat RMAN-06214: Backup Piece /rcdb/oracle/bkup/viqa/bkup_VI_4712_1_746951040.dat RMAN-06214: Backup Piece /rcdb/oracle/bkup/viqa/bkup_VI_4713_1_746951067.dat RMAN-06214: Backup Piece /rcdb/oracle/bkup/viqa/bkup_VI_4714_1_746952417.datRMAN-06214: Backup Piece /rcdb/oracle/bkup/viqa/bkup_VI_4715_1_746952475.dat RMAN-06214: Backup Piece /rcdb/oracle/bkup/viqa/bkup_VI_4716_1_746953824.dat

Cause

This was caused by removing the backupset in OS before, so RMAN reported mismatched status due to the backupsets were missing.

Fix Procedures

Do crosscheck the missing backupsets to update RMAN catalog. The following is example

RMAN>  CROSSCHECK  backupset;

using channel ORA_DISK_1
using channel ORA_DISK_2
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/rcdb/oracle/bkup/viqa/bkup_VI_4863_1_747834472.dat recid=4850 stamp=747834474
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/rcdb/oracle/bkup/viqa/bkup_VI_4862_1_747834472.dat recid=4851 stamp=747834474
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/rcdb/oracle/bkup/viqa/bkup_VI_4864_1_747836002.dat recid=4852 stamp=747836004
crosschecked backup piece: found to be ‘AVAILABLE’

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
using channel ORA_DISK_2
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
——————– —— —————— ——————–
Backup Set           4706   28-MAR-11
Backup Piece       4706   28-MAR-11          /rcdb/oracle/bkup/viqa/bkup_VI_4710_1_746949640.dat
Backup Set           4707   28-MAR-11
Backup Piece       4707   28-MAR-11          /rcdb/oracle/bkup/viqa/bkup_VI_4711_1_746949640.dat
Backup Set           4708   28-MAR-11
Backup Piece       4708   28-MAR-11          /rcdb/oracle/bkup/viqa/bkup_VI_4712_1_746951040.dat
Backup Set           4709   28-MAR-11

Advertisements
Categories: RMAN, Uncategorized Tags:

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

March 15, 2010 1 comment

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

Categories: TroubleShooting Tags: