OfficeRecovery.com, the web source of data recovery software for email, databases and office productivity

data recovery software for corrupted Oracle® databases

  Home  :  OracleRecovery  :  FAQ
+1 (800) 920-7713  |  Products  |  Order  |  Support   

[ NEWS | Free Newsletter | RSS ] - New: Recovery for Excel 4.0 - New: Undelete for Outlook Beta - Recovery for Backup 1.7 - PostgreSQLRecovery Beta - Recovery for Outlook 2.0 - Recovery for PowerPoint 2.5 - Recovery for OneNote 2.0 - MediaHeal Utilities 1.0

PRODUCT MENU

OracleRecovery

Product Information

Errors and Solutions

Order

Download Demo

FAQ

Customer Support


RELATED PRODUCTS

DBRecovery Suites

OFFICERECOVERY SURVEY

What is your experience with data recovery vs backup restore? Take our survey and instantly get an useful utility for free.

SITE NAVIGATION

Home

Products


SITE SEARCH

PARTNER LINKS

Password recovery utilities for office, email and database applications:
LostPassword.com

FREE DOWNLOAD

FreeUndelete is a freeware file undelete utility for Windows. Need to recover accidentally deleted files? Try FreeUndelete.

FAQ

OracleRecovery Frequently Asked Questions

If you have a problem that is not covered by this FAQ, do not hesitate to contact our technical support team.

Can OracleRecovery recover my Oracle database(s)?

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

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

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

I have tried the demo. How do I decide whether to purchase the full version of OracleRecovery?

You can decide this by evaluating the results of demo recovery. The demo version recovers a limited number of rows in each table of the corrupted Oracle database. The remaining rows will contain "demo" in text fields and null values in other types of fields. Full version of OracleRecovery will recover the demo-limited rows as well.

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

For more information see the OracleRecovery online help.

What is the difference between Standard License and Enterprise License?

The license type refers to the number of copies to be used simultaneously. Standard license is intended for small business and individual use. One license allows one installation of OracleRecovery and servicing an internal domain up to 50 computers. Primary user of the computer where the OracleRecovery is installed may have another copy on their portable computer for exclusive usage.

Enterprise license gives the right to install two copies of OracleRecovery and servicing an internal domain of 250 computers total.

Both types of license do not have any limitations on the number, size and authorship of the Oracle databases to be recovered.

Please, note that to use OracleRecovery in data recovery service you have to obtain the annually renewed Franchise license!

See License Information page for full disclosure and assistance.

Why do recovered files contain less data than the original Oracle database?

This is normal. The damaged parts of your Oracle database will convert to zero size on output. The other common reason of file size decrease is when some of features of the original Oracle database are not supported and therefore appropriate data is absent from the resulting files.

Demo-recovered files mostly consist of demo placeholders than actual data from the original Oracle database.

I'm getting an Internal Program Error while using OracleRecovery. What can be done?

Please, run OracleRecovery 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 or selecting the Recover: item in the main menu. You can also press CTRL+SHIFT+R after launching the program.

I'm getting an error message that there's not enough free space. Is there a workaround for this?

Yes, if there is other drive with free space available (2-3 times of the original Oracle 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 OracleRecovery should store its temporary files. Use the method shown above to add/edit environment variable.

Is there any way to run OracleRecovery from command line (through Windows Start -> Run menu)?

Yes, you can easily run OracleRecovery from command line and use it in your batch sceneries. The format for this call is:

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

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).

After running OracleRecovery on the corrupted Oracle database, a folder with sql script(s) and batch file has been created. How could these files be transfigured into a new Oracle database?

To recreate Oracle database, process resulting sql scripts starting with schema.sql and following by dataNNNN.sql. The Oracle 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).

Processing of sql scripts created by OracleRecovery does not rebuild the database and/or produce any error messages. What is the problem with?

In addition to script(s) the assisting batch file commit.bat is created to automate database rebuilding procedure. The following parameters should be passed as command-line arguments:

  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.

Copyright © 1999-2008 OfficeRecovery / Recoveronix Ltd. All rights reserved.