启动时的提示: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 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 执行包动态执行表不可用,到v$session等地方寻找权限
- 求助:ORACLE远程连接配置问题(网上的方法试过了还不行,内详)
- Win7 64 安装oracle11g plsql 配置完后查询数据中文显示乱码
- 为什么在存储过程里选不出值来?
- object内的%type问题
- 关于一些oracle的sql 小问题,希望高手赐教
- PROC/C++ SAMPLE CODE的问题(急)
- 求一个调用存储过程的语句,非常简单,但我却不会,大家帮个忙!
- 想问一个问题好久了,oracle到底有没有像sql server那样的联机手册呀?
- oracle store procedure語法問題
- 关于数据库数据查询效率
有详细的说明。
按照这个 没有找到大的日志文件就是春节前 服务器直接被断电了 没有正常关闭
现在oracle无法启动了
最好先备份然后作一个操作系统层的恢复。保证你的软件、数据在操作系统层能够正确使用,并且操作系统没有报错。然后再看看oracle能不能启动。
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'日志上面这个数据文件有问题,出现了坏块你如果有备份的话,把这个数据文件恢复一下试试
应该有还其他的问题,你需要一步步的来解决,不过有备份的话,一切都简单了直接恢复就是了