Home » RDBMS Server » Backup & Recovery » Can not delete obsolete !
Can not delete obsolete ! [message #624886] Sat, 27 September 2014 11:02 Go to next message
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!
Re: Can not delete obsolete ! [message #624887 is a reply to message #624886] Sat, 27 September 2014 11:06 Go to previous messageGo to next message
BlackSwan
Messages: 25796
Registered: January 2009
Location: SoCal
Senior Member
what results after you do as shown below?

http://docs.oracle.com/database/121/ADMQS/backrest.htm#ADMQS0954
Re: Can not delete obsolete ! [message #624888 is a reply to message #624887] Sat, 27 September 2014 11:09 Go to previous message
kids114
Messages: 4
Registered: July 2010
Location: VietNam
Junior Member

I Mean, The datafiles is online for read/write. I can not delete.

I wonder Oralce report these datafiles is obsolete ?

[Updated on: Sat, 27 September 2014 11:11]

Report message to a moderator

Previous Topic: rman restore failure rdba: 0x01c00001
Next Topic: archive backup deletion
Goto Forum:
  


Current Time: Fri Jan 19 18:29:16 CST 2018

Total time taken to generate the page: 0.01694 seconds