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"

Problem

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 Message

[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.


Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)