OraFAQ Forum: Backup & Recovery » RMAN EXPIRED BACKUP

Home » RDBMS Server » Backup & Recovery » RMAN EXPIRED BACKUP

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

RMAN EXPIRED BACKUP [message #140155]

Sat, 01 October 2005 08:12

msssd786
Messages: 3
Registered: October 2005
Location: Jeddah

Junior Member

Dear Gurus,

i try to removed all expired, obosolete backups...soon i run this script it gives me error can any one trace and help me...

connect target sys/sys@ORCL;
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
report obSOlete;
CROSSCHECK BACKUP;
CROSSCHECK COPY;
DELETE EXPIRED BACKUP;
DELETE EXPIRED COPY;
delete obsolete;
release channel;

RMAN-00571:
RMAN-00569:
RMAN-00571:
RMAN-03002: failure of delete command at 09/30/2005 17:02:42
RMAN-06091: no channel allocated for maintenance (of an appropriate type)

i also wanted to tell you there is no SBT backup and it is not configured also...but still above errors came

Report message to a moderator

Re: RMAN EXPIRED BACKUP [message #140239 is a reply to message #140155]

Mon, 03 October 2005 01:25

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

  

RMAN-00571 ===========================================================

Action: The errors are printed in last-in first-out order. So to interpret them correctly, read from the bottom to the top

RMAN-03002 failure of string command at string

Cause: This message should be accompanied by one or more other error messages indicating the cause of the error.

Action: Check the accompanying errors.


RMAN-06091 no channel allocated for maintenance (of an appropriate type)

Cause: A command was entered that requires a maintenance channel, and no maintenance channel is allocated, or none of the appropriate type.

Action: Use ALLOCATE CHANNEL FOR MAINTENANCE before deleting backup pieces, or using the CROSSCHECK or DELETE EXPIRED commands. Proxy copies require a non-DISK channel.

From Documentation

If you specify channels manually, then the ALLOCATE CHANNEL command
(executed only within a RUN command) and ALLOCATE CHANNEL FOR
MAINTENANCE command (executed only at the RMAN prompt) specify the type of
I/O device that the server session will use to perform the backup, restore, or
maintenance operation.

where did u run these commands , i mean to say in the RUN block or at the RMAN prompt.

regards,
tarun

Report message to a moderator

Re: RMAN EXPIRED BACKUP [message #140462 is a reply to message #140239]

Tue, 04 October 2005 06:39

msssd786
Messages: 3
Registered: October 2005
Location: Jeddah

Junior Member

dear gurus,

note: FIRST THERE IS MAIN.BAT FILE UNDER WINDOWS
================
CD E:\oracle\ora92\bin

rman cmdfile "E:\ora_Scripts\RMAN.bat" log "E:\bkup_orcl\log_rman.log"
==================
note: then i have another batch file that has this script
============
connect target sys/sys@ORCL;
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
run
{
report obSOlete;
CROSSCHECK BACKUP;
CROSSCHECK COPY;
DELETE EXPIRED BACKUP;
DELETE EXPIRED COPY;
delete obsolete;
}
release channel;

Report message to a moderator

Re: RMAN EXPIRED BACKUP [message #140469 is a reply to message #140462]

Tue, 04 October 2005 07:14

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

did you tried executing these commands at RMAN prompt itself, i.e. without invoking them from the batch file?

As I checked the same here & its working perfectly at the RMAN prompt, without any error. I checked on RMAN Release 9.2.0.1.0.

--Girish

Report message to a moderator

Previous Topic:	Import error
Next Topic:	Error While Export

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 04:04:01 CST 2025