首页 > 数据库 >数据库启动时报警 ORA-03113 ORA-16014 ORA-00312

数据库启动时报警 ORA-03113 ORA-16014 ORA-00312

时间:2022-10-28 21:31:11浏览次数:42  
标签:log 65717 00312 instance orcl151 16014 oracle ORA

系统: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.

标签:log,65717,00312,instance,orcl151,16014,oracle,ORA
From: https://blog.51cto.com/u_12991611/5805282

相关文章

  • vuex和浏览器【sessionStorage,localStorage ..】 得区别
    1.Vuex的主要作用是用来共享和管理数据,那为什么不直接使用浏览器缓存呢?2.Vuex和浏览器缓存策略的根本区别是什么?3.Vuex,state仓库中的数据流是单向同步的,那为什么可以在act......
  • 亲测成功解决Typora旧版本无法使用提示需要更新的问题
    原链接:https://blog.csdn.net/apple_51240831/article/details/125995383 参考视频:【typora】ThisbetaversionofTyporaisexpired解决方法之一_哔哩哔哩_bilibili......
  • 安装Oracle11
    安装oracle数据库​注意设置交换分区​关闭防火墙​systemctlstopNetworkManager&&systemctldisableNetworkManager​systemctlstopfirewalld&&systemctldisabl......
  • Oracle数据库主从复制
    主从复制​主从复制简介:​主从复制,是用来建立一个和主数据库完全一样的数据库环境,称为从数据库;主数据库一般是实时的业务数据库,从数据库的作用和使用场合一般有几个:​一、作......
  • Oracle数据库主从切换
    Oracle主从切换​主从查看打开状态:[root@odb1~]#su-oracleexportNLS_LANG="AMERICAN_AMERICA.ZHS16GBK"[oracle@odb1~]$source.bash_profile[oracle@odb1~]$sql......
  • Oracle数据库备份恢复
    ORACLE数据库备份恢复​一.​1.备份生产数据库​在线备份:​采用ARCHIVELOGmode方式备份,可以脱机或联机备份。需要备份数据库和归档日志​$.oraenvORACLE_SID=[prim]?......
  • Oracle安装示例数据库(Linux)
    前言数据库示例(OracleDatabaseExamples)包含了一系列的示例脚本和产品功能演示的Schema信息,在学习Oracle数据库的过程中可以通过这些示例更好的掌握数据库相关的选项和......
  • LoRa在智能家居当中的物联网应用
    一、智能家居行业背景2020年,中国智能家居进入AIoT赋能期,全面革新智能家居产品形态。从市场规模来看,2019年智能家居市场规模达到1530亿元左右,2020年将达1820亿元。从设备出货......
  • Oracle RAC调整网卡MTU值
    ---原文https://cloud.tencent.com/developer/article/1658019在OracleRAC的环境中,如果我们发现OSW监控数据显示包重组失败率过高,就需要引起足够的重视,因为这很可能会引......
  • Oracle 数据库 日常操作函数
    --获取当天数据select*fromPOS_TRANMAINwheretrunc(SLDATE)=trunc(sysdate);--decode等同于casewhenthendecode(条件,值1,返回值1,值2,返回值2....)--to_char......