你在这里

You are here:

首页

博客

PDSERVICE的博客

Database in noarchivelog mode, truncate command issued

Posted by PDSERVICE on 4月 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.