Skip to Main Content

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 RESTORE EXPIRED SNAPSHOT FROM OLD BACKUP

TRC DBAAug 30 2010 — edited Dec 17 2012
Hello All,

I have a test instance with 4 days snapshot retention.i would like to get 2 weeks prior AWR report.but from my current instance it is not possible since its already expired.so i have restored db from old backup which is near to the required AWR snapshot.but once i start the instance from old backup it automatically took the current time stamp and purge all previous snapshots.

is there any way to restore AWR from old backup? or can we stop AWR snapshot purging in mount i.e before db open.

Thanks
Mohamed Sameer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 14 2013
Added on Aug 30 2010
15 comments
4,436 views