Oracle database backups fails with error "0xe0001014 - The database is in NOARCHIVELOG mode and is OPEN. To back up the database when it is in NOARCHIVELOG mode, the database must be MOUNTED but not OPEN"

Article:TECH199818  |  Created: 2012-11-15  |  Updated: 2012-11-15  |  Article URL http://www.symantec.com/docs/TECH199818
Article Type
Technical Solution


Issue



Oracle database backups fails with the error "0xe0001014 - The database is in NOARCHIVELOG mode and is OPEN. To back up the database when it is in NOARCHIVELOG mode, the database must be MOUNTED but not OPEN"


Error



[fsys\oracle]        - RMAN_DoCommand: Error return: (36)
[fsys\oracle]        - ErrCodeTranslate(): Converting DBSB error code (0x24) to E_RMAN/E_ENGINE error code (0xe0001014)
[ndmp\loops]         - LP_DelegateBackupRestoreDLE: Error returned by LP_DelegateBackupRestoreDLEFunc thread (0xE0001014) )
[ndmp\loops]         - LP_ENV::MsgError: error 0xe0001014 processing object


Cause



1) Ensure Archive Logging is enabled for the database that is being backed up
Refer : http://www.symantec.com/docs/TECH54326

2) If Archive Log is enabled and remote agent on Oracle server shows the above error in debug then check the database address description specified in the TNSNAMES.ORA file. It could be that it is using an incorrect Oracle Server IP Address.


Solution



Confirm if the database address used for the database being backed up has the correct oracle server IP address defined in the HOST variable. If the entries are incorrect then modify the file and then try the backup.

To modify the TNSNAMES.ORA file please refer the following document or contact Oracle Support (http://docs.oracle.com/cd/E14072_01/network.112/e10835/tnsnames.htm)

Note:- It is recommended to consult Oracle DBA or ORACLE support before modifying this file.





Article URL http://www.symantec.com/docs/TECH199818


Terms of use for this information are found in Legal Notices