停止ASM例項

To shut down an Oracle ASM instance, perform the following steps:

SQLPLUS /NOLOG
SQL> CONNECT SYS AS SYSASM
Enter password: sys_password
Connected.
SQL> SHUTDOWN NORMAL

For more information about user authentication, see .

The following list describes the SHUTDOWN modes and the behavior of the Oracle ASM instance in each mode.

• NORMAL Clause

  Oracle ASM waits for any in-progress SQL to complete before performing an orderly dismount of all of the disk groups and shutting down the Oracle ASM instance. Before the instance is shut down, Oracle ASM waits for all of the currently connected users to disconnect from the instance. If any database instances are connected to the Oracle ASM instance, then the SHUTDOWN command returns an error and leaves the Oracle ASM instance running. NORMAL is the default shutdown mode.
  ASM等待正在執行的SQL完成操作、所有使用者斷開連線才停止例項，如果有DB繼續連著該例項，那麼該操作出錯
  

• IMMEDIATE or TRANSACTIONAL Clause

  Oracle ASM waits for any in-progress SQL to complete before performing an orderly dismount of all of the disk groups and shutting down the Oracle ASM instance. Oracle ASM does not wait for users currently connected to the instance to disconnect. If any database instances are connected to the Oracle ASM instance, then the SHUTDOWN command returns an error and leaves the Oracle ASM instance running. Because the Oracle ASM instance does not contain any transactions, the TRANSACTIONAL mode behaves the same as IMMEDIATE mode.
  ASM等待所有正在執行的SQL完成後進行dismount和停止例項的操作，不等待使用者斷開連線，同樣如果還有DB例項連線到ASM例項，那麼停止操作出錯，
  必須等到DB例項斷開才正常關閉ASM例項
  

• ABORT Clause

  The Oracle ASM instance immediately shuts down without the orderly dismount of disk groups. This causes recovery to occur upon the next Oracle ASM startup.

  If any database instance is connected to the Oracle ASM instance, then the database instance aborts.

  If any Oracle Automatic Storage Management Cluster File System (Oracle ACFS) file systems are currently mounted on Oracle ADVM volumes, those file systems should first be dismounted. Otherwise, applications encounter I/O errors and Oracle ACFS user data and metadata may not be written to storage before the Oracle ASM storage is fenced. For information about dismounting an Oracle ACFS file system, see . For more information about user authentication on Oracle ASM instance, see .
  
  這種情況下ASM例項和連線的DB例項都異常關閉，下次啟動需要恢復，慎用。