1. Administration Guide
  2. Restoring a Backup File for Oracle on UNIX or Windows

Restoring a Backup File for Oracle on UNIX or Windows

To restore a backup file for Oracle on UNIX or Windows:

  1. From the Oracle Enterprise Manager Tool, open Data Manager and from the Data menu, select Import.

  2. Type the name of the import utility .dmp file.

  3. Click Next.

  4. On the Object Selection form, select the objects you want to restore and click Next.

    The Importable Objects tree contains the objects that are importable in the file you specified. To move the object to the Selected Objects tree, select an object in the tree and click the down arrow.

    Note: When the .dmp file is on a remote machine, Data Manager uses the Console job and event system to retrieve the file before displaying the data through the Import Wizard. The Remote Import page of the Import Wizard has a status line at the top of the page that displays the progress of data retrieval. The Oracle Enterprise Manager Console must be running.

    Three conditions can be displayed: Job Submitted, Job Started, and Job Completed.

    Note: Data retrieval must complete successfully before beginning the import operation.

    The Selected Objects/Available Objects tree contains the objects to be imported. To remove an object from the list, select the object and use the up arrow or drag and drop.

  5. Click Next.

  6. On the Associated Objects form, accept the defaults and click Next.

  7. On the Tuning form, you can generate a log file, if needed.

  8. Click Next.

    Note: Select the Generate Log File options and enter a log file name or use Browse to select a log file.

  9. On the Advanced Options form, select the Increment Type. If you followed the instructions to create a backup, select None for Increment Type and click Next.

  10. On the Summary form, verify that all selected objects and options are correct.

    Note: You must drop the existing objects in the database that you want to restore or the import process will fail.

  11. Click Finish to begin importing objects.

  12. When the import process is completed, you will receive these message: "Process terminated successfully with no warnings."

    If errors or warnings exist, check the log file to review the export process.

  13. Perform a SELECT statement to verify that the backup tables are populated with data.