Database Backup and Recovery (MOSC)

MOSC Banner

rman script

edited Dec 10, 2009 6:01AM in Database Backup and Recovery (MOSC) 4 commentsAnswered
 If anyone can point what I'm doing wrong to get this error in my recovery script I would appreciate it.  I can't see the error.
RMAN> run{
2> set until time "to_date('2009-12-09 12:50:00' , 'yyyy-mm-dd hh:mm:ss')";
3> alter database mount;
4> restore database;
5> recover database;
6> alter database open resetlogs;
7> }

executing command: SET until clause
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 12/10/2009 12:02:03
ORA-00907: missing right parenthesis


thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center