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> }




Oracle LazyDBA home page