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

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

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:
  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: