What is the result of executing this command?

You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM
instance. At the end of the day, while all three production database instances are running, you
execute the following command on the ASM instance :
SQL> shutdown immediate;
What is the result of executing this command?

You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM
instance. At the end of the day, while all three production database instances are running, you
execute the following command on the ASM instance :
SQL> shutdown immediate;
What is the result of executing this command?

A.
The ASM instance is shut down, but the other instances are still running.

B.
It results in an error because other database instances are connected to it.

C.
All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.

D.
HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM
instance is shut down in the IMMEDIATE mode.



Leave a Reply 1

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


Justyna

Justyna

҉ۢ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.”

Shutting Down an Oracle ASM Instance
http://docs.oracle.com/cd/E11882_01/server.112/e18951/asminst.htm#OSTMG13640