Remote Monitoring & Management Help

Oracle databases

Oracle Databases can be backed up and restored from Agent 8.15 onwards.

The Oracle Backup plugin (data source) utilizes RMAN (Recovery Manager) and in order for RMAN to backup the Oracle database correctly it is necessary to enable archiving which is covered here.

  1. Open the Backup Manager
  2. Navigate to the Backup tab
  3. Click Add against Oracle
  4. In Selection Oracle click Add
  5. Enter the Server, Administrator Login*, Password and Path
  6. Save to apply

Field

Notes

Server

The TNS alias specified in tnsnames.ora

Administrator Login*

An Oracle account name with SYSDBA permissions

Password

The password associated with the above Administrative Login account

Path (to the local backup folder)

The Backup Manager records backups in C:\EXPORT\HOME\APP\ORACLE\BACKUP.

As such it is necessary to create this folder then enter C:\EXPORT\HOME\APP\ORACLE\BACKUP in the Path to the local backup folder.

The Backup Manager will connect to the Oracle server to verify the credentials; where successfully go to the Backup tab and in the Oracle section expand** the Oracle databases node and select the databases to backup.

Finally, configure the Oracle databasesSchedule and amend the Backup & Recovery Check to take account of the increased backup jobs

To amend the selected data sources open the Backup Manager, go to the Backup tab, click Edit in Backup & Recovery 2014, expand the node and change the selection.

** In Backup & Recovery 2014 it may be necessary to click the Oracle database name to display the node structure.

mob_2014_oracle

*Create User

Rather than enter the sysdba details in the Backup Manager, it is possible to create another user and use these credentials instead.

From the command prompt enter:

sqlplus /nolog

Then connect as sysdba:

SQL> connect / as sysdba

From here the new user can be generated using:

SQL> create user USERNAME identified by PASSWORD;

Once created it can be given full permissions:

SQL> grant all privileges to USERNAME;

Troubleshooting - Insufficient Privileges

Where the error ORA-01031: insufficient privileges is returned when attempting to log in with sysdba then log on with the command:

sqlplus sys as sysdba

When prompted enter the password created when setting up the database during installation