- 最后登录
- 2012-12-28
- 在线时间
- 5 小时
- 威望
- 19
- 金钱
- 141
- 注册时间
- 2012-7-9
- 阅读权限
- 10
- 帖子
- 10
- 精华
- 0
- 积分
- 19
- UID
- 580
|
1#
发表于 2012-8-16 11:55:48
|
查看: 5247 |
回复: 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 |
|