Oracle数据库频繁重启故障处理
近期,收到客户反馈一套Oracle 12.1版本单实例环境数据库重新启动后,实例自动关闭无法拉起。
01
故障分析
<msg time='2022-01-15T17:37:25.255+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='localhost.localdomain'
host_addr='::1' pid='53213'>
<txt>ORACLE Instance xxxxx (pid = 25) - Error 607 encountered while recovering transaction (37, 8) on object 5341044.
</txt>
</msg>
<msg time='2022-01-15T17:37:25.255+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='localhost.localdomain'
host_addr='::1' pid='53213'>
<txt>Errors in file /u01/app/oracle/diag/rdbms/xxxxx/xxxxx/trace/xxxxx_smon_53213.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [6856], [], [], [], [], [], [], [], [], [], [], []
</txt>
</msg>
……
<msg time='2022-01-15T17:37:34.483+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='localhost.localdomain'
host_addr='::1' pid='53165'>
<txt>Instance Critical Process (pid: 25, ospid: 53213, SMON) died unexpectedly
</txt>
</msg>
<msg time='2022-01-15T17:37:34.526+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='localhost.localdomain'
host_addr='::1' pid='53165'>
<txt>PMON (ospid: 53165): terminating the instance due to error 474
</txt>
</msg>
……
02
处理过程
ORA-600 [6006] ORA-600 [6856] During Startup Instance, Followed by Termination by SMON (Doc ID 549000.1)
create pfile=’/tmp/pfile01.ora’ from spfile;
echo '*.event="10513 trace name context forever, level 2"' >> /tmp/pfile01.ora
startup pfile=’/tmp/pfile01.ora’;
select object_id, data_object_id, owner, object_name from
dba_objects where object_id = 5341044 or data_object_id=5341044 ;
drop table xxxxx;
purge dba_recyclebin;
#关闭数据库
shutdown immediate;
pfile01.ora文件中去掉10513 event
# 起动数据库
startup pfile=’/tmp/pfile01.ora’;
# 检查数据库
select open_mode from v$database;
select * from v$recover_file;
#切换日志,查看预警日志中是否有报错信息
alter system switch logfile;
#重建删除的对象
03
总 结
将数据库数据文件从nas盘移出,放到服务器存储中。 -
升级数据库从12.1版本升级到19c稳定版本,减少bug的发生。
本文作者:徐利强
本文来源:IT那活儿(上海新炬王翦团队)
相关文章