Tue Jan 31 10:11:23 2012 db_recovery_file_dest_size of 2048 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. Tue Jan 31 10:11:24 2012 Doing block recovery for file 2 block 2119 Block recovery from logseq 908, block 73 to scn 45534293 Tue Jan 31 10:11:24 2012 Recovery of Online Redo Log: Thread 1 Group 1 Seq 908 Reading mem 0 Mem# 0 errs 0: D:\ORADATA\OWLDATA\REDO01.LOG Block recovery stopped at EOT rba 908.78.16 Block recovery completed at rba 908.78.16, scn 0.45534288 Doing block recovery for file 2 block 73 Block recovery from logseq 908, block 73 to scn 45534283 Tue Jan 31 10:11:24 2012 Recovery of Online Redo Log: Thread 1 Group 1 Seq 908 Reading mem 0 Mem# 0 errs 0: D:\ORADATA\OWLDATA\REDO01.LOG Block recovery completed at rba 908.74.16, scn 0.45534284 Tue Jan 31 10:11:24 2012 Errors in file d:\admin\owldata\bdump\owldata_smon_3352.trc: ORA-01595: error freeing extent (2) of rollback segment (5)) ORA-00607: Internal error occurred while making a change to a data block ORA-00600: internal error code, arguments: [4194], [2], [4], [], [], [], [], []Tue Jan 31 10:11:24 2012 Completed: alter database open Tue Jan 31 10:11:31 2012 Errors in file d:\admin\owldata\bdump\owldata_j000_1468.trc: ORA-00600: 内部错误代码, 参数: [4194], [10], [10], [], [], [], [], []DEBUG: Replaying xcb 0x333a16f4, pmd 0x32844c24 for failed op 8 Doing block recovery for file 2 block 2048 No block recovery was needed Tue Jan 31 10:11:32 2012 Errors in file d:\admin\owldata\bdump\owldata_j000_1468.trc: ORA-00600: 内部错误代码, 参数: [4194], [10], [10], [], [], [], [], [] ORA-00600: 内部错误代码, 参数: [4194], [10], [10], [], [], [], [], [];不知道什么原因,数据库连接不上。在系统服务里重新启动服务,一会儿就又挂了。
ORA-01595: error freeing extent (2) of rollback segment (5)) 回滚段 无法扩展查看Undo表空间所在的磁盘是不是没有空间,重建undo表空间,切换默认undo_tablespace 然后drop掉原有的undo表空间,大概是这样--创建undo 表空间 create undo tablepsace undotbs2 datafile '..' size 10m; --修改默认undo表空间 alter system set undO_tablepspace=undotbs2 scope=both; --删除原有表空间 drop tablespace undotbs1 including contents and datafiles;
db_recovery_file_dest_size of 2048 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.
Tue Jan 31 10:11:24 2012
Doing block recovery for file 2 block 2119
Block recovery from logseq 908, block 73 to scn 45534293
Tue Jan 31 10:11:24 2012
Recovery of Online Redo Log: Thread 1 Group 1 Seq 908 Reading mem 0
Mem# 0 errs 0: D:\ORADATA\OWLDATA\REDO01.LOG
Block recovery stopped at EOT rba 908.78.16
Block recovery completed at rba 908.78.16, scn 0.45534288
Doing block recovery for file 2 block 73
Block recovery from logseq 908, block 73 to scn 45534283
Tue Jan 31 10:11:24 2012
Recovery of Online Redo Log: Thread 1 Group 1 Seq 908 Reading mem 0
Mem# 0 errs 0: D:\ORADATA\OWLDATA\REDO01.LOG
Block recovery completed at rba 908.74.16, scn 0.45534284
Tue Jan 31 10:11:24 2012
Errors in file d:\admin\owldata\bdump\owldata_smon_3352.trc:
ORA-01595: error freeing extent (2) of rollback segment (5))
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [2], [4], [], [], [], [], []Tue Jan 31 10:11:24 2012
Completed: alter database open
Tue Jan 31 10:11:31 2012
Errors in file d:\admin\owldata\bdump\owldata_j000_1468.trc:
ORA-00600: 内部错误代码, 参数: [4194], [10], [10], [], [], [], [], []DEBUG: Replaying xcb 0x333a16f4, pmd 0x32844c24 for failed op 8
Doing block recovery for file 2 block 2048
No block recovery was needed
Tue Jan 31 10:11:32 2012
Errors in file d:\admin\owldata\bdump\owldata_j000_1468.trc:
ORA-00600: 内部错误代码, 参数: [4194], [10], [10], [], [], [], [], []
ORA-00600: 内部错误代码, 参数: [4194], [10], [10], [], [], [], [], [];不知道什么原因,数据库连接不上。在系统服务里重新启动服务,一会儿就又挂了。
回滚段 无法扩展查看Undo表空间所在的磁盘是不是没有空间,重建undo表空间,切换默认undo_tablespace
然后drop掉原有的undo表空间,大概是这样--创建undo 表空间
create undo tablepsace undotbs2 datafile '..' size 10m;
--修改默认undo表空间
alter system set undO_tablepspace=undotbs2 scope=both;
--删除原有表空间
drop tablespace undotbs1 including contents and datafiles;