最初由 hiyangyong 发布
[B]环境如下:
windows+oracle9.2.0.1.0
Z盘空间剩余300G
操作系统访问归档日志所在目录和文件正常
用oracle enterprise manager console连上实例,总是提示ora-01033提示,我查过代码,显示如下:
ORA-01033
ORA-01033ORACLE startup or shutdown in progress
Cause:An attempt was made to log on while ORACLE is being started up or shut down.
请教两个问题:
1、能不能改变归档日志的路径,会不会是硬盘某块出了问题,ORACLE读写不了,改变路径,创建新的归档?
2、能不能切换到不归档模式,然后启动,再切换会归档模式?
正在冷备份,就怕搞砸了,不好交代。。。 :
c:\oracle\admin\nhnotary\bdump\alter_nhnotary.log 报错内容如下:
Sat Oct 15 03:05:48 2005
ARC0: Evaluating archive log 3 thread 1 sequence 169
ARC0: Beginning to archive log 3 thread 1 sequence 169
Creating archive destination LOG_ARCHIVE_DEST_1: 'Z:\ORACLE\ORADATA\NHNOTARY\ARCHIVE\T001S00169.ARC'
ARC0: Error 19504 Creating archive log file to 'Z:\ORACLE\ORADATA\NHNOTARY\ARCHIVE\T001S00169.ARC'
Sat Oct 15 03:05:48 2005
Errors in file c:\oracle\admin\nhnotary\bdump\nhnotary_arc0_3544.trc:
ORA-19504: failed to create file "Z:\ORACLE\ORADATA\NHNOTARY\ARCHIVE\T001S00169.ARC"
ORA-19504: failed to create file "Z:\ORACLE\ORADATA\NHNOTARY\ARCHIVE\T001S00169.ARC"
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: 无法打开文件
O/S-Error: (OS 1392) 文件或目录损坏且无法读取。
ARC0: Archiving not possible: error count exceeded
ARC0: Failed to archive log 3 thread 1 sequence 169
Sat Oct 15 03:05:48 2005
Errors in file c:\oracle\admin\nhnotary\bdump\nhnotary_arc0_3544.trc:
ORA-16038: log 3 sequence# 169 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 3 thread 1: 'Z:\ORACLE\ORADATA\NHNOTARY\REDO03.LOG'
Sat Oct 15 03:06:50 2005
ARC0: Evaluating archive log 3 thread 1 sequence 169
ARC0: Beginning to archive log 3 thread 1 sequence 169
Creating archive destination LOG_ARCHIVE_DEST_1: 'Z:\ORACLE\ORADATA\NHNOTARY\ARCHIVE\T001S00169.ARC'
ARC0: Error 19504 Creating archive log file to 'Z:\ORACLE\ORADATA\NHNOTARY\ARCHIVE\T001S00169.ARC'
Sat Oct 15 03:06:50 2005
Errors in file c:\oracle\admin\nhnotary\bdump\nhnotary_arc0_3544.trc:
ORA-19504: failed to create file "Z:\ORACLE\ORADATA\NHNOTARY\ARCHIVE\T001S00169.ARC"
ORA-19504: failed to create file "Z:\ORACLE\ORADATA\NHNOTARY\ARCHIVE\T001S00169.ARC"
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: 无法打开文件
O/S-Error: (OS 1392) 文件或目录损坏且无法读取。
ARC0: Archiving not possible: error count exceeded
ARC0: Failed to archive log 3 thread 1 sequence 169
Sat Oct 15 03:06:50 2005
Errors in file c:\oracle\admin\nhnotary\bdump\nhnotary_arc0_3544.trc:
ORA-16038: log 3 sequence# 169 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 3 thread 1: 'Z:\ORACLE\ORADATA\NHNOTARY\REDO03.LOG'
Dump file c:\oracle\admin\nhnotary\bdump\alert_nhnotary.log
Sat Oct 15 03:10:08 2005
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Sat Oct 15 03:10:08 2005
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
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 = 109051904
large_pool_size = 8388608
java_pool_size = 0
control_files = Z:\oracle\oradata\nhnotary\control01.ctl, Z:\oracle\oradata\nhnotary\control02.ctl, Z:\oracle\oradata\nhnotary\control03.ctl
db_block_size = 8192
db_cache_size = 318767104
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest = Z:\oracle\oradata\nhnotary\archive
log_archive_format = T%TS%S.ARC
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 = nhnotary
hash_join_enabled = TRUE
background_dump_dest = C:\oracle\admin\nhnotary\bdump
user_dump_dest = C:\oracle\admin\nhnotary\udump
core_dump_dest = C:\oracle\admin\nhnotary\cdump
sort_area_size = 524288
db_name = nhnotary
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 283115520
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
Sat Oct 15 03:10:11 2005
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=8
ARC0: Archival started
ARC1 started with pid=9
Sat Oct 15 03:10:12 2005
ARCH: STARTING ARCH PROCESSES COMPLETE
Sat Oct 15 03:10:12 2005
ARC0: Thread not mounted
Sat Oct 15 03:10:12 2005
alter database mount exclusive
Sat Oct 15 03:10:13 2005
ARC1: Archival started
Sat Oct 15 03:10:13 2005
ARC1: Thread not mounted
Sat Oct 15 03:10:17 2005
Successful mount of redo thread 1, with mount id 3433266389.
Sat Oct 15 03:10:17 2005
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Sat Oct 15 03:10:17 2005
alter database open
ORA-1113 signalled during: alter database open...
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 1 [/B]