我发现oracle数据库在(10th Nov 2005)23:15时无法使用在这之前一天有提示无法自动归档,后删除了归档日志就正常了。可(10th Nov 2005)23:15就发现数据库崩溃了,程序报错:java.sql.SQLException: ora-01033:ORACLE initialization or shutdown in progress到底是什么原因造成了数据库崩溃呢?请高手指教alert*log文件的后半部分如下:ARC1: Archiving not possible: error count exceeded
ARC1: Failed to archive log 1 thread 1 sequence 913
Wed Nov 09 23:14:05 2005
Errors in file e:\oracle\admin\prfch\bdump\prfch_arc1_4132.trc:
ORA-16038: log 1 sequence# 913 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 1 thread 1: 'E:\ORACLE\ORADATA\PRFCH\REDO01.LOG'ARC1: Evaluating archive log 1 thread 1 sequence 913
ARC1: Beginning to archive log 1 thread 1 sequence 913
Creating archive destination LOG_ARCHIVE_DEST_1: 'E:\ORACLE\ORA92\RDBMS\ARC_LOG\ARC00913.001'
ARC1: Error 19504 Creating archive log file to 'E:\ORACLE\ORA92\RDBMS\ARC_LOG\ARC00913.001'
Wed Nov 09 23:14:06 2005
Errors in file e:\oracle\admin\prfch\bdump\prfch_arc1_4132.trc:
ORA-19504: failed to create file "E:\ORACLE\ORA92\RDBMS\ARC_LOG\ARC00913.001"
ORA-19504: failed to create file "E:\ORACLE\ORA92\RDBMS\ARC_LOG\ARC00913.001"
ORA-27044: unable to write the header block of file
OSD-04008: WriteFile() 失败, 无法写入文件
O/S-Error: (OS 112) 磁盘空间不足。ARC1: Archiving not possible: error count exceeded
Wed Nov 09 23:14:06 2005
LGWR: Detected ARCH process failure
LGWR: STARTING ARCH PROCESSES
Wed Nov 09 23:14:40 2005
Errors in file e:\oracle\admin\prfch\bdump\prfch_lgwr_4032.trc:
ORA-00445: background process "ARC0" did not start after 120 secondsLGWR: STARTING ARCH PROCESSES COMPLETE
Dump file e:\oracle\admin\prfch\bdump\alert_prfch.log
Thu Nov 10 08:08:35 2005
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Thu Nov 10 08:08:35 2005
Starting ORACLE instance (normal)
Thu Nov 10 08:08:36 2005
Running with 1 strand for Non-Enterprise Edition
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Running with 1 strand for Non-Enterprise Edition
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 = E:\oracle\oradata\PRFCH\CONTROL01.CTL, E:\oracle\oradata\PRFCH\CONTROL02.CTL, E:\oracle\oradata\PRFCH\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest = E:\oracle\ora92\rdbms\arc_log
db_file_multiblock_read_count= 16
fast_start_mttr_target = 0
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = PRFCH
dispatchers = (PROTOCOL=TCP) (SERVICE=PRFCHXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = E:\oracle\admin\PRFCH\bdump
user_dump_dest = E:\oracle\admin\PRFCH\udump
core_dump_dest = E:\oracle\admin\PRFCH\cdump
sort_area_size = 524288
db_name = PRFCH
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
Thu Nov 10 08:08:39 2005
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=12
ARC0: Archival started
ARC1 started with pid=13
Thu Nov 10 08:08:40 2005
ARCH: STARTING ARCH PROCESSES COMPLETE
Thu Nov 10 08:08:40 2005
Oracle Data Guard is not available in this edition of Oracle.
Thu Nov 10 08:08:40 2005
ARC0: Thread not mounted
Thu Nov 10 08:08:40 2005
alter database mount exclusive
Thu Nov 10 08:08:41 2005
ARC1: Archival started
Thu Nov 10 08:08:41 2005
ARC1: Thread not mounted
Thu Nov 10 08:08:45 2005
Successful mount of redo thread 1, with mount id 3970588041.
Thu Nov 10 08:08:45 2005
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Thu Nov 10 08:08:46 2005
alter database open
Thu Nov 10 08:08:46 2005
Beginning crash recovery of 1 threads
Thu Nov 10 08:08:46 2005
Started recovery at
Thread 1: logseq 915, block 204799, scn 0.129340845
Recovery of Online Redo Log: Thread 1 Group 3 Seq 915 Reading mem 0
Mem# 0 errs 0: E:\ORACLE\ORADATA\PRFCH\REDO03.LOG
Thu Nov 10 08:08:46 2005
Ended recovery at
Thread 1: logseq 915, block 204799, scn 0.129360846
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Thu Nov 10 08:08:46 2005
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thu Nov 10 08:08:47 2005
ARCH: Evaluating archive log 1 thread 1 sequence 913
ARCH: Beginning to archive log 1 thread 1 sequence 913
Creating archive destination LOG_ARCHIVE_DEST_1: 'E:\ORACLE\ORA92\RDBMS\ARC_LOG\ARC00913.001'
ARCH: Error 19504 Creating archive log file to 'E:\ORACLE\ORA92\RDBMS\ARC_LOG\ARC00913.001'
Thu Nov 10 08:08:47 2005
Errors in file e:\oracle\admin\prfch\udump\prfch_ora_2600.trc:
ORA-19504: ??????"E:\ORACLE\ORA92\RDBMS\ARC_LOG\ARC00913.001"
ORA-19504: ??????"E:\ORACLE\ORA92\RDBMS\ARC_LOG\ARC00913.001"
ORA-27044: ??????????
OSD-04008: WriteFile() 失败, 无法写入文件
O/S-Error: (OS 112) 磁盘空间不足。
ARC1: Failed to archive log 1 thread 1 sequence 913
Wed Nov 09 23:14:05 2005
Errors in file e:\oracle\admin\prfch\bdump\prfch_arc1_4132.trc:
ORA-16038: log 1 sequence# 913 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 1 thread 1: 'E:\ORACLE\ORADATA\PRFCH\REDO01.LOG'ARC1: Evaluating archive log 1 thread 1 sequence 913
ARC1: Beginning to archive log 1 thread 1 sequence 913
Creating archive destination LOG_ARCHIVE_DEST_1: 'E:\ORACLE\ORA92\RDBMS\ARC_LOG\ARC00913.001'
ARC1: Error 19504 Creating archive log file to 'E:\ORACLE\ORA92\RDBMS\ARC_LOG\ARC00913.001'
Wed Nov 09 23:14:06 2005
Errors in file e:\oracle\admin\prfch\bdump\prfch_arc1_4132.trc:
ORA-19504: failed to create file "E:\ORACLE\ORA92\RDBMS\ARC_LOG\ARC00913.001"
ORA-19504: failed to create file "E:\ORACLE\ORA92\RDBMS\ARC_LOG\ARC00913.001"
ORA-27044: unable to write the header block of file
OSD-04008: WriteFile() 失败, 无法写入文件
O/S-Error: (OS 112) 磁盘空间不足。ARC1: Archiving not possible: error count exceeded
Wed Nov 09 23:14:06 2005
LGWR: Detected ARCH process failure
LGWR: STARTING ARCH PROCESSES
Wed Nov 09 23:14:40 2005
Errors in file e:\oracle\admin\prfch\bdump\prfch_lgwr_4032.trc:
ORA-00445: background process "ARC0" did not start after 120 secondsLGWR: STARTING ARCH PROCESSES COMPLETE
Dump file e:\oracle\admin\prfch\bdump\alert_prfch.log
Thu Nov 10 08:08:35 2005
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Thu Nov 10 08:08:35 2005
Starting ORACLE instance (normal)
Thu Nov 10 08:08:36 2005
Running with 1 strand for Non-Enterprise Edition
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Running with 1 strand for Non-Enterprise Edition
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 = E:\oracle\oradata\PRFCH\CONTROL01.CTL, E:\oracle\oradata\PRFCH\CONTROL02.CTL, E:\oracle\oradata\PRFCH\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest = E:\oracle\ora92\rdbms\arc_log
db_file_multiblock_read_count= 16
fast_start_mttr_target = 0
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = PRFCH
dispatchers = (PROTOCOL=TCP) (SERVICE=PRFCHXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = E:\oracle\admin\PRFCH\bdump
user_dump_dest = E:\oracle\admin\PRFCH\udump
core_dump_dest = E:\oracle\admin\PRFCH\cdump
sort_area_size = 524288
db_name = PRFCH
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
Thu Nov 10 08:08:39 2005
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=12
ARC0: Archival started
ARC1 started with pid=13
Thu Nov 10 08:08:40 2005
ARCH: STARTING ARCH PROCESSES COMPLETE
Thu Nov 10 08:08:40 2005
Oracle Data Guard is not available in this edition of Oracle.
Thu Nov 10 08:08:40 2005
ARC0: Thread not mounted
Thu Nov 10 08:08:40 2005
alter database mount exclusive
Thu Nov 10 08:08:41 2005
ARC1: Archival started
Thu Nov 10 08:08:41 2005
ARC1: Thread not mounted
Thu Nov 10 08:08:45 2005
Successful mount of redo thread 1, with mount id 3970588041.
Thu Nov 10 08:08:45 2005
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Thu Nov 10 08:08:46 2005
alter database open
Thu Nov 10 08:08:46 2005
Beginning crash recovery of 1 threads
Thu Nov 10 08:08:46 2005
Started recovery at
Thread 1: logseq 915, block 204799, scn 0.129340845
Recovery of Online Redo Log: Thread 1 Group 3 Seq 915 Reading mem 0
Mem# 0 errs 0: E:\ORACLE\ORADATA\PRFCH\REDO03.LOG
Thu Nov 10 08:08:46 2005
Ended recovery at
Thread 1: logseq 915, block 204799, scn 0.129360846
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Thu Nov 10 08:08:46 2005
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thu Nov 10 08:08:47 2005
ARCH: Evaluating archive log 1 thread 1 sequence 913
ARCH: Beginning to archive log 1 thread 1 sequence 913
Creating archive destination LOG_ARCHIVE_DEST_1: 'E:\ORACLE\ORA92\RDBMS\ARC_LOG\ARC00913.001'
ARCH: Error 19504 Creating archive log file to 'E:\ORACLE\ORA92\RDBMS\ARC_LOG\ARC00913.001'
Thu Nov 10 08:08:47 2005
Errors in file e:\oracle\admin\prfch\udump\prfch_ora_2600.trc:
ORA-19504: ??????"E:\ORACLE\ORA92\RDBMS\ARC_LOG\ARC00913.001"
ORA-19504: ??????"E:\ORACLE\ORA92\RDBMS\ARC_LOG\ARC00913.001"
ORA-27044: ??????????
OSD-04008: WriteFile() 失败, 无法写入文件
O/S-Error: (OS 112) 磁盘空间不足。
解决方案 »
- 如何在10g实现11g的DBMS_SQL包中的函数to_refcursor?
- 一个存储过程执行速度的问题............
- 自连接 别名的问题
- 求一个Oracle 登陆脚本
- 如何在oracle9i中查询到用户提交的查询语句
- 急oracle倒入遇到的问题:(在线等!~~
- 请问这个sql怎么写
- 求Pro*C/C++™ Precompiler Programmer's Guide 9i
- 6000元的一个statement,过来关心一下吧!
- plsql实用小技巧——固定用户
- JAVA调用存储过程,传入一个数组,传出一个数组怎么实现?
- 就50分了!全给了!由oracle访问sql的问题!
ARCH: Archiving not possible: error count exceeded
ARCH: Failed to archive log 1 thread 1 sequence 913
ORA-16038 signalled during: alter database open...
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water = 3
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Thu Nov 10 10:30:04 2005
alter database close normal
ORA-1109 signalled during: alter database close normal...
Dump file e:\oracle\admin\prfch\bdump\alert_prfch.log
Thu Nov 10 10:55:03 2005
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Thu Nov 10 10:55:03 2005
Starting ORACLE instance (normal)
Thu Nov 10 10:55:03 2005
Running with 1 strand for Non-Enterprise Edition
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Running with 1 strand for Non-Enterprise Edition
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 = E:\oracle\oradata\PRFCH\CONTROL01.CTL, E:\oracle\oradata\PRFCH\CONTROL02.CTL, E:\oracle\oradata\PRFCH\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest = E:\oracle\ora92\rdbms\arc_log
db_file_multiblock_read_count= 16
fast_start_mttr_target = 0
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = PRFCH
dispatchers = (PROTOCOL=TCP) (SERVICE=PRFCHXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = E:\oracle\admin\PRFCH\bdump
user_dump_dest = E:\oracle\admin\PRFCH\udump
core_dump_dest = E:\oracle\admin\PRFCH\cdump
sort_area_size = 524288
db_name = PRFCH
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
Thu Nov 10 10:55:05 2005
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=12
ARC0: Archival started
ARC1 started with pid=13
Thu Nov 10 10:55:07 2005
ARCH: STARTING ARCH PROCESSES COMPLETE
Thu Nov 10 10:55:07 2005
Oracle Data Guard is not available in this edition of Oracle.
Thu Nov 10 10:55:07 2005
ARC0: Thread not mounted
Thu Nov 10 10:55:07 2005
alter database mount exclusive
Thu Nov 10 10:55:08 2005
ARC1: Archival started
Thu Nov 10 10:55:08 2005
ARC1: Thread not mounted
Thu Nov 10 10:55:13 2005
Successful mount of redo thread 1, with mount id 3970565004.
Thu Nov 10 10:55:13 2005
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Thu Nov 10 10:55:13 2005
alter database open
Thu Nov 10 10:55:15 2005
Beginning crash recovery of 1 threads
Thu Nov 10 10:55:15 2005
Started recovery at
Thread 1: logseq 915, block 204799, scn 0.129340845
Recovery of Online Redo Log: Thread 1 Group 3 Seq 915 Reading mem 0
Mem# 0 errs 0: E:\ORACLE\ORADATA\PRFCH\REDO03.LOG
Thu Nov 10 10:55:15 2005
Ended recovery at
Thread 1: logseq 915, block 204799, scn 0.129360846
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Thu Nov 10 10:55:16 2005
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thu Nov 10 10:55:17 2005
ARCH: Evaluating archive log 1 thread 1 sequence 913
ARCH: Beginning to archive log 1 thread 1 sequence 913
Creating archive destination LOG_ARCHIVE_DEST_1: 'E:\ORACLE\ORA92\RDBMS\ARC_LOG\ARC00913.001'
ARCH: Completed archiving log 1 thread 1 sequence 913
Thu Nov 10 10:55:27 2005
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 916
Thread 1 opened at log sequence 916
Current log# 1 seq# 916 mem# 0: E:\ORACLE\ORADATA\PRFCH\REDO01.LOG
Successful open of redo thread 1.
Thu Nov 10 10:55:28 2005
SMON: enabling cache recovery
Thu Nov 10 10:55:28 2005
ARC0: Evaluating archive log 2 thread 1 sequence 914
ARC0: Beginning to archive log 2 thread 1 sequence 914
Creating archive destination LOG_ARCHIVE_DEST_1: 'E:\ORACLE\ORA92\RDBMS\ARC_LOG\ARC00914.001'
Thu Nov 10 10:55:30 2005
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.
Thu Nov 10 10:55:30 2005
SMON: enabling tx recovery
Thu Nov 10 10:55:30 2005
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Thu Nov 10 10:55:40 2005
ARC0: Completed archiving log 2 thread 1 sequence 914
Thu Nov 10 10:55:40 2005
ARC1: Evaluating archive log 3 thread 1 sequence 915
ARC1: Beginning to archive log 3 thread 1 sequence 915
Creating archive destination LOG_ARCHIVE_DEST_1: 'E:\ORACLE\ORA92\RDBMS\ARC_LOG\ARC00915.001'
Thu Nov 10 10:55:40 2005
Completed: alter database open
Thu Nov 10 10:55:48 2005
ARC1: Completed archiving log 3 thread 1 sequence 915
recover database;
recover database until cancel;alter database open;看看是否可以打开数据库?