SQL> conn / as sysdba
已连接。
SQL> startup force
ORACLE 例程已经启动。
Total System Global Area 1360078244 bytes
Fixed Size 456100 bytes
Variable Size 411041792 bytes
Database Buffers 947912704 bytes
Redo Buffers 667648 bytes
数据库装载完毕。
数据库已经打开。
然后查看一下Alter.log,红色标出部分可以看出数据库进行了实例恢复,也就可以说startup force=shutdown abort+startup
Fri Jan 23 16:44:50 2009
Starting ORACLE instance (force)
License high water mark = 110
Instance terminated by USER, pid = 3804
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 = 300
timed_statistics = TRUE
shared_pool_size = 318767104
large_pool_size = 33554432
java_pool_size = 33554432
control_files = F:/oracle/oradata/neuora/control01.ctl, F:/oracle/oradata/neuora/control02.ctl, F:/oracle/oradata/neuora/control03.ctl
db_block_size = 8192
db_cache_size = 947912704
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 = neuora
job_queue_processes = 6
hash_join_enabled = TRUE
background_dump_dest = F:/oracle/admin/neuora/bdump
user_dump_dest = F:/oracle/admin/neuora/udump
core_dump_dest = F:/oracle/admin/neuora/cdump
sort_area_size = 524288
db_name = neuora
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 524288000
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
Fri Jan 23 16:44:53 2009
ALTER DATABASE MOUNT
Fri Jan 23 16:44:58 2009
Successful mount of redo thread 1, with mount id 1049877061.
Fri Jan 23 16:44:58 2009
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Fri Jan 23 16:44:58 2009
ALTER DATABASE OPEN
Fri Jan 23 16:44:58 2009
Beginning crash recovery of 1 threads
Fri Jan 23 16:44:58 2009
Started first pass scan
Fri Jan 23 16:44:58 2009
Completed first pass scan
266 redo blocks read, 34 data blocks need recovery
Fri Jan 23 16:44:58 2009
Started recovery at
Thread 1: logseq 736, block 161069, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 1 Seq 736 Reading mem 0
Mem# 0 errs 0: F:/ORACLE/ORADATA/NEUORA/REDO01.LOG
Fri Jan 23 16:44:58 2009
Ended recovery at
Thread 1: logseq 736, block 161335, scn 0.59182680
34 data blocks read, 34 data blocks written, 266 redo blocks read
Crash recovery completed successfully
Fri Jan 23 16:44:59 2009
Thread 1 advanced to log sequence 737
Thread 1 opened at log sequence 737
Current log# 2 seq# 737 mem# 0: F:/ORACLE/ORADATA/NEUORA/REDO02.LOG
Successful open of redo thread 1.
Fri Jan 23 16:44:59 2009
SMON: enabling cache recovery
Fri Jan 23 16:44:59 2009
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.
Fri Jan 23 16:44:59 2009
SMON: enabling tx recovery
Fri Jan 23 16:44:59 2009
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN