Home » RDBMS Server » Backup & Recovery » How to do point-in-time incomplete recovery with rman?
How to do point-in-time incomplete recovery with rman? [message #62403] Tue, 20 July 2004 12:24 Go to next message
jack
Messages: 123
Registered: September 2000
Senior Member
I want to do a point-in-time incomplete recovery on my database with rman. The database is  oracle9i runing on windows2000.

I have been trying to execute following command

run{

allocate channel ch1 type disk;

set until time 'JUN 20 2004 15:23:00';

restore database;

recover database;

sql 'alter database open resetlogs';}

while I got an error:

executing command: SET until clause
released channel: ch9
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 07/20/2004 15:45:34
ORA-01830: date format picture ends before converting entire input string

Can somebody help me figure it out? thanks in advance!

jack
Re: How to do point-in-time incomplete recovery with rman? [message #62417 is a reply to message #62403] Wed, 21 July 2004 03:12 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
u need to use the to_date...something like

set until time  "to_date('JUL 15 2004 07:30:00','MON DD YYYY HH24:MI:SS')";

Previous Topic: RMAN - delete archivelogs
Next Topic: RMAN Recovery
Goto Forum:
  


Current Time: Thu Mar 28 03:50:27 CDT 2024