| Time based Recovery to recover a dropped table [message #163153] |
Wed, 15 March 2006 03:05  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
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
|
|
|
|
| Re: Time based Recovery to recover a dropped table [message #163379 is a reply to message #163153] |
Thu, 16 March 2006 08:58  |
croK
Messages: 170
Registered: April 2002
|
Senior Member |
|
|
It does not work like that.
Correct me if I'm wrong:
you simply drop the table then issued RECOVER DATABASE statement?.
I believe you will need to restore ALL datafiles from previous backup, then startup nomount, then RECOVER DATABASE UNTIL TIME to previous moment when table was dropped.
I believe it works that way.
Best luck.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
