what command does it pass on to all database instances that rely on the ASM instances disk groups?

When an ASM instance receives a SHUTDOWN NORMAL command, what command does
it pass on to all database instances that rely on the ASM instances disk groups?

When an ASM instance receives a SHUTDOWN NORMAL command, what command does
it pass on to all database instances that rely on the ASM instances disk groups?

A.
TRANSACTIONAL

B.
IMMEDIATE

C.
ABORT

D.
NORMAL



Leave a Reply 6

Your email address will not be published. Required fields are marked *


Rodge

Rodge

The question looks incorrect, as a shutdown normal will not pass on any command to other databases.
The behaviour of an ASM shutdown is defined below:

http://docs.oracle.com/cd/B28359_01/server.111/b31107/asminst.htm#OSTMG13640

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

NORMAL Clause

ASM waits for any in-progress SQL to complete before performing an orderly dismount of all of the disk groups and shutting down the ASM instance. Before the instance is shut down, ASM waits for all of the currently connected users to disconnect from the instance. If any database instances are connected to the ASM instance, then the SHUTDOWN command returns an error and leaves the ASM instance running. NORMAL is the default shutdown mode.

IMMEDIATE or TRANSACTIONAL Clause

ASM waits for any in-progress SQL to complete before performing an orderly dismount of all of the disk groups and shutting down the ASM instance. ASM does not wait for users currently connected to the instance to disconnect. If any database instances are connected to the ASM instance, then the SHUTDOWN command returns an error and leaves the ASM instance running. Because the ASM instance does not contain any transactions, the TRANSACTIONAL mode is the same as the IMMEDIATE mode.

ABORT Clause

The ASM instance immediately shuts down without the orderly dismount of disk groups. This causes recovery to occur upon the next ASM startup. If any database instance is connected to the ASM instance, then the database instance aborts.

birchI

birchI

true, I think question should be: When an ASM instance receives a SHUTDOWN ABORT command …

Radhakanta

Radhakanta

Answer should be NONE OF THE ABOVE

Guddu

Guddu

I agree.
Either the question should be asking about SHUTDOWN ABORT command,
or answers should have- NONE OF THE ABOVE option in it.

Igli

Igli

If any database instances are connected to the ASM instance, then the SHUTDOWN command returns an error and leaves the ASM instance running. NORMAL is the default shutdown mode.

The Question is correct.There has to be another answer that is the correct one.
E.None of the above