Database in noarchivelog mode, truncate command issued

Posted by PDSERVICE on Apr 18, 2017 In

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 ( http://www.parnassusdata.com/) , both of which may be able to extract information from data files that are corrupted, where the control files are lost, etc.

These are not, however, cheap utilities. Unless the data itself is really valuable, it is generally not a viable option.

You are here

Database in noarchivelog mode, truncate command issued

Database in noarchivelog mode, truncate command issued