在线等请各位大侠帮解决一下谢谢.....下面是alter.logWed Sep 30 16:56:34 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\oracle\oradata\yygl\CONTROL01.CTL, D:\oracle\oradata\yygl\CONTROL02.CTL, D:\oracle\oradata\yygl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain = net
instance_name = yygl
dispatchers = (PROTOCOL=TCP) (SERVICE=yyglXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\yygl\bdump
user_dump_dest = D:\oracle\admin\yygl\udump
core_dump_dest = D:\oracle\admin\yygl\cdump
sort_area_size = 524288
db_name = yygl
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Wed Sep 30 16:56:37 2009
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Sep 30 16:56:37 2009
ALTER DATABASE MOUNT
Wed Sep 30 16:56:41 2009
Successful mount of redo thread 1, with mount id 3024299845.
Wed Sep 30 16:56:41 2009
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Wed Sep 30 16:56:41 2009
ALTER DATABASE OPEN
Wed Sep 30 16:56:42 2009
Beginning crash recovery of 1 threads
Wed Sep 30 16:56:42 2009
Started first pass scan
Wed Sep 30 16:56:42 2009
Completed first pass scan
63 redo blocks read, 5 data blocks need recovery
Wed Sep 30 16:56:42 2009
Started recovery at
Thread 1: logseq 7, block 3, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 2 Seq 7 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\YYGL\REDO02.LOG
Wed Sep 30 16:56:42 2009
Ended recovery at
Thread 1: logseq 7, block 66, scn 0.229624974
5 data blocks read, 5 data blocks written, 63 redo blocks read
Crash recovery completed successfully
Wed Sep 30 16:56:42 2009
Thread 1 advanced to log sequence 8
Thread 1 opened at log sequence 8
Current log# 1 seq# 8 mem# 0: D:\ORACLE\ORADATA\YYGL\REDO01.LOG
Successful open of redo thread 1.
Wed Sep 30 16:56:42 2009
SMON: enabling cache recovery
Wed Sep 30 16:56:43 2009
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Wed Sep 30 16:56:43 2009
SMON: enabling tx recovery
Wed Sep 30 16:56:43 2009
Database Characterset is ZHS16GBK
Wed Sep 30 16:56:44 2009
Errors in file d:\oracle\admin\yygl\bdump\yygl_smon_1720.trc:
ORA-00600: internal error code, arguments: [4193], [5072], [5133], [], [], [], [], []Wed Sep 30 16:56:44 2009
Errors in file d:\oracle\admin\yygl\udump\yygl_ora_872.trc:
ORA-00600: 内部错误代码,参数: [4194], [93], [80], [], [], [], [], []Recovery of Online Redo Log: Thread 1 Group 1 Seq 8 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\YYGL\REDO01.LOG
Wed Sep 30 16:56:45 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 8 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\YYGL\REDO01.LOG
Wed Sep 30 16:56:46 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 8 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\YYGL\REDO01.LOG
Wed Sep 30 16:56:46 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 8 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\YYGL\REDO01.LOG
Wed Sep 30 16:56:47 2009
Errors in file d:\oracle\admin\yygl\udump\yygl_ora_872.trc:
ORA-00607: 当更改数据块时出现内部错误
ORA-00600: 内部错误代码,参数: [4194], [93], [80], [], [], [], [], []Wed Sep 30 16:56:47 2009
Error 607 happened during db open, shutting down database
USER: terminating instance due to error 607
Instance terminated by USER, pid = 872
ORA-1092 signalled during: ALTER DATABASE OPEN...
Wed Sep 30 17:27:04 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\oracle\oradata\yygl\CONTROL01.CTL, D:\oracle\oradata\yygl\CONTROL02.CTL, D:\oracle\oradata\yygl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain = net
instance_name = yygl
dispatchers = (PROTOCOL=TCP) (SERVICE=yyglXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\yygl\bdump
user_dump_dest = D:\oracle\admin\yygl\udump
core_dump_dest = D:\oracle\admin\yygl\cdump
sort_area_size = 524288
db_name = yygl
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Wed Sep 30 17:27:07 2009
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Sep 30 17:27:07 2009
ALTER DATABASE MOUNT
Wed Sep 30 17:27:11 2009
Successful mount of redo thread 1, with mount id 3024286571.
Wed Sep 30 17:27:11 2009
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\oracle\oradata\yygl\CONTROL01.CTL, D:\oracle\oradata\yygl\CONTROL02.CTL, D:\oracle\oradata\yygl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain = net
instance_name = yygl
dispatchers = (PROTOCOL=TCP) (SERVICE=yyglXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\yygl\bdump
user_dump_dest = D:\oracle\admin\yygl\udump
core_dump_dest = D:\oracle\admin\yygl\cdump
sort_area_size = 524288
db_name = yygl
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Wed Sep 30 16:56:37 2009
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Sep 30 16:56:37 2009
ALTER DATABASE MOUNT
Wed Sep 30 16:56:41 2009
Successful mount of redo thread 1, with mount id 3024299845.
Wed Sep 30 16:56:41 2009
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Wed Sep 30 16:56:41 2009
ALTER DATABASE OPEN
Wed Sep 30 16:56:42 2009
Beginning crash recovery of 1 threads
Wed Sep 30 16:56:42 2009
Started first pass scan
Wed Sep 30 16:56:42 2009
Completed first pass scan
63 redo blocks read, 5 data blocks need recovery
Wed Sep 30 16:56:42 2009
Started recovery at
Thread 1: logseq 7, block 3, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 2 Seq 7 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\YYGL\REDO02.LOG
Wed Sep 30 16:56:42 2009
Ended recovery at
Thread 1: logseq 7, block 66, scn 0.229624974
5 data blocks read, 5 data blocks written, 63 redo blocks read
Crash recovery completed successfully
Wed Sep 30 16:56:42 2009
Thread 1 advanced to log sequence 8
Thread 1 opened at log sequence 8
Current log# 1 seq# 8 mem# 0: D:\ORACLE\ORADATA\YYGL\REDO01.LOG
Successful open of redo thread 1.
Wed Sep 30 16:56:42 2009
SMON: enabling cache recovery
Wed Sep 30 16:56:43 2009
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Wed Sep 30 16:56:43 2009
SMON: enabling tx recovery
Wed Sep 30 16:56:43 2009
Database Characterset is ZHS16GBK
Wed Sep 30 16:56:44 2009
Errors in file d:\oracle\admin\yygl\bdump\yygl_smon_1720.trc:
ORA-00600: internal error code, arguments: [4193], [5072], [5133], [], [], [], [], []Wed Sep 30 16:56:44 2009
Errors in file d:\oracle\admin\yygl\udump\yygl_ora_872.trc:
ORA-00600: 内部错误代码,参数: [4194], [93], [80], [], [], [], [], []Recovery of Online Redo Log: Thread 1 Group 1 Seq 8 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\YYGL\REDO01.LOG
Wed Sep 30 16:56:45 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 8 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\YYGL\REDO01.LOG
Wed Sep 30 16:56:46 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 8 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\YYGL\REDO01.LOG
Wed Sep 30 16:56:46 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 8 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\YYGL\REDO01.LOG
Wed Sep 30 16:56:47 2009
Errors in file d:\oracle\admin\yygl\udump\yygl_ora_872.trc:
ORA-00607: 当更改数据块时出现内部错误
ORA-00600: 内部错误代码,参数: [4194], [93], [80], [], [], [], [], []Wed Sep 30 16:56:47 2009
Error 607 happened during db open, shutting down database
USER: terminating instance due to error 607
Instance terminated by USER, pid = 872
ORA-1092 signalled during: ALTER DATABASE OPEN...
Wed Sep 30 17:27:04 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\oracle\oradata\yygl\CONTROL01.CTL, D:\oracle\oradata\yygl\CONTROL02.CTL, D:\oracle\oradata\yygl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain = net
instance_name = yygl
dispatchers = (PROTOCOL=TCP) (SERVICE=yyglXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\yygl\bdump
user_dump_dest = D:\oracle\admin\yygl\udump
core_dump_dest = D:\oracle\admin\yygl\cdump
sort_area_size = 524288
db_name = yygl
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Wed Sep 30 17:27:07 2009
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Sep 30 17:27:07 2009
ALTER DATABASE MOUNT
Wed Sep 30 17:27:11 2009
Successful mount of redo thread 1, with mount id 3024286571.
Wed Sep 30 17:27:11 2009
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货