• 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. How to Merge Multiple Partitions in Oracle 12c
  2. df Command Examples in Linux
  3. Basics of Ethernet Bonding in Linux
  4. Oracle Database Interview Questions : Redo Logs and Archiving
  5. CentOS / RHEL 7 : How to enable or disable automatic updates (via packagekit)
  6. Oracle 12c: Unplug/Plug PDB to new CDB using RMAN Active Database Duplication
  7. Oracle SQL : Script To Convert Hexadecimal Input Into a Decimal Value
  8. Oracle Database : Performing Incomplete Recovery from a missing archivelog file (Change-Based, Cancel-Based, Time-Based)
  9. Adding Static Routes On Various *NIX (Linux,AIX,HP-UX)
  10. How to restore files under user’s home directory to default in Linux

You May Also Like

Primary Sidebar

Recent Posts

  • vgextend Command Examples in Linux
  • setpci command – configure PCI device
  • db_load command – generate db database
  • bsdtar command – Read and write tape archive files

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright