ITPub博客

首页 > 数据库 > Oracle > Oracle 数据库启动 startup和startup force的区别

Oracle 数据库启动 startup和startup force的区别

Oracle 作者:dawn009 时间:2016-01-25 15:27:56 0 删除 编辑
1. startup
   就是正常启动数据库,没什么好说的。

2. startup force  
  是shutdown abort + startup的组合,即强制关闭数据库+ 正常启动数据库,想快速重启数据库时胆子大的人用的。
 startup force测试
 在一个窗口执行startup force  命令

点击(此处)折叠或打开

  1. [oracle@vm012odb018 ~]$ sqlplus "/as sysdba"

  2. SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 20 10:16:29 2013

  3. Copyright (c) 1982, 2013, Oracle. All rights reserved.


  4. Connected to:
  5. Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
  6. With the Partitioning, Oracle Label Security, OLAP, Data Mining
  7. and Real Application Testing options

  8. SQL> startup force
  9. ORACLE instance started.

  10. Total System Global Area 3340451840 bytes
  11. Fixed Size         2257840 bytes
  12. Variable Size         1929382992 bytes
  13. Database Buffers     1392508928 bytes
  14. Redo Buffers         16302080 bytes
  15. Database mounted.
  16. Database opened.
  17. SQL> 
同时监控后台数据库的alert日志

