oracle alter disk,oracle.1z0-053:ALTER DISKGROUP data MOUNT RESTRICT;

QUESTION

NO: 36

You issued the following command to mount the DATA disk group in restricted

mode:

ALTER DISKGROUP data MOUNT RESTRICT;

What is the implication of this command?

A. The client RDBMS instance can access the file as a read-only file.

B. A new disk cannot be added to a disk group.

C. A disk in a disk group can be taken offline.

D. The client RDBMS instance cannot access the files in the disk group.

Answer: D

Explanation:

diskgroup_availability

Use this clause to make

one or more disk groups available or unavailable to the database instances

running on the same node as the Oracle ASM instance. This clause does not

affect the status of the disk group on other nodes in a cluster.

MOUNT

SpecifyMOUNTto mount the disk groups in the local Oracle ASM instance.

SpecifyALLMOUNTto mount all disk groups specified in theASM_DISKGROUPSinitialization parameter. File operations can only be performed

when a disk group is mounted. If Oracle ASM is running in a cluster or a

standalone server managed by Oracle Restart, then theMOUNTclause automatically brings the corresponding resource online.

RESTRICTED | NORMALUse these clauses to

determine the manner in which the disk groups are mounted.

·        In theRESTRICTEDmode, the disk group is mounted in single-instance exclusive mode.

No other Oracle ASM instance in the same cluster can mount that disk group.In this mode the

disk group is not usable by any Oracle ASM client.

·

In theNORMALmode, the disk group is mounted in shared mode, so that other

Oracle ASM instances and clients can access the disk group. This is the

default.