关于Startup force

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

 

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值