| 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
|
|
|
|
| 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
|
|
|
|
| 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;
|
|
|
|
| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
