Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to recover dropped table without any down time

584465Nov 30 2010 — edited Dec 1 2010

All,

We have a 3TB database and is being backed up by RMAN.

One of the user has unknowingly dropped a Table, How can we recover the table in this situation ...?

User is not accepting any downtime..(DB should not be down, even single datafile and tablespace should not go down)...

Can we do recovery without taking DB,TS or datafile offline in this situation...?

10g DB with solaris 10 and RMAN is the backup tool

Please suggest

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 29 2010

Added on Nov 30 2010

#general-database-discussions

7 comments

6,013 views