Question on Recovery

Hi
I tried to do this on a test machine(win2k) to see how rocovery process works for a Point in time, it seems that it is not working - i am going wrong somewhere,

this is how i did
SVRMGR> alter tablespace users begin backup;

copy datafile users01.dbf as users01.bak

SVRMGR> alter tablespace users end backup;

create a table T1 insert some records;
commit it
create a table T2 insert soem records;
commit it;

Time: 16:39:00
at Time 16:40:00 I drop table T2.
assuming now i want the table back
I do the below.


SVRMGR> shutdown immediate

rename datafile users01.bak to users01.dbf

SVRMGR> startup mount

SVRMGR> alter database datafile 'D:\oracle\oradata\orcl\USERS01.DBF' online;
Statement processed.

SVRMGR> recover datafile 'D:\oracle\oradata\orcl\USERS01.DBF';
Media recovery complete.
SVRMGR> recover database until time '2001-05-01:16:39:00';
Media recovery complete.
SVRMGR> alter database open resetlogs;


after this i log on and find the table T1 is there with data but couldnt find table T2.

What is the problem in this procedure.
Thanks for any help
-dharma

hi,
did you get an error like ORA-00942...table does not exist...like that.
then locate ....it by quering
select table_name from dba_tables where table_name like 'T2';
If no rows are selected,then the table is not restored correctly.You will need to recover to an earlier point in time,....otherwise the steps are correct...
Try these queries and redo it.You will get it.
did you put this in archivelog mode?.
Good luck.
Thanigaivasan.

Hi Thanigai,
yes its in archive logmode, and i did not get any errors.its as perfect as that except for the missing table.
Thnx a lot.
-dharma

Hi, 5th May 2001 20:59 hrs chennai

Did you restore properly the old datafile from last backup and tried it?

This process you have to try by moving earlier point in time.

Even in oracle docs its said like that try again.

Cheers

padmam

Quote:

---

Originally posted by dharma

SVRMGR> recover datafile 'D:\oracle\oradata\orcl\USERS01.DBF';
Media recovery complete.

---

This is your problem. You have recovered until the current time. At the current time, T2 has already been dropped.