服务器断电后，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
Errors in file /opt/oracle/diag/rdbms/orcl/orcldyne/trace/orcldyne_p001_11704.trc:
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], [], [], [], [], [], [], [], [], [], [], []
Errors in file /opt/oracle/diag/rdbms/orcl/orcldyne/trace/orcldyne_p001_11704.trc (incident=173316):
ORA-00600: internal error code, arguments: [kdxlin:psno out of range], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /opt/oracle/diag/rdbms/orcl/orcldyne/incident/incdir_173316/orcldyne_p001_11704_i173316.trc
Sun Jan 29 18:09:32 2012
Trace dumping is performing id=[cdmp_20120129180932]
Errors in file /opt/oracle/diag/rdbms/orcl/orcldyne/trace/orcldyne_p001_11704.trc (incident=173317):
ORA-01578: ORACLE data block corrupted (file # 2, block # 32430)
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_173317/orcldyne_p001_11704_i173317.trc
Trace dumping is performing id=[cdmp_20120129180933]
Errors in file /opt/oracle/diag/rdbms/orcl/orcldyne/trace/orcldyne_p001_11704.trc:
ORA-01578: ORACLE data block corrupted (file # 2, block # 32430)
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], [], [], [], [], [], [], [], [], [], [], []
Errors in file /opt/oracle/diag/rdbms/orcl/orcldyne/trace/orcldyne_p001_11704.trc (incident=173318):
ORA-00600: internal error code, arguments: [kdxlin:psno out of range], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /opt/oracle/diag/rdbms/orcl/orcldyne/incident/incdir_173318/orcldyne_p001_11704_i173318.trc
Trace dumping is performing id=[cdmp_20120129180934]
Errors in file /opt/oracle/diag/rdbms/orcl/orcldyne/trace/orcldyne_p001_11704.trc (incident=173319):
ORA-01578: ORACLE data block corrupted (file # 2, block # 32434)
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_173319/orcldyne_p001_11704_i173319.trc
Errors in file /opt/oracle/diag/rdbms/orcl/orcldyne/trace/orcldyne_p001_11704.trc:
ORA-01578: ORACLE data block corrupted (file # 2, block # 32434)
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], [], [], [], [], [], [], [], [], [], [], []
Errors in file /opt/oracle/diag/rdbms/orcl/orcldyne/trace/orcldyne_p001_11704.trc (incident=173320):
ORA-00600: internal error code, arguments: [kdxlin:psno out of range], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /opt/oracle/diag/rdbms/orcl/orcldyne/incident/incdir_173320/orcldyne_p001_11704_i173320.trc
Sun Jan 29 18:09:38 2012
Errors in file /opt/oracle/diag/rdbms/orcl/orcldyne/trace/orcldyne_p001_11704.trc (incident=174345):
ORA-01578: ORACLE data block corrupted (file # 2, block # 32570)
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_174345/orcldyne_p001_11704_i174345.trc
Sun Jan 29 18:10:16 2012
Aborting crash recovery due to slave death, attempting serial crash recovery
Beginning crash recovery of 1 threads
Started redo scan
Completed redo scan
read 3161 KB redo, 266 data blocks need recovery
Started redo application at
Thread 1: logseq 2007, block 17161
Recovery of Online Redo Log: Thread 1 Group 3 Seq 2007 Reading mem 0
Mem# 0: /opt/oracle/oradata/orcl/redo03.log
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_ora_11700.trc (incident=173297):
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_173297/orcldyne_ora_11700_i173297.trc
Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x3F1657E, kcbs_dump_adv_state()+616] [flags: 0x0, count: 2]
[解决办法]
你的错误应该是异常断电后文件系统或者磁盘设备有问题了。
最好先备份然后作一个操作系统层的恢复。保证你的软件、数据在操作系统层能够正确使用，并且操作系统没有报错。然后再看看oracle能不能启动。
[解决办法]
用sqlplus / as sysdba 连不上吗？
[解决办法]
日志回复一下了。
[解决办法]
断电出现这种问题很正常
[解决办法]
ORA-01578: ORACLE data block corrupted (file # 2, block # 32434)
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'
日志上面这个数据文件有问题，出现了坏块
你如果有备份的话，把这个数据文件恢复一下试试