OraFAQ Forum: Backup & Recovery » Can not delete obsolete !

Home » RDBMS Server » Backup & Recovery » Can not delete obsolete !

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can not delete obsolete ! [message #624886]

Sat, 27 September 2014 11:02

kids114
Messages: 4
Registered: July 2010
Location: VietNam

Junior Member

Dear all,

I get a problem with execute delete obsolete command in Rman.

I did step by step:

1. Crosscheck backup.
2. Delete noprompt expired backup.
3. Delete noprompt obsolete;

And then I get the message below:

RMAN-06207: WARNING: 10 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: Datafile Copy +DG_01/orcl/datafile/datafile01.101.845640741
RMAN-06207: WARNING: 10 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: Datafile Copy +DG_01/orcl/datafile/datafile02.134.845640743
RMAN-06214: Datafile Copy +DG_01/orcl/datafile/datafile03.165.845641001
RMAN-06214: Datafile Copy +DG_01/orcl/datafile/datafile04.166.845641091

Note:
The datafiles above is online for read/write that i copied from +DG_02 to +DG_01 with command:

rman> copy datafile ... '+DG_02..' to ... '+DG_01...'
sql> alter database rename file '+DG_02..' to ... '+DG_01..'

please help me solve the issue.

Thanks so much!

Report message to a moderator