Home » RDBMS Server » Backup & Recovery » how to recover a table after dropping(using time based recovery)
icon5.gif  how to recover a table after dropping(using time based recovery) [message #485646] Thu, 09 December 2010 04:56 Go to next message
deekshag
Messages: 2
Registered: December 2010
Location: INDIA
Junior Member
Hello,

im new to oracle administration.
how to get back the table tht is dropped suddenly,,using time based recovery.

please help me!!

Thank you
Smile
Re: how to recover a table after dropping(using time based recovery) [message #485648 is a reply to message #485646] Thu, 09 December 2010 05:00 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Posting the Oracle Version/OS you are using will be extremely useful always.
With recent versions, the table may still be available in recyclebin.
You can just flash back.
To recover the whole database, you first need a backup along with archived logs.
Re: how to recover a table after dropping(using time based recovery) [message #485649 is a reply to message #485646] Thu, 09 December 2010 05:02 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.orafaq.com/node/968
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/flashptr003.htm
Re: how to recover a table after dropping(using time based recovery) [message #485654 is a reply to message #485648] Thu, 09 December 2010 05:14 Go to previous messageGo to next message
deekshag
Messages: 2
Registered: December 2010
Location: INDIA
Junior Member
hi,

im using 10g.

drop table emp purge;

for dropping.we can't go for flashback;

can i get back the emp table again?any other way to get back the table??

Re: how to recover a table after dropping(using time based recovery) [message #485657 is a reply to message #485654] Thu, 09 December 2010 05:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
So you dropped it real good.
Restore/Recover your database elsewhere and get the table
else
You need to restore the DB to the point prior to backup.

[Updated on: Thu, 09 December 2010 05:26]

Report message to a moderator

Re: how to recover a table after dropping(using time based recovery) [message #486090 is a reply to message #485657] Mon, 13 December 2010 09:24 Go to previous messageGo to next message
najjuizzhere
Messages: 7
Registered: December 2010
Location: BAHRAIN
Junior Member
Have you ever tried out logminer utility , this is one part {If the database is real big }
2) Flash back database {Second option}
3) Restore/Recover your database elsewhere and get the table

Re: how to recover a table after dropping(using time based recovery) [message #486103 is a reply to message #486090] Mon, 13 December 2010 10:36 Go to previous message
Michel Cadot
Messages: 67743
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Good, you are able to repeat what has been said!

Regards
Michel
Previous Topic: Need to check session information
Next Topic: Need Help
Goto Forum:
  


Current Time: Sat Feb 27 01:00:52 CST 2021