0

I would like to know the on disk format of an RMAN backup file. Is this documented anywhere?

user605957
  • 2,489
  • 6
  • 25
  • 33

1 Answers1

1

The RMAN backup file format is not documented anywhere, may be different in different versions, and it is subject to change at any point.

Why do you want to know how to read an RMAN backup? An RMAN backup is really only intended to be useful to RMAN so that it can do a restore.

Writing software to parse the file and extract the information from it is probably not a practical way forward unless you're willing to invest at least a few thousand man-hours. The format is likely to be relatively similar to the format of a data file with some additional RMAN-specific stuff tacked on. There is one group outside of Oracle that has done a pile of work on the format of an Oracle data file so that they could write DUDE, a last-ditch Oracle recovery tool. These folks charge an arm and a leg for their tool (though less than Oracle charges for their version of the same tool) and there is always a demand from people that have unrecoverable databases that want to extract whatever data they can salvage. If you could reverse engineer the data file format in hundreds of man-hours rather than thousands, there would be dozens of competitors in this space.

Justin Cave
  • 227,342
  • 24
  • 367
  • 384
  • Because I need to write some s/w to parse the file and extract information from it for analytics. Has anyone reverse engineered this publicaly? – user605957 Mar 29 '12 at 19:40
  • @user605957 - Why would the requirement be to reverse engineer a database backup file? It would be oodles easier to just extract whatever you need from the data dictionary of a running database... – Justin Cave Mar 29 '12 at 19:44
  • Because this is at a point where we dont have a database ... it is an archiving solution that needs to do some compliance sort of work... and we dont have oracle licences to start it and mount the rman DB etc – user605957 Mar 29 '12 at 19:49
  • @user605957 - I updated my answer-- this is probably not feasible without at least a few thousand man-hours of effort. – Justin Cave Mar 29 '12 at 19:55