Oracle
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