| Time based recovery? [message #164729] |
Sat, 25 March 2006 01:46  |
orajamzs
Messages: 110
Registered: February 2006
Location: hyderabad
|
Senior Member |
|
|
Plz explain me, somewhere in the procedure im mistaking ...
Tell me where i am wrong in time based recovery.
SQL> create table test(a number);
SQL> insert into test values(1234);
SQL> select to_char(sysdate,'dd-mon-yy hh24:mi:ss') from dual;
----- 25-mar-06 12:59:35
SQL> drop table test;
SQL> shutdown normal
SQL> startup mount
SQL> recover database until time '2006-03-25:12:59:35';
--- It made media recovery
SQL> alter database open resetlogs;
----- its also ok
SQL> startup force
SQL> select * from test;
---- It shows no table.
--- Where i am wrong?
|
|
|
|
| Re: Time based recovery? [message #164998 is a reply to message #164729] |
Mon, 27 March 2006 23:56  |
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
|
Senior Member |
|
|
You should restore the datafiles and controlfiles from a full backup and then using archived log to do that.
Alex zeng |Skype me: hans9zeng
|
|
|
|
| Re: Time based recovery? [message #166782 is a reply to message #164998] |
Sat, 08 April 2006 07:32 |
marks20101
Messages: 74
Registered: May 2005
|
Member |
|
|
Yes, always to a full backup when ever you try any type of recovery.
Try using log miner to pin point the exact time that the table was dropped, you may need to recover to an earlier point-in-time.
try,
recover database until time '2006-03-25:12:59:00';
[Updated on: Sat, 08 April 2006 07:36] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
