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
Time based Recovery to recover a dropped 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.
Time based Recovery to recover a dropped table
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...