ORA-03113: end-of-file on communication channel

    xiaoxiao2021-03-25  154

    --故障发生 SYS@PROD1> startup force ORACLE instance started. Total System Global Area 732352512 bytes Fixed Size 1347456 bytes Variable Size 356515968 bytes Database Buffers 373293056 bytes Redo Buffers 1196032 bytes Database mounted. ORA-03113: end-of-file on communication channel Process ID: 26630 Session ID: 1 Serial number: 5 --跟踪文件 ARCH: Closing local archive destination LOG_ARCHIVE_DEST_1: '/u01/app/oracle/fast_recovery_area/PROD1/archivelog/2017_03_08/o1_mf_1_118_dczmngto_.arc' (error 19502) (PROD1) ARC1: Encountered disk I/O error Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/PROD1/archivelog/2017_03_08/o1_mf_1_118_dczmngto_.arc ARCH: I/O error 19502 archiving log 1 to '/u01/app/oracle/fast_recovery_area/PROD1/archivelog/2017_03_08/o1_mf_1_118_dczmngto_.arc' Errors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_ora_26630.trc: ORA-16038: log 1 sequence# 118 cannot be archived ORA-19502: write error on file "", block number (block size=) ORA-00312: online log 1 thread 1: '/u01/app/oracle/fast_recovery_area/PROD1/redo01.log' ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/PROD1/redo01.log' Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/PROD1/archivelog/2017_03_08/o1_mf_1_119_dczmngtj_.arc ARC1: I/O error 19502 archiving log 2 to '/u01/app/oracle/fast_recovery_area/PROD1/archivelog/2017_03_08/o1_mf_1_119_dczmngtj_.arc' USER (ospid: 26630): terminating the instance due to error 16038 System state dump requested by (instance=1, osid=26630), summary=[abnormal instance termination]. System State dumped to trace file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_diag_26576.trc Dumping diagnostic data in directory=[cdmp_20170308172744], requested by (instance=1, osid=26630), summary=[abnormal instance termination]. Instance terminated by USER, pid = 26630 --解决方法 --由于归档日志空间不足,可以删除或备份旧的归档日志 [oracle@ocm1 ~]$ rm -rf /u01/app/oracle/fast_recovery_area/PROD1/archivelog/* SYS@PROD1> startup ORACLE instance started. Total System Global Area 732352512 bytes Fixed Size 1347456 bytes Variable Size 356515968 bytes Database Buffers 373293056 bytes Redo Buffers 1196032 bytes Database mounted. Database opened.
    转载请注明原文地址: https://ju.6miu.com/read-5882.html

    最新回复(0)