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;

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;