Are you sure this was the script you ran ?
I think you are performing an incomplete recovery and that type of
recovery must always be ended by the command "alter database open
resetlogs;"

Hans

-----Original Message-----
From: kh
[mailto:oracledba-ezmlmshield-x99254576.[Email address protected]
Sent: zondag 3 september 2006 18:36
To: LazyDBA Discussion
Subject: rman restore until specific time


Dear gurus,

Can anyone please guide me on this? I perform RMAN full backup on my
database in daily mode. On Friday noon, I would like to restore my
database back to Wednesday database so I use the method :

restore until time= the date and time on Wednesday backup. When I
checked the data, it is the data on Thursday but not Wednesday. Can
someone guide me on this?



My script is :
RMAN> run{

2> allocate channel c1 device type disk;

3> set until time='2006-09-03:01:48:16'; <-- the date is just example

4> restore database;

5> recover database

6> sql "alter database open";

7> }





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.

Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------


Oracle LazyDBA home page