Oracle

The Oracle Backup plugin (data sources) utilizes RMAN (Recovery Manager) and 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 which can be setup from the command prompt and in-line with best practice we suggest shutting down hte database :

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