Skip to Main Content
  • Questions

  • How to restore a packages from rman backups

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Michal.

Asked: February 21, 2018 - 10:17 pm UTC

Last updated: February 23, 2018 - 12:40 am UTC

Version: 12c

Viewed 1000+ times

You Asked

Hello,

Is it possible to restore packages from rman backups? I know the export method that can do it, but I want to know if extended rman can do such a thing?

and Connor said...

Not trivially.

See this link

https://asktom.oracle.com/pls/asktom/asktom.search?tag=restore-single-table-from-rman-full-backup

for the *11g* details on recovering a single table. In your case, you would recover just system/sysaux etc and no user tablespaces, and then query DBA_SOURCE.

Unfortunately you cannot use the new 12c RECOVER TABLE on SYS objects.

If its just a loss of a package that occurred not too long ago, you can query DBA_SOURCE using AS OF [time] to get the source before it was altered.

Rating

  (1 rating)

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

Comments

Another option

A reader, February 22, 2018 - 2:40 pm UTC

Couldn't you use rman to restore the schema containing the proc to a new temporary database and grab the ddl from there?
Connor McDonald
February 23, 2018 - 12:40 am UTC

RMAN does not do schema level restore.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database