Skip to Main Content

Oracle Database Discussions

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-01009: syntax error: found "cancel"

Marko SuticFeb 4 2009 — edited Feb 5 2009
Hi!

I am playing with rman on my test machine and I encountered error that I can't resolve.

I've tried to restore/recover datafiles executing this commands:


$ sqlplus "/as sysdba"

SQL>startup mount

RMAN> restore database
(everything went well)

RMAN> recover database until cancel;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "cancel": expecting one of: "logseq, scn, sequence, time"
RMAN-01007: at line 1 column 24 file: standard input

I've executed this command on several occasions and never had a problem, but now syntax error.

Just don't know why syntax error?!

OS: Centos 5
DB: 11.1.0.7.0

Thanks for any help,
Marko
This post has been answered by 26741 on Feb 4 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 5 2009
Added on Feb 4 2009
6 comments
10,905 views