Oracle 資料庫啟動 startup和startup force的區別

dawn009發表於2016-01-25
Oracle資料庫
1. startup
   就是正常啟動資料庫，沒什麼好說的。

2. startup force  
  是shutdown abort + startup的組合，即強制關閉資料庫+ 正常啟動資料庫，想快速重啟資料庫時膽子大的人用的。
 startup force測試
 在一個視窗執行startup force  命令

點選(此處)摺疊或開啟

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

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

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


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

  13. SQL> startup force
  14. ORACLE instance started.

  16. Total System Global Area 3340451840 bytes
  17. Fixed Size         2257840 bytes
  18. Variable Size         1929382992 bytes
  19. Database Buffers     1392508928 bytes
  20. Redo Buffers         16302080 bytes
  21. Database mounted.
  22. Database opened.
  23. 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:

  15.              以下為startup force的日誌



  19. Fri Dec 20 10:17:17 2013                      
      1. --資料庫被shutdown abort

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

  184. oracle正常啟動，startup force的全過程都在日誌中體現。

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29119536/viewspace-1982001/，如需轉載，請註明出處，否則將追究法律責任。

相關文章