After a Windows or Linux computer with the Oracle Plug-in is added in Portal, you can create a backup job for one or more Oracle databases. The backup job specifies which databases to back up, and where to save the backup data.
The Oracle Plug-in performs what Oracle Corporation deems an “inconsistent” whole database backup, requiring that the database be run in ARCHIVELOG mode. During a live backup, any changes to the database will be written to archive logs. The database administrator should ensure that the database is in ARCHIVELOG mode.
When creating an Oracle database backup job, you must specify credentials for the Agent to use to connect to the Oracle server.
To back up the data, you can run the backup job manually, or schedule the backup job to run. See Run and schedule backups, synchronizations and custom commands.
To add an Oracle database backup job:
1. On the navigation bar, click Computers.
The Computers page shows registered computers.
2. Find a computer with the Oracle Plug-in, and expand its view by clicking the computer row.
3. Click the Jobs tab.
If a valid vault connection is not available for the computer, you cannot access the Jobs tab.
4. In the Select Job Task menu, click Create New Oracle Job.
5. In the Connect to Oracle Server dialog box, specify the following information:
•In the Database Service Name box, type the database instance.
•In the User Name box, type the name of a user who has sysdba privileges.
•In the Password box, type the password for the specified user.
6. Click Connect.
7. In the Create New Job dialog box, specify the following information:
•In the Name box, type a name for the backup job.
•In the Description box, optionally type a description for the backup job.
•In the Destination list, select the vault where you want to save the backup data.
A vault only appears in the list if it assigned to the user, or if the user added it on the computer’s Vault Settings tab.
•In the Log File Options list, select the level of detail for job logging. For more information, see Log file options|tag=Log file options.
•For new backup jobs, the encryption method is AES 256 bit. Existing jobs can have other encryption methods. See Encryption settings|tag=Encryption settings.
•In the Password and Confirm Password boxes, enter an encryption password. You can also enter a password hint in the Password Hint box.
8. In the Include in Backup box, select the database that you want to back up.
9. Click Save.
The job is created, and the View/Add Schedule dialog box appears. Now you can create a schedule for running the backup. Click Cancel if you do not want to create a schedule at this time.
For information about how to run and schedule the backup job, see Run and schedule backups, synchronizations and custom commands.