| DELETE backup job failing [message #218756] |
Fri, 09 February 2007 17:08  |
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 |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
