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!

tablespace incomplete recovery

Neo-bApr 2 2013 — edited Apr 2 2013

Hello All,

I am using Oracle 11g R2.

there was users mistake on my database on one tablespace the data is not OK. and they asked me to restore this database to 9:00 Am
I am planing to restore only this table space and recover it until 9:00 am?

What is the best solution, is the below correct ?

alter tablespace TS_NAME offline immediate;
restore tablespace TS_NAME;
recover tablespace TS_NAME until time "to_date('2013-04-02:09:00:00', 'YYYY-MM-DD:HH24:MI:SS')";
alter tablespace TS_NAME online;

Regards,

This post has been answered by Levi Pereira on Apr 2 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 30 2013

Added on Apr 2 2013

#performance-availability, #recovery-manager-rman

17 comments

1,577 views