I am running two node RAC Oracle Database 11g, we had issue with shared storage - controller failure. After replacing the controller I see the ASM groups but the database is not starting due to errors. What is the best way to salvage the data? I need some company that provides service to export several objects from one schema in the database. I believe that most of the database is unaffected by the controller failure, and I need to salvage the data from there.
Anyone has good experience with such company / service?
What are the exact errors that you get?
Do you have any backups for this database?Normally the best way "to salvage data" is simply to restore from backup. If you don't have any backup and have an Oracle Support contract you can ask Oracle Support for help: they have a tool named DUL for this kind of problems. See alsohttp://www.oracle-internals.com/?p=17%20Blvd.PRM-DUL can be another option:DBRECOVER for Oracle
DBRECOVER Recovery Options
For Oracle incidents, start with the DBRECOVER for Oracle trial to verify table visibility, row previews, and export readiness on copied datafiles. For MySQL and InnoDB incidents, DBRECOVER for MySQL is free software and can inspect.ibd files, ibdata1, and database directories locally.
When the case is urgent, preserve the original files first, work from copies, and contact paid emergency support with the database version, platform, error messages, file list, and recovery objective.