ABORT immediately shuts down without orderly dismount of disk groups - Oracle Control Files

Q.  Which Shutdown Mode in the ASM instance immediately shuts down without the orderly dismount of disk groups?
- Published on 27 Jul 15

a. ABORT
b. NORMAL
c. IMMEDIATE
d. TRANSACTIONAL

ANSWER: ABORT
 

    Discussion

  • Nirja Shah   -Posted on 28 Aug 15
    - 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.

    - 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.

    - 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.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)