麻烦各位看看
Successfully onlined Undo Tablespace 1.
Fri Jul 25 22:12:20 2008
SMON: enabling tx recovery
Fri Jul 25 22:12:20 2008
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Fri Jul 25 22:12:21 2008
SMON: Parallel transaction recovery tried
Fri Jul 25 22:12:22 2008
Completed: alter database open
Sat Jul 26 00:38:58 2008
Thread 1 cannot allocate new log, sequence 2564
All online logs needed archiving
Current log# 3 seq# 2563 mem# 0: D:ORACLEORADATAmonitorREDO03.LOG
Dump file d
racleadminmonitordumpalert_monitor.log
Sat Jul 26 08:56:24 2008
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 Jul 26 08:56:24 2008
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 = 83886080
large_pool_size
= 8388608
java_pool_size = 33554432
control_files
= d
racleoradatamonitorCONTROL01.CTL, d
racleoradatamonitorCONTROL02.CTL, d
racleoradatamonitorCONTROL03.CTL
db_block_size
= 8192
db_cache_size
= 285212672
compatible
= 9.2.0.0.0
log_archive_dest_1 = LOCATION=d:arc1 MANDATORY REOPEN=300
db_file_multiblock_read_count= 32
fast_start_mttr_target = 300
undo_management
= AUTO
undo_tablespace
= UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain
=
instance_name
= monitor
dispatchers
= (PROTOCOL=TCP) (SERVICE=monitorXDB)
job_queue_processes= 20
hash_join_enabled= TRUE
hash_area_size = 1048576
background_dump_dest = d
racleadminmonitordump
user_dump_dest = d
racleadminmonitorudump
core_dump_dest = d
racleadminmonitorcdump
sort_area_size = 1048576
db_name
= monitor
open_cursors
= 10000
star_transformation_enabled= TRUE
query_rewrite_enabled= TRUE
pga_aggregate_target = 100663296
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
Sat Jul 26 08:56:28 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sat Jul 26 08:56:28 2008
alter database mount exclusive
Sat Jul 26 08:56:34 2008
Successful mount of redo thread 1, with mount id 287726845.
Sat Jul 26 08:56:34 2008
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Sat Jul 26 08:56:34 2008
alter database open
Sat Jul 26 08:56:34 2008
Beginning crash recovery of 1 threads
Sat Jul 26 08:56:34 2008
Started first pass scan
Sat Jul 26 08:56:35 2008
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Sat Jul 26 08:56:35 2008
Started recovery at
Thread 1: logseq 2563, block 204799, scn 2230.959255448
Recovery of Online Redo Log: Thread 1 Group 3 Seq 2563 Reading mem 0
Mem# 0 errs 0: D:ORACLEORADATAmonitorREDO03.LOG
Sat Jul 26 08:56:35 2008
Ended recovery at
Thread 1: logseq 2563, block 204799, scn 2230.959275449
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Sat Jul 26 08:56:35 2008
LGWR: Primary database is in CLUSTER CONSISTENT mode
Sat Jul 26 08:56:35 2008
ARCH: Evaluating archive log 1 thread 1 sequence 2561
ARCH: Beginning to archive log 1 thread 1 sequence 2561
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:ARC1ARC02561.001'
ARCH: Completed archivinglog 1 thread 1 sequence 2561
Sat Jul 26 08:56:39 2008
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 2564
Thread 1 opened at log sequence 2564
Current log# 1 seq# 2564 mem# 0: D:ORACLEORADATAmonitorREDO01.LOG
Successful open of redo thread 1.
Sat Jul 26 08:56:40 2008
SMON: enabling cache recovery
Sat Jul 26 08:56:41 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.
Sat Jul 26 08:56:41 2008
SMON: enabling tx recovery
Sat Jul 26 08:56:41 2008
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Sat Jul 26 08:56:43 2008
SMON: Parallel transaction recovery tried
Sat Jul 26 08:56:43 2008
Completed: alter database open
应该没有错误信息啊
|