Summary
Question
When I attempt to backup an Oracle tablespace in Data Protecor, I get the following error :
RMAN-03090: Starting backup at 17-FEB-17
RMAN-08048: channel dev_0: starting incremental level 0 datafile backup set
RMAN-08010: channel dev_0: specifying datafile(s) in backup set
RMAN-08031: released channel: dev_0
RMAN-08031: released channel: dev_1
RMAN-08031: released channel: dev_2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on dev_0 channel at 02/17/2017 02:50:40
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
Recovery Manager complete.
[Major]
External utility reported error.
From: ob2rman@client "QDB" Time: 02/17/17 02:50:42Answer
The error "ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode" is the key problem here which is totally and Oracle issue. Below is more information from Oracle's oerr utility. The solution to this problem is to turn on archivelog mode for the Oracle database which has to be done from with Oracle's sqlplus utility :
[QDB] $ oerr ora 19602
19602, 00000, "cannot backup or copy active file in NOARCHIVELOG mode"
// *Cause: You tried to copy or backup a file that was not closed cleanly,
// and the database was in NOARCHIVELOG mode. This is not allowed
// because when restored, the file will require redo application
// before it is usable, and redo is not currently being saved
// beyond the contents of the online redo logs.
// *Action: Take the tablespace offline clean or close the database and retry
// the copy or backup.