日志如下:Thu Jul 6 16:23:59 2006
Shutting down instance: further logons disabled
Thu Jul 6 16:24:23 2006
Shutting down instance (immediate)
License high water = 72
All dispatchers and shared servers shutdown
Thu Jul 6 16:24:28 2006
ALTER DATABASE CLOSE NORMAL
Thu Jul 6 16:24:28 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Thu Jul 6 16:24:28 2006
Shutting down archive processes
Archiving is disabled
Thu Jul 6 16:24:28 2006
ARCH shutting down
Thu Jul 6 16:24:28 2006
ARC0: Archival stopped
Thu Jul 6 16:24:28 2006
ARCH shutting down
Thu Jul 6 16:24:28 2006
ARC1: Archival stopped
Thu Jul 6 16:24:29 2006
Thread 1 closed at log sequence 172
Successful close of redo thread 1.
Thu Jul 6 16:24:29 2006
Completed: ALTER DATABASE CLOSE NORMAL
Thu Jul 6 16:24:29 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thu Jul 6 16:24:42 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
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 = 400
timed_statistics = TRUE
shared_pool_size = 838860800
large_pool_size = 16777216
java_pool_size = 117440512
control_files = /oracle/oradata/JDSNWF/control01.ctl, /oracle/oradata/JDSNWF/control02.ctl, /oracle/oradata/JDSNWF/control03.ctl
db_block_size = 8192
db_cache_size = 536870912
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest_1 = location=/export/home
log_archive_format = %t_%s.dbf
log_buffer = 1048576
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 = JDSNWF
dispatchers = (PROTOCOL=TCP) (SERVICE=JDSNWFXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = /oracle/admin/JDSNWF/bdump
user_dump_dest = /oracle/admin/JDSNWF/udump
core_dump_dest = /oracle/admin/JDSNWF/cdump
sort_area_size = 524288
db_name = JDSNWF
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 Jul 6 16:24:44 2006
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 Jul 6 16:24:44 2006
ARCH: STARTING ARCH PROCESSES COMPLETE
Thu Jul 6 16:24:44 2006
ARC1: Archival started
Thu Jul 6 16:24:44 2006
ARC0: Thread not mounted
Thu Jul 6 16:24:44 2006
ARC1: Thread not mounted
Thu Jul 6 16:24:44 2006
ALTER DATABASE MOUNT
Thu Jul 6 16:24:52 2006
Successful mount of redo thread 1, with mount id 34036047.
Thu Jul 6 16:24:52 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Thu Jul 6 16:24:52 2006
ALTER DATABASE OPEN
Thu Jul 6 16:24:52 2006
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 opened at log sequence 172
Current log# 3 seq# 172 mem# 0: /oracle/oradata/JDSNWF/redo03.log
Successful open of redo thread 1.
Thu Jul 6 16:24:52 2006
SMON: enabling cache recovery
Thu Jul 6 16:24:53 2006
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 Jul 6 16:24:53 2006
SMON: enabling tx recovery
Thu Jul 6 16:24:53 2006
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Shutting down instance: further logons disabled
Thu Jul 6 16:24:23 2006
Shutting down instance (immediate)
License high water = 72
All dispatchers and shared servers shutdown
Thu Jul 6 16:24:28 2006
ALTER DATABASE CLOSE NORMAL
Thu Jul 6 16:24:28 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Thu Jul 6 16:24:28 2006
Shutting down archive processes
Archiving is disabled
Thu Jul 6 16:24:28 2006
ARCH shutting down
Thu Jul 6 16:24:28 2006
ARC0: Archival stopped
Thu Jul 6 16:24:28 2006
ARCH shutting down
Thu Jul 6 16:24:28 2006
ARC1: Archival stopped
Thu Jul 6 16:24:29 2006
Thread 1 closed at log sequence 172
Successful close of redo thread 1.
Thu Jul 6 16:24:29 2006
Completed: ALTER DATABASE CLOSE NORMAL
Thu Jul 6 16:24:29 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thu Jul 6 16:24:42 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
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 = 400
timed_statistics = TRUE
shared_pool_size = 838860800
large_pool_size = 16777216
java_pool_size = 117440512
control_files = /oracle/oradata/JDSNWF/control01.ctl, /oracle/oradata/JDSNWF/control02.ctl, /oracle/oradata/JDSNWF/control03.ctl
db_block_size = 8192
db_cache_size = 536870912
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest_1 = location=/export/home
log_archive_format = %t_%s.dbf
log_buffer = 1048576
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 = JDSNWF
dispatchers = (PROTOCOL=TCP) (SERVICE=JDSNWFXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = /oracle/admin/JDSNWF/bdump
user_dump_dest = /oracle/admin/JDSNWF/udump
core_dump_dest = /oracle/admin/JDSNWF/cdump
sort_area_size = 524288
db_name = JDSNWF
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 Jul 6 16:24:44 2006
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 Jul 6 16:24:44 2006
ARCH: STARTING ARCH PROCESSES COMPLETE
Thu Jul 6 16:24:44 2006
ARC1: Archival started
Thu Jul 6 16:24:44 2006
ARC0: Thread not mounted
Thu Jul 6 16:24:44 2006
ARC1: Thread not mounted
Thu Jul 6 16:24:44 2006
ALTER DATABASE MOUNT
Thu Jul 6 16:24:52 2006
Successful mount of redo thread 1, with mount id 34036047.
Thu Jul 6 16:24:52 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Thu Jul 6 16:24:52 2006
ALTER DATABASE OPEN
Thu Jul 6 16:24:52 2006
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 opened at log sequence 172
Current log# 3 seq# 172 mem# 0: /oracle/oradata/JDSNWF/redo03.log
Successful open of redo thread 1.
Thu Jul 6 16:24:52 2006
SMON: enabling cache recovery
Thu Jul 6 16:24:53 2006
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 Jul 6 16:24:53 2006
SMON: enabling tx recovery
Thu Jul 6 16:24:53 2006
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货