Kh,

Was this database in a consistent state? Did it already have data for
Thursday?? This is because I don't think you can do it the way you have
stated if the database was alright and you didn't have to nomount the
database, then this will not work. You will have to use TTS instead if
you are trying to go back in time on a consistent database or as Hans
wrote, you need to open the database with "resetlogs".

D

-----Original Message-----
From: kh
[mailto:oracledba-ezmlmshield-x99254576.[Email address protected]
Sent: 03 September 2006 17: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







This e-mail (and any attachments) contains information, which is confidential and intended solely for the attention and use of the named addressee(s). If you are not the intended recipient you must not copy, distribute or use it for any purpose or disclose the contents to any person. If you have received this e-mail in error, please notify us immediately at [Email address protected] The information contained in this e-mail (and any attachments) is supplied in good faith, but the sender shall not be under any liability in damages or otherwise for any reliance that may be placed upon it by the recipient. Any comments or opinions expressed are those of the originator not of NTT Europe Ltd unless otherwise expressly stated.

Oracle LazyDBA home page