Home » RDBMS Server » Backup & Recovery » How to delete OBSOLETE (RMAN)
How to delete OBSOLETE (RMAN) [message #257478] Wed, 08 August 2007 08:01 Go to next message
aslamkhalife
Messages: 42
Registered: July 2007
Location: India
Member
Hi

I am working on Oracle 10g Rel 2.

I am unable to delete the OBSOLETE from rman

previously my senior use to take backup on remote m/c.


While giving the command


rman>delete obsolete


RMAN-06207: WARNING: 228 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 \\192.168.1.162\BACKUP\FINPROD\DB_T619092194_S12_P1
RMAN-06214: Backup Piece \\192.168.1.162\BACKUP\FINPROD\DB_T619093015_S13_P1



Please guide for this ERROR
Re: How to delete OBSOLETE (RMAN) [message #257492 is a reply to message #257478] Wed, 08 August 2007 08:30 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Use CROSSCHECK command to fix status

All is said in the message: you have to first use the crosschek command.

Regards
Michel
Re: How to delete OBSOLETE (RMAN) [message #257497 is a reply to message #257492] Wed, 08 August 2007 08:37 Go to previous messageGo to next message
aslamkhalife
Messages: 42
Registered: July 2007
Location: India
Member
Hi Michel

I am unable to get what you want me to do.

I used CROSSCHECK command and got this

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=F:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\FINPROD\BACKUPSET\2007_08_08\O1_MF_
ANNNN_TAG20070808T161941_3CM7Y83X_.BKP recid=281 stamp=630087584
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=F:\RMAN\DB_T630090496_S317_P1 recid=282 stamp=630090502
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=F:\RMAN\DB_T630091976_S318_P1 recid=283 stamp=630091990
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=F:\RMAN\DB_T630093412_S319_P1 recid=284 stamp=630093419
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=F:\RMAN\DB_T630095082_S320_P1 recid=285 stamp=630095083
Crosschecked 5 objects
Re: How to delete OBSOLETE (RMAN) [message #257504 is a reply to message #257497] Wed, 08 August 2007 08:50 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Then you can use "delete obsolete".

Regards
Michel
Re: How to delete OBSOLETE (RMAN) [message #257667 is a reply to message #257504] Wed, 08 August 2007 23:50 Go to previous messageGo to next message
aslamkhalife
Messages: 42
Registered: July 2007
Location: India
Member
Hi

Sorry for late reply, but am unable to delete the obsolete data.

When using DELETE OBSOLETE command i get this error

RMAN-06207: WARNING: 228 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 \\192.168.1.162\BACKUP\FINPROD\DB_T619092194_S12_P1
RMAN-06214: Backup Piece \\192.168.1.162\BACKUP\FINPROD\DB_T619093015_S13_P1
Re: How to delete OBSOLETE (RMAN) [message #257681 is a reply to message #257667] Thu, 09 August 2007 00:25 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is this a copy of your first post or did you retry it?

Regards
Michel
Re: How to delete OBSOLETE (RMAN) [message #257686 is a reply to message #257681] Thu, 09 August 2007 00:33 Go to previous messageGo to next message
aslamkhalife
Messages: 42
Registered: July 2007
Location: India
Member
Hi

Its not copy of my first mail.

As you suggested that to delete OBSOLETE

I tried it but i got this again

RMAN-06207: WARNING: 228 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 \\192.168.1.162\BACKUP\FINPROD\DB_T619092194_S12_P1
RMAN-06214: Backup Piece \\192.168.1.162\BACKUP\FINPROD\DB_T619093015_S13_P1
Re: How to delete OBSOLETE (RMAN) [message #257933 is a reply to message #257686] Thu, 09 August 2007 11:24 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Did You Took backup On NFS?
Is that Device Is mounted Here?
Re: How to delete OBSOLETE (RMAN) [message #259661 is a reply to message #257686] Thu, 16 August 2007 04:04 Go to previous messageGo to next message
meggens
Messages: 57
Registered: February 2007
Location: Netherlands
Member
RMAN-06214: Backup Piece \\192.168.1.162\BACKUP\FINPROD\DB_T619092194_S12_P1
RMAN-06214: Backup Piece \\192.168.1.162\BACKUP\FINPROD\DB_T619093015_S13_P1


looks your backup are on a windows share.
Make sure you have access to the share.
When you have access to the share and the backup pieces are there the 'delete obsolete' should work.

when you have access to the share and the backup pieces are no longer there do a
crosscheck backup;

then perform a 'delete noprompt expired backup'
Re: How to delete OBSOLETE (RMAN) [message #264109 is a reply to message #259661] Fri, 31 August 2007 17:28 Go to previous messageGo to next message
bc_buckaroo
Messages: 2
Registered: February 2007
Junior Member
you might try this crosscheck:
RMAN>crosscheck backuppiece '\\192.168.1.162\BACKUP\FINPROD\DB_T619092194_S12_P1';

and

RMAN>crosscheck backuppiece '\\192.168.1.162\BACKUP\FINPROD\DB_T619093015_S13_P1';

then

RMAN>delete obsolete;
Re: How to delete OBSOLETE (RMAN) [message #420706 is a reply to message #264109] Tue, 01 September 2009 12:45 Go to previous messageGo to next message
vandt
Messages: 2
Registered: August 2009
Junior Member
Hi everyone,
First of all, my english is not good.

I have a problem as follow:
I want to delete obsolete with command
delete noprompt obsolete;

but it raise a error

RMAN> delete noprompt obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
using channel ORA_DISK_1
using channel ORA_DISK_2
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Datafile Copy 4 09-01-17 E:\DA2.DBF

RMAN-06207: WARNING: 1 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 E:\DA2.DBF


I knew that the E:\DA2.DBF file is no use for my database and it did not exist.
Re: How to delete OBSOLETE (RMAN) [message #421047 is a reply to message #420706] Thu, 03 September 2009 19:48 Go to previous messageGo to next message
vandt
Messages: 2
Registered: August 2009
Junior Member
why no one answer my question.
However I have solved it by my own way.
Use crosscheck copy before deleting
RMAN>crosscheck copy
RMAN>delete noprompt obsolete;
Re: How to delete OBSOLETE (RMAN) [message #421063 is a reply to message #421047] Fri, 04 September 2009 00:50 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
why no one answer my question.

No one OWE you any answer.
One may have other things to do like working, reading, going to theater, playing with children... ot simply sleeping.

Anyway, thanks for the feedback.

Regards
Michel
Re: How to delete OBSOLETE (RMAN) [message #546465 is a reply to message #264109] Tue, 06 March 2012 21:52 Go to previous messageGo to next message
swat448
Messages: 5
Registered: November 2011
Location: Bangalore
Junior Member
crosscheck backuppeice 'missing file';

delete obsolete;

do this for all the missing backup peices and this works. Thanks.

- Swathi.
Re: How to delete OBSOLETE (RMAN) [message #546470 is a reply to message #546465] Tue, 06 March 2012 23:20 Go to previous message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why do you repeat the same answer 2.5 years after?

Regards
Michel
Previous Topic: incremental backup
Next Topic: RMAN Restore to another Device
Goto Forum:
  


Current Time: Tue Sep 27 17:55:50 CDT 2016

Total time taken to generate the page: 0.12893 seconds