Introducing Arcserve Backup Agents and Options › Using Options › Enterprise Option for SAP R/3 for Oracle › Using the Option with Agent for Oracle › Database Backup › Back Up Online Databases with Arcserve Backup

Back Up Online Databases with Arcserve Backup

If you back up an Oracle database using the Arcserve Backup interface, you must restore it using the Arcserve Backup interface. Similarly, if you back up an Oracle database using Recovery Manager, you must restore it using Recovery Manager.

To back up an Oracle database

1. Ensure that the Oracle server application is running.
2. Start Arcserve Backup and the option.
3. In the Source tab on the Backup Manager, select the databases that you want to back up. You can select any number of databases in any combination, or all of them together.

   Important! Make sure all of the tablespaces on the database are online before backing up the Oracle database.

   When you back up multiple databases, you are prompted to enter the user name and password for each database. All options that apply to backing up a single online database can be applied to backing up multiple online databases.

   Databases are backed up sequentially on the media.

   Arcserve Backup saves each tablespace (or database object) as a session. Therefore, the total number of sessions equals the total number of tablespaces, plus two additional sessions: one for archive logs for each Oracle database, and the other for the control file.

   Note: If you select ~ARCHIVE LOG, the option backs up all of the archived log files under the archive log directory. If you select the control file, you must select only the control file or select the control file and all other tablespaces; otherwise the backup job will fail.

4. Click the Destination tab to select a backup destination.
5. Click the Schedule tab. Choose Custom Schedule or Use Rotation Scheme, and select the scheduling options you want to apply to the job.
6. Click Submit to submit the job.

   The Security and Agent Information dialog opens.

7. Enter security information.

   Note: In the Security and Agent Information dialog, the column and button labeled Agent refer to the Client Agent, not the Enterprise Option for SAP R/3 for Oracle. You can enter client agent information.

   See the Arcserve Backup Client Agents Guide for more information about Client Agents.

8. Select the Oracle object and click Security.

   You can enter or change the user name and password for the Oracle server application.

9. Click OK.

   The Submit Job dialog opens.

10. Click OK.

    The job is submitted to the queue and can be monitored from the Job Queue Manager.

Note: For more information about customizing your backup, see the Administration Guide.