Oracle

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).

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