OraFAQ Forum: Backup & Recovery » Unable to issue DELETE OBSOLETE....in RMAN

Home » RDBMS Server » Backup & Recovery » Unable to issue DELETE OBSOLETE....in RMAN (Oracle 10.2.0.1.0 o/s: hp-ux:11.23)

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

Unable to issue DELETE OBSOLETE....in RMAN [message #381727]

Mon, 19 January 2009 08:19

kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI

Senior Member

Dear sir,

when we issue
RMAN>report obsolete;.......
it is properly listing backup sets which are obsolete.

but when we issue DELETE OBSOLETE, we are getting below error at the bottom of the output

RMAN> delete obsolete;

Backup Set 3519 2009-01-19:19:14:49
Backup Piece 3526 2009-01-19:19:14:49 C:\RMAN_BACKUP\RB_SBIWILL1_676581286_53_1
Backup Set 3520 2009-01-19:19:14:50
Backup Piece 3527 2009-01-19:19:14:50 C:\RMAN_BACKUP\RB_SBIWILL1_676581286_52_1
Backup Set 3657 2009-01-19:19:35:52
Backup Piece 3668 2009-01-19:19:35:52 1mk57kv9_1_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 01/19/2009 19:48:25
RMAN-06091: no channel allocated for maintenance (of an appropriate type)

pls adv to proceed further.

thank you,
kesavan.

Report message to a moderator

Re: Unable to issue DELETE OBSOLETE....in RMAN [message #381731 is a reply to message #381727]

Mon, 19 January 2009 09:02

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You need to have at least one configured or allocated disk device type.

Regards
Michel

Report message to a moderator

Re: Unable to issue DELETE OBSOLETE....in RMAN [message #381798 is a reply to message #381731]

Mon, 19 January 2009 23:08

kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI

Senior Member

Dear Sir,

I am giving the following command for allocating the channle in maintenance , but still getting the same error.

allocate channel for maintenance device type disk;
delete obsolete;

Pl adv.

Thank & Regards,
Kesavan.

Report message to a moderator

Re: Unable to issue DELETE OBSOLETE....in RMAN [message #381821 is a reply to message #381798]

Tue, 20 January 2009 00:48

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Copy and paste the whole session.
And post it formatted.

Regards
Michel

Report message to a moderator

Previous Topic:	Want to purge Obsolete Archive Backups.
Next Topic:	use_db_recovery_file_dest

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 01:32:38 CDT 2024