Database Software

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 restore table which is dropped || physical data guard setup is done

Ashish Kr MahantaMar 27 2017 — edited Apr 16 2017

Dear All,

Oracle version - 11.2.0.1

os version - OEL 6

Physical data guard set-up is done.

Now I have an requirement to recover one table which is already dropped. Flashback is not on. Physical dataguard setup is done.

Though, we have backups (rman & expdp for the table) as well as archivelogs but i have confusion about the data guard.

If I recover it from expdp till the last back how it will apply at standby side?

Please suggest, is there any way to recove the dropped table.

Thanks,

Ashish Kumar Mahanta

Locked Post

New comments cannot be posted to this locked post.

Locked on May 14 2017

Added on Mar 27 2017

#data-guard, #performance-availability

8 comments

800 views