Introducing Arcserve Backup Agents and Options › Using Agents › Agent for Oracle › Using the Agent in File-Based Mode › Back Up Using the Agent for Oracle in File-based Mode › Back Up One or More Databases Online

Back Up One or More Databases Online

The agent lets you back up individual Oracle database objects, such as tablespaces, archived redo log files, and control files.

To back up one or more Oracle databases online using the agent

1. Ensure that the Oracle server is running.

   Note: You must have all Arcserve Backup engines running along with the Arcserve Universal Agent service.

2. On the Backup Manager Source tab, select the databases that you want to back up. You can select any number of databases in any combination or all of them together. Ensure all of the tablespaces on the database are online before backing up the Oracle database.
   • When you back up multiple databases, the Backup Manager prompts you to enter the user name and password for each database, if instance is not using Windows authentication. All options that apply to backing up a single online database can be applied to backing up multiple online databases.

     Note: If the Oracle instance is using Windows authentication, the Backup Manager does not prompt you to enter the user name and password details.

   • 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 three additional sessions—for archive logs of each Oracle database, control file and parameter file.

   Note: If you select ARCHIVE LOG, the agent backs up all of the archived log files under the archive log directory.

3. Click the Destination tab to select a backup destination.
4. Click the Schedule tab to select Custom Schedule or Use Rotation Scheme.
5. Click Submit to submit the job.

   The Security and Agent Information dialog opens.

6. Select the Oracle object on the Security and Agent Information dialog, and then click Security.

   The Security dialog opens.

   Note: If you have a client agent installed, click Agent. The Agent Information dialog opens. Enter the configuration parameters for the client agent you have installed. Click OK when finished.

7. Enter the Oracle user name and password and click OK.

   Note: The user name and password must be for a user who has backup or database administrator privileges. If Windows authentication is used the Oracle instance will not prompt you to enter the database user name and password.

8. Click OK on the Security and Agent Information dialog.

   The Submit Job dialog opens.

9. Click OK.

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