OraFAQ Forum: Backup & Recovery » How to do point-in-time incomplete recovery with rman?

Home » RDBMS Server » Backup & Recovery » How to do point-in-time incomplete recovery with rman?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to do point-in-time incomplete recovery with rman? [message #62403]

Tue, 20 July 2004 12:24

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

Report message to a moderator

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

Mahesh Rajendran
Messages: 10708
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')";

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 12 07:45:13 CDT 2026