一开始出现过oracle initialization or shutdown in progress 这个错误,我重建了下控制文件,结果就变这样了进alert文档里看了下:
Wed Feb 17 09:43:06 2016
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
event = 10061 trace name context forever, level 10
shared_pool_size = 419430400
sga_max_size = 1376855500
large_pool_size = 134217728
java_pool_size = 33554432
control_files = D:\oracle\oradata\xhsdbt\CONTROL01.CTL
db_block_size = 8192
db_cache_size = 738197504
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 =
instance_name = xhsdbt
dispatchers = (PROTOCOL=TCP) (SERVICE=xhsdbtXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\xhsdbt\bdump
user_dump_dest = D:\oracle\admin\xhsdbt\udump
core_dump_dest = D:\oracle\admin\xhsdbt\cdump
sort_area_size = 524288
db_name = xhsdbt
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 314572800
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 Feb 17 09:43:09 2016
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Feb 17 09:43:10 2016
ALTER DATABASE MOUNT
Wed Feb 17 09:43:15 2016
Successful mount of redo thread 1, with mount id 2442197550.
Wed Feb 17 09:43:15 2016
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Wed Feb 17 09:43:15 2016
ALTER DATABASE OPEN
Wed Feb 17 09:43:16 2016
Beginning crash recovery of 1 threads
Wed Feb 17 09:43:16 2016
Started first pass scan
Wed Feb 17 09:43:16 2016
Completed first pass scan
55 redo blocks read, 5 data blocks need recovery
Wed Feb 17 09:43:16 2016
Started recovery at
Thread 1: logseq 467, block 3, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 1 Seq 467 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\XHSDBT\REDO01.LOG
Wed Feb 17 09:43:16 2016
Ended recovery at
Thread 1: logseq 467, block 58, scn 12.901919294
5 data blocks read, 5 data blocks written, 55 redo blocks read
Crash recovery completed successfully
Wed Feb 17 09:43:16 2016
LGWR: Primary database is in CLUSTER CONSISTENT mode
Wed Feb 17 09:43:16 2016
ARCH: Evaluating archive log 2 thread 1 sequence 465
ARCH: Beginning to archive log 2 thread 1 sequence 465
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORA92\RDBMS\ARC00465.001'
ARCH: Completed archiving log 2 thread 1 sequence 465
Wed Feb 17 09:43:16 2016
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 468
Thread 1 opened at log sequence 468
Current log# 2 seq# 468 mem# 0: D:\ORACLE\ORADATA\XHSDBT\REDO02.LOG
Successful open of redo thread 1.
Wed Feb 17 09:43:16 2016
SMON: enabling cache recovery
Wed Feb 17 09:43:16 2016
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 Feb 17 09:43:16 2016
SMON: enabling tx recovery
Wed Feb 17 09:43:19 2016
Database Characterset is ZHS16GBK
Wed Feb 17 09:43:20 2016
Errors in file d:\oracle\admin\xhsdbt\bdump\xhsdbt_smon_3980.trc:
ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []Wed Feb 17 09:43:21 2016
Errors in file d:\oracle\admin\xhsdbt\udump\xhsdbt_ora_4020.trc:
ORA-00600: 内部错误代码,参数: [4194], [107], [105], [], [], [], [], []Recovery of Online Redo Log: Thread 1 Group 2 Seq 468 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\XHSDBT\REDO02.LOG
Recovery of Online Redo Log: Thread 1 Group 2 Seq 468 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\XHSDBT\REDO02.LOG
Wed Feb 17 09:43:23 2016
Errors in file d:\oracle\admin\xhsdbt\udump\xhsdbt_ora_4020.trc:
ORA-00607: 当更改数据块时出现内部错误
ORA-00600: 内部错误代码,参数: [4194], [107], [105], [], [], [], [], []Error 607 happened during db open, shutting down database
USER: terminating instance due to error 607
Wed Feb 17 09:43:24 2016
Non-fatal internal error happenned while SMON was doing IOT PMO transient table cleanup.
SMON encountered 1 out of maximum 100 non-fatal internal errors.
Wed Feb 17 09:43:25 2016
Instance terminated by USER, pid = 4020
ORA-1092 signalled during: ALTER DATABASE OPEN...这是什么原因啊,谁帮忙看下,谢谢了
Wed Feb 17 09:43:06 2016
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
event = 10061 trace name context forever, level 10
shared_pool_size = 419430400
sga_max_size = 1376855500
large_pool_size = 134217728
java_pool_size = 33554432
control_files = D:\oracle\oradata\xhsdbt\CONTROL01.CTL
db_block_size = 8192
db_cache_size = 738197504
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 =
instance_name = xhsdbt
dispatchers = (PROTOCOL=TCP) (SERVICE=xhsdbtXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\xhsdbt\bdump
user_dump_dest = D:\oracle\admin\xhsdbt\udump
core_dump_dest = D:\oracle\admin\xhsdbt\cdump
sort_area_size = 524288
db_name = xhsdbt
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 314572800
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 Feb 17 09:43:09 2016
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Feb 17 09:43:10 2016
ALTER DATABASE MOUNT
Wed Feb 17 09:43:15 2016
Successful mount of redo thread 1, with mount id 2442197550.
Wed Feb 17 09:43:15 2016
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Wed Feb 17 09:43:15 2016
ALTER DATABASE OPEN
Wed Feb 17 09:43:16 2016
Beginning crash recovery of 1 threads
Wed Feb 17 09:43:16 2016
Started first pass scan
Wed Feb 17 09:43:16 2016
Completed first pass scan
55 redo blocks read, 5 data blocks need recovery
Wed Feb 17 09:43:16 2016
Started recovery at
Thread 1: logseq 467, block 3, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 1 Seq 467 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\XHSDBT\REDO01.LOG
Wed Feb 17 09:43:16 2016
Ended recovery at
Thread 1: logseq 467, block 58, scn 12.901919294
5 data blocks read, 5 data blocks written, 55 redo blocks read
Crash recovery completed successfully
Wed Feb 17 09:43:16 2016
LGWR: Primary database is in CLUSTER CONSISTENT mode
Wed Feb 17 09:43:16 2016
ARCH: Evaluating archive log 2 thread 1 sequence 465
ARCH: Beginning to archive log 2 thread 1 sequence 465
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORA92\RDBMS\ARC00465.001'
ARCH: Completed archiving log 2 thread 1 sequence 465
Wed Feb 17 09:43:16 2016
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 468
Thread 1 opened at log sequence 468
Current log# 2 seq# 468 mem# 0: D:\ORACLE\ORADATA\XHSDBT\REDO02.LOG
Successful open of redo thread 1.
Wed Feb 17 09:43:16 2016
SMON: enabling cache recovery
Wed Feb 17 09:43:16 2016
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 Feb 17 09:43:16 2016
SMON: enabling tx recovery
Wed Feb 17 09:43:19 2016
Database Characterset is ZHS16GBK
Wed Feb 17 09:43:20 2016
Errors in file d:\oracle\admin\xhsdbt\bdump\xhsdbt_smon_3980.trc:
ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []Wed Feb 17 09:43:21 2016
Errors in file d:\oracle\admin\xhsdbt\udump\xhsdbt_ora_4020.trc:
ORA-00600: 内部错误代码,参数: [4194], [107], [105], [], [], [], [], []Recovery of Online Redo Log: Thread 1 Group 2 Seq 468 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\XHSDBT\REDO02.LOG
Recovery of Online Redo Log: Thread 1 Group 2 Seq 468 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\XHSDBT\REDO02.LOG
Wed Feb 17 09:43:23 2016
Errors in file d:\oracle\admin\xhsdbt\udump\xhsdbt_ora_4020.trc:
ORA-00607: 当更改数据块时出现内部错误
ORA-00600: 内部错误代码,参数: [4194], [107], [105], [], [], [], [], []Error 607 happened during db open, shutting down database
USER: terminating instance due to error 607
Wed Feb 17 09:43:24 2016
Non-fatal internal error happenned while SMON was doing IOT PMO transient table cleanup.
SMON encountered 1 out of maximum 100 non-fatal internal errors.
Wed Feb 17 09:43:25 2016
Instance terminated by USER, pid = 4020
ORA-1092 signalled during: ALTER DATABASE OPEN...这是什么原因啊,谁帮忙看下,谢谢了
解决方案 »
- Oracle 10g : ORA-12514:listener does not currently know of service requested in connect descriptor
- loadjava
- 怎么在linux操作系统中重启远程oracle服务器的监听器?
- oracle两记录相减问题
- 如何用Java写一个向Oracle中的数据表插入自动生成测试数据的类?
- 请问:这个SQL错在哪里???
- 字符集问题,oracle8.0---->oralce8i
- 急!登录SQL*PLUS时错误 ORA-12203:TNS:无法处理服务名???
- 关于定期索引重建和表的重新组织,三点疑问?
- 我要学乙,Oracle8的客户端可以联到Oracl7的服务器。不会高分?
- 关于分区表的问题
- 如何备份oracle数据库
VERSIONS:
versions 6.0 to 12.1 DESCRIPTION: A mismatch has been detected between Redo records and rollback (Undo)
records. We are validating the Undo record number relating to the change being
applied against the maximum undo record number recorded in the undo block. This error is reported when the validation fails.ARGUMENTS:
Arg [a] Maximum Undo record number in Undo block
Arg [b] Undo record number from Redo blockFUNCTIONALITY:
Kernel Transaction Undo called from Cache layer
IMPACT:
PROCESS FAILURE
POSSIBLE ROLLBACK SEGMENT CORRUPTIONSUGGESTIONS: This error may indicate a rollback segment corruption. This may require a recovery from a database backup depending on
the situation. If the Known Issues section below does not help in terms of identifying
a solution, please submit the trace files and alert.log to Oracle
Support Services for further analysis.
http://www.xifenfei.com/2012/07/%E6%95%B0%E6%8D%AE%E5%BA%93%E6%8A%A5ora-00607ora-006004194%E9%94%99%E8%AF%AF.html
http://www.xifenfei.com/2012/08/%E4%BD%BF%E7%94%A8bbed%E8%A7%A3%E5%86%B3ora-00607ora-006004194%E6%95%85%E9%9A%9C.html希望对你有帮助