当前位置: 代码迷 >> Oracle技术 >> 服务器断电后,oracle启动时报错,该怎么处理
  详细解决方案

服务器断电后,oracle启动时报错,该怎么处理

热度:120   发布时间:2016-04-24 08:33:25.0
服务器断电后,oracle启动时报错
启动时的提示:

SQL> startup
ORACLE instance started.

Total System Global Area 3206836224 bytes
Fixed Size 2217632 bytes
Variable Size 2063599968 bytes
Database Buffers 1124073472 bytes
Redo Buffers 16945152 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 11700
Session ID: 191 Serial number: 3


启动日志的错误提示:

Errors in file /opt/oracle/diag/rdbms/orcl/orcldyne/trace/orcldyne_p001_11704.trc (incident=173313):
ORA-00600: internal error code, arguments: [kdxlin:psno out of range], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /opt/oracle/diag/rdbms/orcl/orcldyne/incident/incdir_173313/orcldyne_p001_11704_i173313.trc
Sun Jan 29 18:09:28 2012
Exception [type: SIGBUS, Non-existent physical address] [ADDR:0x65FFFFF8] [PC:0x3037C7C711, _wordcopy_bwd_dest_aligned()+161] [flags: 0x0, count: 1]
Errors in file /opt/oracle/diag/rdbms/orcl/orcldyne/trace/orcldyne_p002_11706.trc (incident=173321):
ORA-07445: exception encountered: core dump [_wordcopy_bwd_dest_aligned()+161] [SIGBUS] [ADDR:0x65FFFFF8] [PC:0x3037C7C711] [Non-existent physical address] []
Incident details in: /opt/oracle/diag/rdbms/orcl/orcldyne/incident/incdir_173321/orcldyne_p002_11706_i173321.trc
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x66FFA24FFFE9] [PC:0x3F1657E, kcbs_dump_adv_state()+616] [flags: 0x0, count: 1]
Errors in file /opt/oracle/diag/rdbms/orcl/orcldyne/trace/orcldyne_p001_11704.trc (incident=173314):
ORA-07445: exception encountered: core dump [kcbs_dump_adv_state()+616] [SIGSEGV] [ADDR:0x66FFA24FFFE9] [PC:0x3F1657E] [Address not mapped to object] []
ORA-00600: internal error code, arguments: [kdxlin:psno out of range], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /opt/oracle/diag/rdbms/orcl/orcldyne/incident/incdir_173314/orcldyne_p001_11704_i173314.trc
Trace dumping is performing id=[cdmp_20120129180929]
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x66FFA28FFFE9] [PC:0x3F1657E, kcbs_dump_adv_state()+616] [flags: 0x0, count: 2]
Errors in file /opt/oracle/diag/rdbms/orcl/orcldyne/trace/orcldyne_p002_11706.trc (incident=173322):
ORA-07445: exception encountered: core dump [kcbs_dump_adv_state()+616] [SIGSEGV] [ADDR:0x66FFA28FFFE9] [PC:0x3F1657E] [Address not mapped to object] []
ORA-07445: exception encountered: core dump [_wordcopy_bwd_dest_aligned()+161] [SIGBUS] [ADDR:0x65FFFFF8] [PC:0x3037C7C711] [Non-existent physical address] []
Incident details in: /opt/oracle/diag/rdbms/orcl/orcldyne/incident/incdir_173322/orcldyne_p002_11706_i173322.trc
Errors in file /opt/oracle/diag/rdbms/orcl/orcldyne/incident/incdir_173321/orcldyne_p002_11706_i173321.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [kcbs_dump_adv_state()+616] [SIGSEGV] [ADDR:0x66FFA28FFFE9] [PC:0x3F1657E] [Address not mapped to object] []
ORA-07445: exception encountered: core dump [_wordcopy_bwd_dest_aligned()+161] [SIGBUS] [ADDR:0x65FFFFF8] [PC:0x3037C7C711] [Non-existent physical address] []
Trace dumping is performing id=[cdmp_20120129180930]
Errors in file /opt/oracle/diag/rdbms/orcl/orcldyne/trace/orcldyne_p001_11704.trc (incident=173315):
ORA-01578: ORACLE data block corrupted (file # 2, block # 32426)
ORA-01110: data file 2: '/opt/oracle/oradata/orcl/sysaux01.dbf'
ORA-10564: tablespace SYSAUX
ORA-01110: data file 2: '/opt/oracle/oradata/orcl/sysaux01.dbf'
ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 86703
ORA-00600: internal error code, arguments: [kdxlin:psno out of range], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /opt/oracle/diag/rdbms/orcl/orcldyne/incident/incdir_173315/orcldyne_p001_11704_i173315.trc
  相关解决方案