SAP Knowledge Base Article - Preview

1888448 - ORA-16038 during startup

Symptom

During 'STARTUP' command the console issues the following error message:

SQL> startup
ORACLE instance started.

Total System Global Area 7315603456 bytes
Fixed Size                  2240632 bytes
Variable Size            2566918024 bytes
Database Buffers         4731174912 bytes
Redo Buffers               15269888 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 23117
Session ID: 46 Serial number: 3

Additionally, the Alert Log shows the following error message:

Sun Jul 14 18:46:49 2013
ARC2: Encountered disk I/O error 19502
Sun Jul 14 18:46:49 2013
ARCH: Encountered disk I/O error 19502
ARC2: Closing local archive destination LOG_ARCHIVE_DEST_1: '/oracle/<SID>/oraarch/<SID>arch1_4573_818449163.dbf' (error 19502) (<SID>)
ARCH: Closing local archive destination LOG_ARCHIVE_DEST_1: '/oracle/<SID>/oraarch/<SID>arch1_4572_818449163.dbf' (error 19502) (<SID>)
ARCH: I/O error 19502 archiving log 3 to '/oracle/<SID>/oraarch/<SID>arch1_4572_818449163.dbf'
ARC2: I/O error 19502 archiving log 2 to '/oracle/<SID>/oraarch/<SID>arch1_4573_818449163.dbf'
Errors in file /oracle/<SID>/saptrace/diag/rdbms/<SID>/<SID>/trace/<SID>_ora_17429.trc:
ORA-16038: log 3 sequence# 4572 cannot be archived
ORA-19502: write error on file "", block number  (block size=)
ORA-00312: online log 3 thread 1: '/oracle/<SID>/origlogB/log_g13m1.dbf'
ORA-00312: online log 3 thread 1: '/oracle/<SID>/mirrlogB/log_g13m2.dbf'
USER (ospid: 17429): terminating the instance due to error 16038
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance <SID> - Archival Error


Read more...

Environment

  • Operating System Independent
  • SAP Release Independent

    The error can happen on the below database releases
  • Oracle Database 10.2.0.5
  • Oracle Database 11.2.0.2
  • Oracle Database 11.2.0.3

Keywords

  • log_archive_dest_<n>
  • log_archive_dest
, KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.