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!

restore full database until scn or timestamp

John-MKAug 1 2012 — edited Aug 1 2012

Hi,

I have heard that restoring full database until time is 3 lines work with RMAN. I want to restore RAC db (10.2.0.5, RHL) until Monday 6pm when full backup (level 0) gets over.

Can you please write me the steps how can I perform this like RMAN set until time, restore and recover? Also, do I need downtime/shutdown/restart of the database?

Actually, I want to restore only one schema (separate tablespace is there only for that user), but If it is lengthy or difficult procedure that's why I am thinking of full database restore - not ideal of course.

Thanks a lot in advance.

Best Regards

Edited by: 910385 on Aug 1, 2012 2:37 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 29 2012

Added on Aug 1 2012

#db, #performance-availability, #recovery-manager-rman, #rman, #time

9 comments

10,611 views