How do I create a Diskgroup in ASM 12c?

How do I create a Diskgroup in ASM 12c?

Oracle by Anand

1. Set ASM Environment and Login to your ASM instance as sysasm.
2. [oracle@node2 ~]$ export ORACLE_HOME=/u01/app/12.2.0.2/grid. [oracle@node2 ~]$ export PATH=$PATH:$ORACLE_HOME/bin.
3. Step2:
4. Identify the availiable Candidate/Provisioned disks.
5. set line 200.
6. MOUNT_S HEADER_STATU STATE PATH.
7. 8 rows selected.
8. Step3:

What is Diskgroup in ASM?

Diskgroup is a terminology used for logical structure which holds the database files. Each diskgroup consists of disks/raw devices where the files are actually stored. Any ASM file (and it’s redundant copy) is completely contained within a single diskgroup.

How do I shut down ASM?

The Oracle ASM shutdown process is initiated when you run the SHUTDOWN command in SQL*Plus. Before you run this command, ensure that the ORACLE_SID environment variable is set to the Oracle ASM SID so that you can connect to the local Oracle ASM instance.

Why do we need ASM?

ASM eliminates the need for you to directly manage potentially thousands of Oracle database files. ASM groups the disks in your storage system into one or more disk groups. You manage a small set of disk groups and ASM automates the placement of the database files within those disk groups.

How do you stop and start ASM?

Startup and shutdown the Oracle ASM instance

1. Set the default Oracle_home environment variable to grid home where ASM is installed. EXPORT ORACLE_HOME=/up1/grid/12.2.0/dbhome_1.
2. Connect with sqlplus. SQLPLUS / as sysasm.
3. Start up the Oracle ASM Instance. SQL> STARTUP.
4. Check the spfile location or otherwise set it with.

How to create a group for an ASM disk?

Either way, the OS user who is running the ASM processes must be the owner of the disks – not root – and the group must be set to whatever you want to specify in the OUI installer. Usually, there are 6 groups: DBA, Operator, and Installer for both ASM and RDBMS.

What does it mean to create a disk group?

This statement creates a disk group, assigns one or more disks to the disk group, and mounts the disk group for the first time. Note that CREATE DISKGROUP only mounts a disk group on the local node.

Can a failgroup be specified in a disk group?

The disks within the disk group must provide redundancy (for example, using a storage array), or you must be willing to tolerate loss of the disk group if a disk fails (for example, in a test environment). You cannot specify the FAILGROUP clause if you specify EXTERNAL REDUNDANCY.

What are the permissions for an ASM disk?

ASM disks MUST be raw (character, not block devices) and the file permissions must be 0600 (meaning read/write by owner and NOBODY else can read or write, with no set or sticky bits). Was this post helpful? Thanks for your feedback! The disk are already created. Though I cannot recall if I used oracle or root When creating them.