系统:CentOS 7.9
数据库:oracle 11.2.0.4
问题描述:数据库启动时报警ORA-03113,如下所示:
SQL> startup
ORACLE instance started.
Total System Global Area 2455228416 bytes
Fixed Size 2255712 bytes
Variable Size 620758176 bytes
Database Buffers 1811939328 bytes
Redo Buffers 20275200 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 64704
Session ID: 191 Serial number: 3
告警日志显示如下:
ALTER DATABASE MOUNT
Successful mount of redo thread 1, with mount id 4062781806
Database mounted in Exclusive Mode
Lost write protection disabled
WARNING: No local destinations have been defined for
archival of the Redo Log.
Completed: ALTER DATABASE MOUNT
Sun Aug 28 13:47:30 2022
ALTER DATABASE OPEN
LGWR: STARTING ARCH PROCESSES
Sun Aug 28 13:47:30 2022
ARC0 started with pid=20, OS id=65719
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
ARCH: LGWR is scheduled to archive destination LOG_ARCHIVE_DEST_2 after log switch
Errors in file /u01/app/oracle/diag/rdbms/orcl150/orcl151/trace/orcl151_ora_65717.trc:
ORA-16014: log 2 sequence# 23 not archived, no available destinations
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/orcl151/redo02.log'
Sun Aug 28 13:47:31 2022
ARC1 started with pid=21, OS id=65722
USER (ospid: 65717): terminating the instance due to error 16014
System state dump requested by (instance=1, osid=65717), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/orcl150/orcl151/trace/orcl151_diag_65684_20220828134732.trc
Dumping diagnostic data in directory=[cdmp_20220828134732], requested by (instance=1, osid=65717), summary=[abnormal instance termination].
Instance terminated by USER, pid = 65717
异常原因:归档路径不可用.
解决过程:
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination ?/dbs/arch
Oldest online log sequence 23
Next log sequence to archive 23
Current log sequence 25
SQL> alter system set log_archive_dest_1='location=/u01/app/oracle/fast_recovery_area/archivelog valid_for=(all_logfiles,all_roles) db_unique_name=orcl150';
System altered.
SQL> alter database open;
Database altered.
数据库启动时报警 ORA-03113 ORA-16014 ORA-00312
原创
©著作权归作者所有:来自51CTO博客作者Liujun_Deng的原创作品,请联系作者获取转载授权,否则将追究法律责任
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
ORA-65096: 公用用户名或角色名无效oracle oracle用户登录 ORA-65096
-
一个ORA-16014和ORA-00312错误的解决
一个ORA-16014和ORA-00312错误的解决
一个ORA-16014和ORA-0031 -
数据库启动报错ORA-03113,告警日志出现ORA-16038、ORA-19809、ORA-19815报警
数据库启动报错ORA-03113,告警日志出现ORA-16038、ORA-19809、ORA-19815报警
ORA-16038 ORA-19809 ORA-19815 ORA-03113 -
ORA-16014 解决办法
今天用sqlldr导入数据,结果中途报错,就中止了倒入,然后redolog就被占满了 就出了这么个报错,数据库mount后无法open。 以下来自网络,情况跟本人的一样,还好解决了: SQL> alter database open;alter databa
数据库 database sequence online available -
数据库在执行全库恢复后,open时报错ORA-01113、ORA-01110 ORA-00312 ORA-01113
数据库在执行全库恢复后,open时报错ORA-01113、ORA-01110 ORA-00312 ORA-01113
ORA-01113 ORA-01110 ORA-00312 ORA-01113