There are 7 .dbf file with wrong extension(.dfb) in a tablespace but DBA has deleted these files physically and tablespace is offline.
Now problem is that tablespace is not alter online and don't have have backup of this tablespace.
How to sole this issue?
Please guide
Answer
Yes, we can try scan Oracle block directly from filesystem by prm-scan tools, Please shutdown your database first and offline your filesystem or take it as read only mode.
If you cannot recover data by yourself, ask DBRECOVER, the professional Oracle database recovery team for help.
DBRECOVER Software Database Recovery Team
Service Hotline: +86 13764045638 E-mail: [email protected]
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.