Database in NOARCHIVELOG mode, truncate command has been issued how to restore the table?
FACTS:-
1. DB In NOARCHIVELOG Mode
2. Cannot enable flash back mode because of 1. above
3. No exports available
4. No backup's Available.
Any thoughts?
Oracle Support/ Professional Services has a Data Unloader (DUL) and PRM-DUL (DBRECOVER for Oracle), both of which may be able to extract information from datafiles that are corrupted, where the control files are lost, etc.
These are not, however, cheap utilities. Unless the data itself isReallyValuable, it is generally not a viable option.
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.