xieyihn

19 积分	0 好友	0 主题

发消息

服务器断电，无法启动！ORA-00600: [4194]

1^#

发表于 2012-8-16 11:55:48 | 查看: 5187| 回复: 2

11.2.0.3 64bit 非归档无备份
服务器突然断电  重启之后
ERROR at line 1:
ORA-01113: file 3 needs media recovery
ORA-01110: data file 3: '/opt/app/oracle/oradata/webdb/undotbs01.dbf'

SQL> recover datafile 3;
ORA-00283: recovery session canceled due to errors
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 48221 change 5772872 time 08/15/2012
23:36:28
ORA-00312: online log 1 thread 1: '/opt/app/oracle/oradata/webdb/redo01.log'

我修改了隐含参数_ALLOW_RESETLOGS_CORRUPTION = true
然后
SQL> recover database until cancel;

SQL> alter database open resetlogs;

现在的情况是一启动就自动关闭，alert日志有很多的ORA-00600错误
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
parallel recovery started with 15 processes
Started redo scan
Completed redo scan
read 756 KB redo, 200 data blocks need recovery
Started redo application at
Thread 1: logseq 7, block 3
Recovery of Online Redo Log: Thread 1 Group 1 Seq 7 Reading mem 0
  Mem# 0: /opt/app/oracle/oradata/webdb/redo01.log
Completed redo application of 0.65MB
Completed crash recovery at
Thread 1: logseq 7, block 1516, scn 5884577
200 data blocks read, 200 data blocks written, 756 redo k-bytes read
Thread 1 advanced to log sequence 8 (thread open)
Thread 1 opened at log sequence 8
  Current log# 2 seq# 8 mem# 0: /opt/app/oracle/oradata/webdb/redo02.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
[7096] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:4294897090 end:4294897130 diff:40 (0 seconds)
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is AL32UTF8
No Resource Manager plan active
Errors in file /opt/app/oracle/diag/rdbms/webdb/webdb/trace/webdb_smon_7062.trc  (incident=33780):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /opt/app/oracle/diag/rdbms/webdb/webdb/incident/incdir_33780/webdb_smon_7062_i33780.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Thu Aug 16 11:28:07 2012
QMNC started with pid=36, OS id=7128
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x3EDF7CA4] [PC:0x932F8EA, kgegpa()+40] [flags: 0x0, count: 1]
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x3EDF7CA4] [PC:0x932DEF3, kgebse()+771] [flags: 0x2, count: 2
]
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x3EDF7CA4] [PC:0x932DEF3, kgebse()+771] [flags: 0x2, count: 2
]
Thu Aug 16 11:28:07 2012
db_recovery_file_dest_size of 10240 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Dumping diagnostic data in directory=[cdmp_20120816112808], requested by (instance=1, osid=7062 (SMON)), summary=[incident=3
3780].
Block recovery from logseq 8, block 77 to scn 5884675
Recovery of Online Redo Log: Thread 1 Group 2 Seq 8 Reading mem 0
  Mem# 0: /opt/app/oracle/oradata/webdb/redo02.log
Block recovery completed at rba 8.81.16, scn 0.5884676
Block recovery from logseq 8, block 77 to scn 5884654
Recovery of Online Redo Log: Thread 1 Group 2 Seq 8 Reading mem 0

分享0