无归档日志备份的full backup如何进行恢复？
接到一个古老的全备份被要求恢复，里面没有归档日志的备份，不完全恢复是不可能了。restore备份后，设置_allow_resetlogs_corruption后open resetlogs，依然无法启动。
查看alter日志，报ora-600 错误
Errors in file /u01/app/oracle/admin/dw/udump/dw_ora_1418.trc:
ORA-00600: internal error code, arguments: , , [], [], [], [], [], []
Fri Sep 23 20:32:43 2016
Errors in file /u01/app/oracle/admin/dw/udump/dw_ora_1418.trc:
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-00600: internal error code, arguments: , , [], [], [], [], [], []
查看trace文件
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: , , [], [], [], [], [], []
Current SQL statement for this session:
select ctime, mtime, stime from obj$ where obj# = :1
继续往下看
Block header dump: 0x0040005e
Object id on Block? Y
seg/obj: 0x12 csc: 0x01.b64510dc itc: 2 flg: - typ: 1 - DATA
fsl: 0 fnx: 0x0 ver: 0x01
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x000b.00a.0000266b 0x0540fc1e.8295.0a C--- 0 scn 0x0001.b64510be
0x02 0x000b.014.000026bb 0x0540fc1e.8295.0b --U- 1 fsc 0x0000.b64510dd
data_block_dump,data header at 0x97fb805c
===============
tsiz: 0x7fa0
hsiz: 0x346
pbl: 0x97fb805c
bdba: 0x0040005e
76543210
flag=--------
ntab=1
nrow=410
frre=-1
fsbo=0x346
fseo=0xac0
avsp=0xc6c
tosp=0xc6c
0xeti nrow=410 offs=0
0x12ri offs=0x7f5f
0x14ri offs=0x7f17
事务未提交
Block header dump: 0x0040009e
Object id on Block? Y
seg/obj: 0x38 csc: 0x00.6b itc: 1 flg: O typ: 1 - DATA
fsl: 0 fnx: 0x0 ver: 0x01
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0000.022.00000002 0x00400014.0000.54 --U- 57 fsc 0x0000.000000c9
data_block_dump,data header at 0x97fa0044
===============
tsiz: 0x7fb8
hsiz: 0x84
pbl: 0x97fa0044
bdba: 0x0040009e
76543210
flag=--------
ntab=1
nrow=57
frre=-1
fsbo=0x84
fseo=0x3bef
avsp=0x3b6b
tosp=0x3b6b
0xeti nrow=57 offs=0
0x12ri offs=0x7fa3
还有一处，57个lck。
使用BBED更改标记，一共58个，sum通过。
再重新启动，任然报ora-600 错误，查看trace文件
Block header dump: 0x0040005e
Object id on Block? Y
seg/obj: 0x12 csc: 0x01.b64510dc itc: 2 flg: - typ: 1 - DATA
fsl: 0 fnx: 0x0 ver: 0x01
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x000b.00a.0000266b 0x0540fc1e.8295.0a C--- 0 scn 0x0001.b64510be
0x02 0x000b.014.000026bb 0x0540fc1e.8295.0b C--- 0 scn 0x0000.b64510dd
data_block_dump,data header at 0x97fb805c
===============
tsiz: 0x7fa0
hsiz: 0x346
pbl: 0x97fb805c
bdba: 0x0040005e
76543210
flag=--------
ntab=1
nrow=410
frre=-1
fsbo=0x346
fseo=0xac0
avsp=0xc6c
tosp=0xc6c
0xeti nrow=410 offs=0
0x12ri offs=0x7f5f
0x14ri offs=0x7f17
0x16ri offs=0x7edb
Block header dump: 0x0040009e
Object id on Block? Y
seg/obj: 0x38 csc: 0x00.6b itc: 1 flg: O typ: 1 - DATA
fsl: 0 fnx: 0x0 ver: 0x01
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0000.022.00000002 0x00400014.0000.54 C--- 0 scn 0x0000.000000c9
data_block_dump,data header at 0x97fa0044
===============
tsiz: 0x7fb8
hsiz: 0x84
pbl: 0x97fa0044
bdba: 0x0040009e
76543210
flag=--------
ntab=1
nrow=57
frre=-1
fsbo=0x84
fseo=0x3bef
avsp=0x3b6b
tosp=0x3b6b
0xeti nrow=57 offs=0
0x12:pri offs=0x7fa3
标记已更改，却仍然无法启动，问题出在哪里？
还请诸位大神伸出援助之手，先谢谢了！
单单设置_corrupted_rollback_segments无法解决这个问题。
使用BBED手动提交事务后，数据块的状态显示已提交，但是仍然会报4000的错误，实在是一筹莫展啊。
Block header dump: 0x0040005e
Object id on Block? Y
seg/obj: 0x12 csc: 0x01.b64510dc itc: 2 flg: - typ: 1 - DATA
fsl: 0 fnx: 0x0 ver: 0x01
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x000b.00a.0000266b 0x0540fc1e.8295.0a C--- 0 scn 0x0001.b64510be
0x02 0x000b.014.000026bb 0x0540fc1e.8295.0b --U- 1 fsc 0x0000.b64510dd
ITL的scn确实比csc高，那么是需要用bbed更改块的csc吗？
页:
[1]