Oracle backup job fails with error code 5411: Cannot do a hot backup of a database in NOARCHIVELOG mode

Article: 100048267
Last Published: 2020-08-21
Ratings: 1 2
Product(s): NetBackup

Problem

Oracle backup job fails with error code 5411: Cannot do a hot backup of a database in NOARCHIVELOG mode

Error Message

Aug 20, 2020 4:53:47 PM - Error bpbrm (pid=30092) from client : ERR - bphdb exit status = 5411: Cannot do a hot backup of a database in NOARCHIVELOG mode
Aug 20, 2020 4:53:47 PM - Info bphdb (pid=90506) done. status: 5411: Cannot do a hot backup of a database in NOARCHIVELOG mode
Aug 20, 2020 4:53:47 PM - end writing
Cannot do a hot backup of a database in NOARCHIVELOG mode  (5411)

Cause

Oracle database is running in NOARCHIVELOG mode.

Solution

For a hot backup of Oracle database to work, we need the database running in ARCHIVELOG mode.
If the database is using NOARCHIVELOG mode, then the backup will fail with above error.
Kindly contact Oracle Database admin and change the database to run using ARCHIVELOG mode.
More information can be found on below Oracle document: NOARCHIVELOG Mode
 

Was this content helpful?