Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question.

Asked: July 14, 2016 - 4:48 pm UTC

Last updated: July 20, 2016 - 12:55 pm UTC

Version: 11g

Viewed 1000+ times

You Asked

Hi ask tom team,

we need to restore a procedure to a one month previous version.. unfortunately.
Database is in Archine log mode and we take daily backups.
Is it possible ?


and Connor said...

Yes.

You can restore a one-month-old backup to a new database - you dont need to restore *everything*, all you'll need is SYSTEM, SYSAUX, UNDO, and then extract the code from DBA_SOURCE.

Follow the guidelines in tablespace point in time recovery

http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmtspit.htm

Hope this helps.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Flashback Query

A reader, July 20, 2016 - 10:11 am UTC

can we use flashback query on DBA_SOURCE, instead of restoring database ?
Connor McDonald
July 20, 2016 - 12:55 pm UTC

You can run flashback queries on DBA_SOURCE (if you have sufficient privileges).

But...

One month is a long time! I doubt their undo_retention is set high enough to query back this far.

More to Explore

Backup/Recovery

Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.