I have a situation that we lost our server with Oracle Database 11g
(11.2.0.4).
I could recover all dbf files. They are
I installed a new server e tried to recreate the control files.
When I send the command: alter databse open, the Oracle says me the
System01.dbf are inconsistent e ask for media recovery.
The problem I couldn't restore redolog eighter archivelog.
I think you can help on this situation.
This problem caused by Oracle need to recover the whole database consistent by applying current & active redo logifle.
If you lost your redo logfile then,
1. try to recover the system tablespace by manual fix, this service may cost more money like
http://www.askmac.cn/archives/database-force-open-example.html
OR
2. Using our software PRM-DUL, it can extract data from dbf file directly bypass Oracle instance, the data can be loaded into new Database; The software license costs 1500 USD.
I have a question: The software PRM-DU, Can I recover objects as
Packages, procedures or views?
Thx.
Yes, you can extract the package procedure view ddl as text, and then load into new DB.
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.