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
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.