• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Archiving Failures with ORA-16038, ORA-19504, ORA-00312

by admin

Problem 1

After the server was patched on OS level, the following database error messages are reported in the alert.log file:

Unable to create archive log file '/path/name.arc'
ARC3: Error 19504 Creating archive log file to '/path/name.arc'
ARCH: Archival stopped, error occured. Will continue retrying.
ORACLE instance "name" - Archival error
ORA-16038: log 3 sequence #2639 cannot be archived
ORA-19504: failed to create file "name"
ORA-00312: online log 3 thread 1: '/path/redo03.log'
ORA-16014: log 3 sequence #2639 not archived, no available destinations.

The Solution

The reason is an Antivirus McFee for LinuxShield which was installed and blocking access/writes to local filesystems. If there is a disk access issue it is expected to have those errors. Modify the Antivirus settings so that no Oracle files are scanned when the database is running.

Problem 2

Below errors were observed in the alert log for for the database:

Mon Aug 22 16:59:05 2016
Archiver process freed from errors. No longer stopped
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance openprod - Archival Error
ORA-16014: log 3 sequence# 3 not archived, no available destinations
ORA-00312: online log 3 thread 1: '/oracle/openprod/origlogA/openprod/redo03a.log'
ORA-00312: online log 3 thread 1: '/oracle/openprod/mirrlogA/openprod/redo03b.log'
Mon Aug 22 17:04:05 2016
Archiver process freed from errors. No longer stopped
Mon Aug 22 17:04:05 2016
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance openprod - Archival Error
ORA-16038: log 3 sequence# 3 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 3 thread 1: '/oracle/openprod/origlogA/openprod/redo03a.log'
ORA-00312: online log 3 thread 1: '/oracle/openprod/mirrlogA/openprod/redo03b.log'

Cause : Archive destination was not having proper permissions.
Solution : After checking error, it was issue of permissions of archive destinations.
ORA-19504: failed to create file “”

The Solution

Changing the permission of archive dest, resolved the problem.

# chown -R oracle:oinstall /oracle/openprod/oraarch/archive
# chmod -R 775 /oracle/openprod/oraarch/archive

After changing the permissions & alert log content as follows:

Archiver process freed from errors. No longer stopped
Mon Aug 22 17:09:05 2016
Archived Log entry 1 added for thread 1 sequence 3 ID 0xc45f408a dest 1:
krse_arc_driver_core: Successful archiving of previously failed ORL
Mon Aug 22 17:09:06 2016
Thread 1 advanced to log sequence 6 (LGWR switch)
 Current log# 3 seq# 6 mem# 0: /oracle/openprod/origlogA/openprod/redo03a.log
 Current log# 3 seq# 6 mem# 1: /oracle/openprod/mirrlogA/openprod/redo03b.log
Archived Log entry 2 added for thread 1 sequence 4 ID 0xc45f408a dest 1:
Mon Aug 22 17:09:08 2016
Archived Log entry 3 added for thread 1 sequence 5 ID 0xc45f408a dest 1:
Thread 1 advanced to log sequence 7 (LGWR switch)
 Current log# 1 seq# 7 mem# 0: /oracle/openprod/origlogA/openprod/redo01a.log
 Current log# 1 seq# 7 mem# 1: /oracle/openprod/mirrlogA/openprod/redo01b.log
Archived Log entry 4 added for thread 1 sequence 6 ID 0xc45f408a dest 1:
Thread 1 cannot allocate new log, sequence 8

Filed Under: Linux, oracle

Some more articles you might also be interested in …

  1. groupadd: command not found
  2. How to change the interface name in CentOS/RHEL 8 using prefixdevname
  3. ntpq: command not found
  4. How To Configure Timeout On SSH Client Putty
  5. avahi-browse Command Examples in Linux
  6. How to Move Swap From Disk Partition to LVM Volume in Linux
  7. How to enable SFTP Logging without chroot in CentOS/RHEL
  8. sesearch: command not found
  9. exec Command Examples in Linux
  10. pidof: command not found

You May Also Like

Primary Sidebar

Recent Posts

  • qsub Command Examples in Linux
  • qsub: command not found
  • qrcp Command Examples in Linux
  • qmrestore Command Examples in Linux

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright