Home » RDBMS Server » Backup & Recovery » DELETE backup job failing
DELETE backup job failing [message #218756] Fri, 09 February 2007 17:08 Go to next message
Ksaravan
Messages: 17
Registered: January 2007
Location: Portland
Junior Member
connect target /

run
{
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE type disk;
delete NOPROMPT backup of database completed before 'sysdate -1';
release channel;
}

what is wrong in the above script. its not running via crontab.

shall i mix up this maintenance channel allocation with taking backup also.

Regards
KS


The error is
RMAN> run
2> {
3> allocate channel for maintenance device type disk;

Or
allocate channel for maintenance device type disk "OEM_DEK";

Both the above syntax giving error. Oracle document telling the same.



RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "for": expecting one of: "channel_id, double-quoted-string, equal, identifier, single-quoted-string"
RMAN-01007: at line 3 column 18 file: standard input


[Updated on: Fri, 09 February 2007 17:19]

Report message to a moderator

Re: DELETE backup job failing [message #218761 is a reply to message #218756] Fri, 09 February 2007 18:35 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Try to allocate the maintenance channel outside of the RUN block.
Re: DELETE backup job failing [message #218762 is a reply to message #218761] Fri, 09 February 2007 18:39 Go to previous message
Ksaravan
Messages: 17
Registered: January 2007
Location: Portland
Junior Member
thank you..
Previous Topic: How to recover with archive logs when I create a new tablespace after full backcup.
Next Topic: external table
Goto Forum:
  


Current Time: Sat Dec 10 18:16:24 CST 2016

Total time taken to generate the page: 0.07646 seconds