Oracle

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

Where Backup & Recovery options are not present on your N-sight RMM dashboard, this means you will now need to use Cove.

To start a 30-day free trial of Cove by clicking into the app switcher in at the top right of the N-sight RMM dashboard, and selecting Cove Data Protection (Cove).

The Oracle plugin (data sources) utilizes (RMAN) (Recovery Manager). In order for RMAN to backup the Oracle database correctly, it is necessary to enable archiving, which is not setup by default and requires sysdba privileges to apply.

Enable Archiving Mode

From the command prompt enter:

sqlplus /nolog

The nolog switch opens an sqlplus session on the server without logging into a database, once entered connect as sysdba:

SQL> connect / as sysdba

The first step it to check whether archiving is already setup and this can be verified from the command prompt:

SQL> select log_mode from v$database;
LOG_MODE
------------
NOARCHIVELOG

Where NOARCHIVELOG is returned, archiving must be setup. This can be configured from the command prompt and in-line with best practice we suggest shutting down the database first:

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

...

Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

Once complete, the select log_mode from v$database; command can be used to confirm archiving is enabled.

SQL> select log_mode from v$database;

LOG_MODE

ARCHIVELOG