Creating a Backup for Oracle on UNIX or Windows

To create a backup for Oracle on UNIX or Windows:

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

  2. Type the name for the export utility .dmp file.

    Click the Browse button to select the directory where the .dmp file will reside.

  3. Click Next.

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

    Note: Objects selected in the tree on the Data Manager form appear in the Selected Objects form. You can move objects between forms using the arrow buttons or by dragging and dropping.

    To export objects, expand the Available Objects tree and select the item to export. Use the arrows to move objects to and from the Selected Objects form.

  5. On the Tuning form, select generate a log file, if needed.

  6. Click Next.

    Note: Select the Generate Log File option and enter a log file name or use Browse to select a log file.
  7. On the Advanced Options form, take the default values or select the desired options, and click Next.

  8. On the Summary form, verify that all of the chosen objects and options are correct.

  9. Click Finish to begin exporting objects.

    A message window opens that displays information about the progress of the export process.

    When the export process is completed, you will receive these message: "Export terminated successfully without warnings."

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