Oracle databases

To offer an enhanced solution, standalone Cove Data Protection (Cove) replaced Backup and Recovery. Where Backup and Recovery has been enabled and continues to be so for devices, the options presented here are still available.

If Backup and Recovery options are not present in your N-sight RMM, you need to use Cove.

To start a 30-day free trial of Cove, click the app switcher in the Product Bar, and select Cove Data Protection (Cove).

Oracle Databases can be backed up and restored from Advanced Monitoring 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 the Selection Oracle dialog click Add
  5. Enter the Server, Administrator Login, Password and Path

    6. Field Description
    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
  6. Save to apply
  7. 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

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

  8. Configure the Oracle databases Schedule
  9. Finally, amend the Backup & Recovery Check to take account of the increased backup jobs

To amend the selected data sources:

  1. Open the Backup Manager
  2. Go to the Backup tab
  3. Click Edit and expand the node and change the selection as required

Create Administrator Login User

Rather than enter the sysdba details in the Backup Manager, you can create another user and use these credentials instead.

To create a new user:

  1. From the command prompt enter:

    2. sqlplus /nolog

  2. Then connect as sysdba:

    3. SQL> connect / as sysdba

  3. From here the new user can be generated using:

    4. SQL> create user USERNAME identified by PASSWORD;

  4. Once created it can be given full permissions:

    5. 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:

  1. Log on with the command:

    2. sqlplus sys as sysdba

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