Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 stackoverflow.com Feb 23 at 16:22

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

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

1 Answer 1

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 at 2:45

Your Answer

 
discard

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