| How to delete OBSOLETE (RMAN) [message #257478] |
Wed, 08 August 2007 08:01  |
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 #257497 is a reply to message #257492] |
Wed, 08 August 2007 08:37  |
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 #257667 is a reply to message #257504] |
Wed, 08 August 2007 23:50 |
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 #257686 is a reply to message #257681] |
Thu, 09 August 2007 00:33 |
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 #259661 is a reply to message #257686] |
Thu, 16 August 2007 04:04 |
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 |
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 |
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.
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
