Restore a set of tables ... by mistake dropped

Need to restore a set of tables, which application dropped by mistake.

Please assist/guide, how to go about it, haven't done this earlier.

Thanks in advance.
Mushfique KhanDirector OperationsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
Depending on your database version, configuration and how long ago it happened:
Flashback query might get the data.

Flashback table and/or database:
http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9012.htm#SQLRF01802

If all that fails:
Recover the database to a time before the drop from your backups.  This is called Point-In-Time-Recovery (PITR).

http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmflash.htm#BRADV80055

Probably better:  Recover the database to a different server then export the tables and import them back into the database where they were dropped.
0
Mushfique KhanDirector OperationsAuthor Commented:
sorry for incomplete info, db+ 11.2.0.4 and OS=OEL

can you please assist, how to know my flashback status, can I restore from there or not, how to check/verify this?
0
Mushfique KhanDirector OperationsAuthor Commented:
sorry ...

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE    11.2.0.3.0      Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

slightwv (䄆 Netminder) Commented:
Silly question that I should have asked:  Did you drop and purge or just drop?

The tables may still be in the recyclebin.

select original_name from RECYCLEBIN;

>>, how to know my flashback status, can I restore from there or not, how to check/verify this?

Flashback query?
Just try t:
create table mytable_tmp as select * from mytable  as of timestamp(to_timestamp('03/09/2015 15:30:00','MM/DD/YYYY HH24:MI:SS'));

replace mytable with the original table name and pick a date and time right before the drop.

Look in the docs link I provided above for flashback table examples:
Retrieving a Dropped Table: Example

I'm not sure how to tell if flashback is 'enabled' or not.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mushfique KhanDirector OperationsAuthor Commented:
I've requested that this question be deleted for the following reason:

Not getting the answer ... please delete, where as resolved myself.

One request ... can it be possible to ask experts to respond, ONLY if they have experienced in doing these tasks, because I know all the links already and not paying $20/month ... for this.

Please advise experts, NO Need to jump for assistance ... if they are NOT the subject matter expert.

Thanks in advance and much appreciated.
0
slightwv (䄆 Netminder) Commented:
Please post the resolution that solved our problem and accept that as the answer.

This way, others that have the same problem can benefit.

For what it is worth:
I have experience in ALL the methods I suggested.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Storage Software

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.