oracle 9.2.0.4+windows 2003 server
系统自动产生这些数据文件, 其状态都是recover状态.为什么会产生 这些数据文件呢?
Thread 1 opened at log sequence 1
Current log# 5 seq# 1 mem# 0: F:\ORADATA\REDO10.LOG
Successful open of redo thread 1.
Sat Dec 13 17:58:45 2008
SMON: enabling cache recovery
Sat Dec 13 17:58:46 2008
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.
Dictionary check beginning
Tablespace 'TEMP' #2 found in data dictionary,
but not in the controlfile. Adding to controlfile.
File #35 found in data dictionary but not in controlfile.
Creating OFFLINE file 'MISSING00035' in the controlfile.
This file can no longer be recovered so it must be dropped.
File #36 found in data dictionary but not in controlfile.
Creating OFFLINE file 'MISSING00036' in the controlfile.
This file can no longer be recovered so it must be dropped.
File #39 found in data dictionary but not in controlfile.
Creating OFFLINE file 'MISSING00039' in the controlfile.
This file can no longer be recovered so it must be dropped.
File #41 found in data dictionary but not in controlfile.
Creating OFFLINE file 'MISSING00041' in the controlfile.
This file can no longer be recovered so it must be dropped.
File #42 found in data dictionary but not in controlfile.
Creating OFFLINE file 'MISSING00042' in the controlfile.
This file can no longer be recovered so it must be dropped.
Dictionary check complete
Sat Dec 13 17:58:47 2008
SMON: enabling tx recovery
Sat Dec 13 17:58:47 2008
Database Characterset is UTF8
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open resetlogs
Sat Dec 13 18:02:55 2008
alter tablespace temp add tempfile 'F:\oradata\temp01.dbf' size 4096m
Sat Dec 13 18:02:55 2008
Completed:
alter tablespace temp add tempfile 'F:\oradata\te
Sat Dec 13 19:12:39 2008
Thread 1 advanced to log sequence 2
Current log# 1 seq# 2 mem# 0: F:\ORADATA\REDO06.LOG
Sat Dec 13 19:12:39 2008
ARC0: Evaluating archive log 5 thread 1 sequence 1
ARC0: Beginning to archive log 5 thread 1 sequence 1
Creating archive destination LOG_ARCHIVE_DEST_1: 'E:\ARCHLOG\ARCH_1_1.ARC'
ARC0: Completed
[ 本帖最后由 hbwp2008 于 2008-12-15 09:27 编辑 ]