Time based Recovery to recover a dropped table

To learn time based recovery to recover a dropped table practically,i did the following.

SQL> create table emp(id number)

Table created.

SQL> insert into emp values(1);

1 row created.

SQL> commit;

Commit complete.

I dropped the table at March 15,2006-2:25P.M.

SQL> drop table emp;

Table dropped.

To do time based recovery,I shutdown the database..

SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.

Then,i mount the database..

SQL> startup mount

Then,i issued the following command,to do time based recovery & to recover the table..

SQL> RECOVER DATABASE UNTIL TIME '2006-04-15:02:20:00';
Media recovery complete.

Since i recovered the database to the time 2:20P.M,the dropped table EMP should be there now,but when i tried to look at the table,it shows the table doen't exist,

SQL> SELECT * FROM EMP;
SELECT * FROM EMP
*
ERROR at line 1:
ORA-00942: table or view does not exist

My questions are,

1)Why the table "EMP" is not recovered?

2)Did i do anything wrong while doing the time based recovery?

3) If the procedure i followed to do time based recovery is wrong,can anyone explain me,how to do this & recover a dropped table?

Thanks,
Malru

I wonder whether the 02:20:00 in your recovery should be 14:20:00, as you dropped your table at 02:25:00PM according to 'I dropped the table at March 15,2006-2:25P.M.' earlier.

you recovered until 15th April 2006, you went right past the point at which you dropped the table

Hi,

As you told i did the following,I created a table "EMP" at March 15,2006,3:40P.M,


Then i dropped the table at 3:45,

I issued the following command to recover the table,

recover database until time '2006-03-15:15:43:00';

But the table "EMP" is not recovered,still it shows table "EMP" doesn't exist.

Please anyone help me in how to recover the dropped table.

Thanks,
Malru.

in your original post you had this


SQL> RECOVER DATABASE UNTIL TIME '2006-04-15:02:20:00';
Media recovery complete.

That is the 15th March 2006, if that isnt what you did then stop writing crap in your posts and post the real examples from a copy and paste from the screen

Who knows what else you are making up

Mr.davey23uk,

I'm new to DBA,i'm in learning process,i just copied & pasted the work i did in SQL* Plus & you know my mistake i gave the query as April 15th,2006 only & it gave the result exactly what i posted.

ok.. anyway after seeing your reply,i found my mistake & corrected it,issued the query with the date March 15,2006.This time also,i'm getting the same problem and i made it clear to you.

As a Senior member,you found the mistake i made & i corrected it next time,now it's your responsibility to give the proper answer,but it's not the way to behave,if you're really interested and able to help me,do so,otherwise don't send rubbish replies..

Good bye...