Oracle backup job fails with error code 5411: Cannot do a hot backup of a database in NOARCHIVELOG mode
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