Home » RDBMS Server » Backup & Recovery » Unable to issue DELETE OBSOLETE....in RMAN (Oracle 10.2.0.1.0 o/s: hp-ux:11.23)
Unable to issue DELETE OBSOLETE....in RMAN [message #381727] Mon, 19 January 2009 08:19 Go to next message
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.

Re: Unable to issue DELETE OBSOLETE....in RMAN [message #381731 is a reply to message #381727] Mon, 19 January 2009 09:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You need to have at least one configured or allocated disk device type.

Regards
Michel
Re: Unable to issue DELETE OBSOLETE....in RMAN [message #381798 is a reply to message #381731] Mon, 19 January 2009 23:08 Go to previous messageGo to next message
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.
Re: Unable to issue DELETE OBSOLETE....in RMAN [message #381821 is a reply to message #381798] Tue, 20 January 2009 00:48 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Copy and paste the whole session.
And post it formatted.

Regards
Michel
Previous Topic: Want to purge Obsolete Archive Backups.
Next Topic: use_db_recovery_file_dest
Goto Forum:
  


Current Time: Thu Nov 28 23:07:37 CST 2024