리두로고 파일을 졸린가운데 "REDOLOG4.ORA" 이렇게 생성을하고
말았습니다.
생성시 이상없다가 저녁 때 쯤 아래와 같은 메시지와함께
20시 04분에 서비스가 다운되었습니다.
로고 파일 생성 잘못인가여?
18시 42분엔 이상없다가...
20시에 이상이 생긴건데...
원인파악이 되지않고 있습니다.
고수님들의 조언 부탁드립니다.
Tue Sep 06 18:42:28 2005
Thread 1 advanced to log sequence 39
Current log# 4 seq# 39 mem# 0: D:\ORA_REDOLOG\REDOLOG4.ORA
Current log# 4 seq# 39 mem# 1:
D:\ORA_REDOLOG\REDOLOG4_1.LOG
Dump file c:\oracle\admin\btmss2\bdump\alert_btmss2.log
Tue Sep 06 20:04:42 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
Tue Sep 06 20:04:42 2005
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 =
C:\oracle\oradata\BTMSS2\control01.ctl,
C:\oracle\oradata\BTMSS2\control02.ctl,
C:\oracle\oradata\BTMSS2\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 =
instance_name = BTMSS2
dispatchers = (PROTOCOL=TCP)
(SERVICE=BTMSS2XDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = C:\oracle\admin\BTMSS2\bdump
user_dump_dest = C:\oracle\admin\BTMSS2\udump
core_dump_dest = C:\oracle\admin\BTMSS2\cdump
sort_area_size = 524288
db_name = BTMSS2
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
Tue Sep 06 20:04:45 2005
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address
'(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Sep 06 20:04:46 2005
alter database mount exclusive
Tue Sep 06 20:04:50 2005
Successful mount of redo thread 1, with mount id 31955422.
Tue Sep 06 20:04:50 2005
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Sep 06 20:04:50 2005
alter database open
Tue Sep 06 20:04:50 2005
Beginning crash recovery of 1 threads
Tue Sep 06 20:04:51 2005
Started first pass scan
Tue Sep 06 20:04:51 2005
Completed first pass scan
8020 redo blocks read, 879 data blocks need recovery
Tue Sep 06 20:04:51 2005
Started recovery at
Thread 1: logseq 39, block 36536, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 4 Seq 39 Reading mem
0
Mem# 0 errs 0: D:\ORA_REDOLOG\REDOLOG4.ORA
Mem# 1 errs 0: D:\ORA_REDOLOG\REDOLOG4_1.LOG
Tue Sep 06 20:04:53 2005
Ended recovery at
Thread 1: logseq 39, block 44556, scn 0.422686592
879 data blocks read, 504 data blocks written, 8020 redo blocks
read
Crash recovery completed successfully
Tue Sep 06 20:04:54 2005
Errors in file
c:\oracle\admin\btmss2\bdump\btmss2_lgwr_948.trc:
ORA-00313: open failed for members of log group 2 of thread 1
Tue Sep 06 20:04:54 2005
Thread 1 advanced to log sequence 40
Thread 1 opened at log sequence 40
Current log# 2 seq# 40 mem# 0:
C:\ORACLE\ORADATA\BTMSS2\REDO02.LOG
Current log# 2 seq# 40 mem# 1:
D:\ORA_REDOLOG\REDOLOG2_1.LOG
Successful open of redo thread 1.
Tue Sep 06 20:04:54 2005
SMON: enabling cache recovery
Tue Sep 06 20:04:55 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.
Tue Sep 06 20:04:55 2005
SMON: enabling tx recovery
Tue Sep 06 20:04:55 2005
Database Characterset is KO16MSWIN949
replication_dependency_tracking turned off (no async multimaster
replication found)
Completed: alter database open
|