Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-6012

Query Oracle RMAN without restoring a DB

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Storage - Other
    • Labels:
      None

      Description

      Oracle backups are stored under a RMAN (Recovery Manager) format.
      https://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmquick.htm

      With the raise of BigData, we want to query all possible data. Nevertheless, is sometimes hard to get access to actual living data where backups are often easy to get but hard to restore properly.

      The aim of this feature would be to query the RMAN file without actually restoring the database. I don't know if it's even feasible but would be a great help to ease the data access.

      As far as I know, RMAN are binary formats (I guess propriatary) which contains some structure meta-data (indices, for instance) and the actual data.

      IMHO, in that context performance is not a first-class constraint is more an exploration tool I have in mind.

      Does make sense? What's you thoughts on this idea ?

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              danielpetisme Daniel Petisme
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: