Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN-01005: syntax error:

MaahjoorJan 21 2013 — edited Jan 22 2013
Dear all,

i have a backup script like below
RUN {
ALLOCATE CHANNEL ch00 TYPE DISK FORMAT 'E:\BACKUP\rmanbackup\db\%d_DB_%u_%s_%p';
####crosscheck backup;
backup
filesperset 4
INCREMENTAL LEVEL 0 AS COMPRESSED BACKUPSET database include current controlfile;
sql "alter system archive log current";
release channel ch00;
ALLOCATE CHANNEL CH01 TYPE DISK FORMAT 'E:\BACKUP\rmanbackup\ar\al_%U';
backup
filesperset 4
AS COMPRESSED BACKUPSET archivelog all delete input;
restore database validate;
delete noprompt archivelog until time 'SYSDATE-1';
###delete backup completed before 'sysdate-1';
delete obsolete device type disk;
RELEASE CHANNEL CH01;
}
it give the following error
RMAN-06091: no channel allocated for maintenance (of an appropriate type)
i search the internet and find the following command
 allocate channel for maintenance type disk;
delete obsolete device type disk;
but it give the following error
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"
i think my rman is not recognising the command.
my oracle version is
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod
PL/SQL Release 10.1.0.2.0 - Production
CORE    10.1.0.2.0      Production
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production
NLSRTL Version 10.1.0.2.0 - Production
Kindly help.
This post has been answered by Mihael on Jan 22 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2013
Added on Jan 21 2013
4 comments
1,735 views