点击(此处)折叠或打开

  1. [root@vm012odb018 ~]# su - oracle
  2. [oracle@vm012odb018 ~]$ cd app/diag/rdbms/ledb01/LEDB01/trace/
  3. [oracle@vm012odb018 trace]$ tailf alert_LEDB01.log
  4. Archived Log entry 344 added for thread 1 sequence 344 ID 0xc87c495a dest 1:
  5. Fri Dec 20 02:00:00 2013
  6. Closing scheduler window
  7. Closing Resource Manager plan via scheduler window
  8. Clearing Resource Manager plan via parameter
  9. Fri Dec 20 02:00:08 2013
  10. Thread 1 advanced to log sequence 346 (LGWR switch)
  11.   Current log# 1 seq# 346 mem# 0: /home/oracle/app/oradata/LEDB01/redo01.log
  12. Fri Dec 20 02:00:09 2013
  13. Archived Log entry 345 added for thread 1 sequence 345 ID 0xc87c495a dest 1:


  14.              以下为startup force的日志



  15. Fri Dec 20 10:17:17 2013                      
      1. --数据库被shutdown abort

  16. Shutting down instance (abort)                              
  17. License high water mark = 9
  18. USER (ospid: 23328): terminating the instance
  19. Instance terminated by USER, pid = 23328
  20. Fri Dec 20 10:17:18 2013
  21. Instance shutdown complete
  22. Fri Dec 20 10:17:19 2013                                    --启动数据库startup      
  23. Starting ORACLE instance (normal)
  24. LICENSE_MAX_SESSION = 0
  25. LICENSE_SESSIONS_WARNING = 0
  26. Initial number of CPU is 1
  27. CELL communication is configured to use 0 interface(s):
  28. CELL IP affinity details:
  29.     NUMA status: non-NUMA system
  30.     cellaffinity.ora status: N/A
  31. CELL communication will use 1 IP group(s):
  32.     Grp 0:
  33. Picked latch-free SCN scheme 3
  34. Autotune of undo retention is turned on.
  35. IMODE=BR
  36. ILAT =51
  37. LICENSE_MAX_USERS = 0
  38. SYS auditing is disabled
  39. Starting up:
  40. Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
  41. With the Partitioning, Oracle Label Security, OLAP, Data Mining
  42. and Real Application Testing options.
  43. ORACLE_HOME = /home/oracle/app/product/11.2.0.4/db_1
  44. System name:    Linux
  45. Node name:    vm012odb018
  46. Release:    2.6.18-238.el5
  47. Version:    #1 SMP Thu Jan 13 15:51:15 EST 2011
  48. Machine:    x86_64
  49. Using parameter settings in server-side spfile /home/oracle/app/product/11.2.0.4/db_1/dbs/spfileLEDB01.ora
  50. System parameters with non-default values:
  51.   processes = 300
  52.   sessions = 472
  53.   event = ""
  54.   nls_language = "AMERICAN"
  55.   nls_territory = "AMERICA"
  56.   memory_target = 3200M
  57.   control_files = "/home/oracle/app/oradata/LEDB01/control01.ctl"
  58.   control_files = "/home/oracle/app/flash_recovery_area/LEDB01/control02.ctl"
  59.   db_block_size = 8192
  60.   compatible = "11.2.0.0.0"
  61.   log_archive_dest_1 = "location=/home/oracle/archivelog"
  62.   db_recovery_file_dest = "/home/oracle/app/flash_recovery_area"
  63.   db_recovery_file_dest_size= 3882M
  64.   undo_tablespace = "UNDOTBS1"
  65.   remote_login_passwordfile= "EXCLUSIVE"
  66.   db_domain = ""
  67.   dispatchers = "(PROTOCOL=TCP) (SERVICE=LEDB01XDB)"
  68.   audit_file_dest = "/home/oracle/app/admin/LEDB01/adump"
  69.   audit_trail = "DB"
  70.   db_name = "LEDB01"
  71.   open_cursors = 300
  72.   deferred_segment_creation= FALSE
  73.   diagnostic_dest = "/home/oracle/app"
  74. Fri Dec 20 10:17:21 2013
  75. PMON started with pid=2, OS id=23423
  76. Fri Dec 20 10:17:21 2013
  77. PSP0 started with pid=3, OS id=23427
  78. Fri Dec 20 10:17:22 2013
  79. VKTM started with pid=4, OS id=23431
  80. VKTM running at (100ms) precision
  81. Fri Dec 20 10:17:22 2013
  82. GEN0 started with pid=5, OS id=23437
  83. Fri Dec 20 10:17:22 2013
  84. DIAG started with pid=6, OS id=23441
  85. Fri Dec 20 10:17:22 2013
  86. DBRM started with pid=7, OS id=23445
  87. Fri Dec 20 10:17:22 2013
  88. DIA0 started with pid=8, OS id=23449
  89. Fri Dec 20 10:17:22 2013
  90. MMAN started with pid=9, OS id=23453
  91. Fri Dec 20 10:17:22 2013
  92. DBW0 started with pid=10, OS id=23457
  93. Fri Dec 20 10:17:23 2013
  94. LGWR started with pid=11, OS id=23461
  95. Fri Dec 20 10:17:23 2013
  96. CKPT started with pid=12, OS id=23465
  97. Fri Dec 20 10:17:23 2013
  98. SMON started with pid=13, OS id=23469
  99. Fri Dec 20 10:17:23 2013
  100. RECO started with pid=14, OS id=23473
  101. Fri Dec 20 10:17:23 2013
  102. MMON started with pid=15, OS id=23477
  103. starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
  104. Fri Dec 20 10:17:23 2013
  105. MMNL started with pid=16, OS id=23481
  106. starting up 1 shared server(s) ...
  107. ORACLE_BASE from environment = /home/oracle/app
  108. Fri Dec 20 10:17:23 2013
  109. ALTER DATABASE MOUNT
  110. Successful mount of redo thread 1, with mount id 3372810867
  111. Database mounted in Exclusive Mode
  112. Lost write protection disabled
  113. Completed: ALTER DATABASE MOUNT
  114. Fri Dec 20 10:17:27 2013
  115. ALTER DATABASE OPEN
  116. Beginning crash recovery of 1 threads
  117. Started redo scan
  118. Completed redo scan
  119.  read 129 KB redo, 50 data blocks need recovery
  120. Started redo application at
  121.  Thread 1: logseq 346, block 45315
  122. Recovery of Online Redo Log: Thread 1 Group 1 Seq 346 Reading mem 0
  123.   Mem# 0: /home/oracle/app/oradata/LEDB01/redo01.log
  124. Completed redo application of 0.03MB
  125. Completed crash recovery at
  126.  Thread 1: logseq 346, block 45573, scn 10747900
  127.  50 data blocks read, 50 data blocks written, 129 redo k-bytes read
  128. LGWR: STARTING ARCH PROCESSES
  129. Fri Dec 20 10:17:28 2013
  130. ARC0 started with pid=20, OS id=23510
  131. ARC0: Archival started
  132. LGWR: STARTING ARCH PROCESSES COMPLETE
  133. ARC0: STARTING ARCH PROCESSES
  134. Fri Dec 20 10:17:29 2013
  135. ARC1 started with pid=21, OS id=23514
  136. Fri Dec 20 10:17:29 2013
  137. ARC2 started with pid=22, OS id=23518
  138. Thread 1 advanced to log sequence 347 (thread open)
  139. Thread 1 opened at log sequence 347
  140.   Current log# 2 seq# 347 mem# 0: /home/oracle/app/oradata/LEDB01/redo02.log
  141. Successful open of redo thread 1
  142. MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
  143. SMON: enabling cache recovery
  144. ARC1: Archival started
  145. ARC2: Archival started
  146. ARC1: Becoming the 'no FAL' ARCH
  147. ARC1: Becoming the 'no SRL' ARCH
  148. ARC2: Becoming the heartbeat ARCH
  149. Fri Dec 20 10:17:29 2013
  150. ARC3 started with pid=23, OS id=23522
  151. Archived Log entry 346 added for thread 1 sequence 346 ID 0xc87c495a dest 1:
  152. [23506] Successfully onlined Undo Tablespace 2.
  153. Undo initialization finished serial:0 start:261251664 end:261251884 diff:220 (2 seconds)
  154. Verifying file header compatibility for 11g tablespace encryption..
  155. Verifying 11g file header compatibility for tablespace encryption completed
  156. SMON: enabling tx recovery
  157. ARC3: Archival started
  158. ARC0: STARTING ARCH PROCESSES COMPLETE
  159. Database Characterset is AL32UTF8
  160. No Resource Manager plan active
  161. replication_dependency_tracking turned off (no async multimaster replication found)
  162. Starting background process QMNC
  163. Fri Dec 20 10:17:32 2013
  164. QMNC started with pid=24, OS id=23530
  165. Completed: ALTER DATABASE OPEN
  166. Fri Dec 20 10:17:36 2013
  167. db_recovery_file_dest_size of 3882 MB is 0.00% used. This is a
  168. user-specified limit on the amount of space that will be used by this
  169. database for recovery-related files, and does not reflect the amount of
  170. space available in the underlying filesystem or ASM diskgroup.
  171. Fri Dec 20 10:17:36 2013
  172. Starting background process CJQ0
  173. Fri Dec 20 10:17:36 2013
  174. CJQ0 started with pid=25, OS id=23560
  175. Fri Dec 20 10:22:32 2013
  176. Starting background process SMCO
  177. Fri Dec 20 10:22:32 2013
  178. SMCO started with pid=28, OS id=23620

  179. oracle正常启动,startup force的全过程都在日志中体现。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29119536/viewspace-1982001/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2013-08-15

  • 博文量
    595
  • 访问量
    4850003