Recovery for Oracle

The effective way to find out if a Oracle database is recoverable is to try the demo version of Recovery for Oracle on it. Visit the Demo page for a free copy of the demo.

Product specifications with lists of items recovered and not recovered is available at the Product Information page.

Note: Always backup your original corrupted Oracle database before proceeding with any recovery activity!

No additional records or tables or any other elements and features of the original database will be recovered by commercial version of Recovery for Oracle if not present in demo output.

Evaluating the results of demo recovery can help in making the decision.

Details of current licensing scheme are described at the Licensing page.

If your license type is Enterprise or Service, you can run Recovery for Oracle from command line and use these calls in your batch files. Standard version does not support command line. The format for command line call is:

ora.exe <original filename with path> "<path to directory to store the recovered file(s)>"

Please note that the directory for recovered file(s) should be created before starting the recovery.

Command line mode supports patterns '*' (replaces group of symbols) and '?' (replaces one symbol).

To recreate database, process resulting sql scripts starting with schema.sql and following by dataNNNN.sql. The database will be recreated from scratch.

To make the import procedure more convenient for the end-user an appropriate batch file is automatically created and put in the same folder as sql script(s).

1. Path to sqlplus.exe utility without file name (e.g., c:\oracle\ORA90\bin);
2. User name to use for database creation (e.g., SYSTEM);
3. Password;
4. "Connect string" to the server where database rebuilding scripts will be executed.

Run Recovery for Oracle in a logged mode and contact our support team with detailed description of the problem and the log file.

To create log file, please hold the SHIFT key while clicking the Recover button on the toolbar of Recovery for Oracle or selecting the Recover: item in the main menu. You can also press CTRL+SHIFT+R after launching Recovery for Oracle.

To fix this problem you need to set temporary directory to the drive with free space available (2-3 times of the original database size). Fix the Windows environment variable to use it. Do the following:

1. Open System in Control Panel.
2. On the Advanced tab, click Environment Variables, then click the name of the user variable (TEMP or TMP) you want to change.
3. Click Edit to change value.
4. Set path to the location where temporary data should be stored (e.g., e:\).
5. Restart computer for changes to take in effect.
6. Run the software again.

You can also use the special environment variable called OFFICERECOVERY_TMP to set the directory where Recovery for Oracle should store its temporary files. Use the method shown above to add/edit environment variable.