OraFAQ Forum: Backup & Recovery » how to recover a table after dropping(using time based recovery)

Home » RDBMS Server » Backup & Recovery » how to recover a table after dropping(using time based recovery)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to recover a table after dropping(using time based recovery) [message #485646]

Thu, 09 December 2010 04:56

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

Report message to a moderator

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

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

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

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

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

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??

Report message to a moderator

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

Mahesh Rajendran
Messages: 10708
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

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

Report message to a moderator

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

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Good, you are able to repeat what has been said!

Regards
Michel

Report message to a moderator

Previous Topic:	Need to check session information
Next Topic:	Need Help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 22:17:48 CST 2025