ITPub博客

首页 > 数据库 > Oracle > Oracle OCP 1Z0 053 Q77(ASM&Shutdown Immediate)

Oracle OCP 1Z0 053 Q77(ASM&Shutdown Immediate)

原创 Oracle 作者:abstractcyj 时间:2016-04-02 14:44:08 0 删除 编辑
77.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.
Answer: B

1Z0-053 Q711考察的shutdown abort

Shutdwn immediate:当还有数据库实例连接ASM实例时,会出错。ASM实例并不会被关闭。
shutdown abort: ASM实例关闭, 同时下次启动时需要进行实例恢复。同时,会导致连接的数据库实例以shutdown abort的形式关闭

官方文档:http://docs.oracle.com/database/121/OSTMG/GUID-9C2208C8-B436-4A18-A5D7-0CE854751529.htm#OSTMG13640

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

    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 "Deregistering, Dismounting, and Disabling Volumes and Oracle ACFS File Systems". For more information about user authentication on Oracle ASM instance, see "Authentication for Accessing Oracle ASM Instances".

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/8520577/viewspace-2074176/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
曾从事java方向开发多年。近年已经转入数据库方向。主要擅长SQL优化,Oracle数据库问题诊断,Oracle备份与恢复等。服务于医药物流,医院等行业

注册时间:2010-01-26

  • 博文量
    602
  • 访问量
    1091635