Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Our customer gave us a .bak archive with name file_decrypted_379299.bak which we know was created with Oracle 9i in "hot" style.

We tried to recover the bak file with Oracle 9i RMAN but we don't know how to make reference to this file.

We have not found any specific reference, documentations explains we need specific parameters from how this bak file was created... but customers says "normal" parameters.

We just installed oracle 9i with default database configuration, we don't want database instead we only want SQL tables and data.

Do you know how to ask for these parameters? How to specify in RMAN the location of this file?

Any tool to recover data without installind the database?

Thanks for your help

share|improve this question

migrated from Feb 23 '14 at 16:22

This question came from our site for professional and enthusiast programmers.

This does not appear to be a programming related question... – Okuma.Scott Feb 19 '14 at 20:14
Is a logfile available from the creation of the backup? Or, are the backup scripts available? – ik_zelf Feb 23 '14 at 17:50

Are you sure this is an RMAN backup set? Maybe it is just a dump file made while the database is online. For 9i you only had exp and not the newer expdp available to make dumps so you could try to import it with imp and see what the output is:

imp system/password@abc FULL=Y FILE=file_decrypted_379299.bak
share|improve this answer
Not sure it is a RMAN backup. I tried your suggestion and something about "Characters set is undefined". I'm looking further with user. Thanks. – user2317722 Feb 20 '14 at 2:45

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.