在数据库的告警日志中提示如下内容
smon在扫描undo的时候报错了!
Doing block recovery for file 2 block 51
Resuming block recovery (PMON) for file 2 block 51
Block recovery from logseq 9, block 32 to scn 1103447071391
....
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (3) of rollback segment (8))
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [21], [23], [], [], [], [], []
查询metalink,ORA-01595和ORA-01594经常在Oracle9i中一起报出来,是个bug,可以通过升级到10g来修复!
此时,说明某个回滚段有问题
解决思路:重建回滚段即可
SQL> startup mount;
ORACLE instance started.
Total System Global Area 276824064 bytes
Fixed Size 2095640 bytes
Variable Size 100664808 bytes
Database Buffers 167772160 bytes
Redo Buffers 629145
smon在扫描undo的时候报错了!
Doing block recovery for file 2 block 51
Resuming block recovery (PMON) for file 2 block 51
Block recovery from logseq 9, block 32 to scn 1103447071391
....
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (3) of rollback segment (8))
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [21], [23], [], [], [], [], []
查询metalink,ORA-01595和ORA-01594经常在Oracle9i中一起报出来,是个bug,可以通过升级到10g来修复!
此时,说明某个回滚段有问题
解决思路:重建回滚段即可
SQL> startup mount;
ORACLE instance started.
Total System Global Area 276824064 bytes
Fixed Size 2095640 bytes
Variable Size 100664808 bytes
Database Buffers 167772160 bytes
Redo Buffers 629145