[DRILL-6012] Query Oracle RMAN without restoring a DB

• Type: New Feature
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: Storage - Other
• Assignee: Unassigned
• Reporter: Daniel Petisme
• Created: 05/Dec/17 21:01
• Updated: 05/Feb/18 07:28

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 ?