Skip to content

ASM Startup

The startup for ASM instance are similar to those for RDBMS instances

For Example Nomount option start  up an asm instance without mounting any diskgroups.

SQL> startup nomount
ASM instance started

Total System Global Area 283930624 bytes
Fixed Size 2212656 bytes
Variable Size 256552144 bytes
ASM Cache 25165824 bytes

SQL> select name,state from v$asm_diskgroup;

NAME STATE
—————————— ———–
DATA DISMOUNTED

Mount option is used to mount the all diskgroup specified in ASM_DISKGROUPS init.ora parameter.

SQL> ALTER DISKGROUP ALL MOUNT;

Diskgroup altered.

SQL> select name,state from v$asm_diskgroup;

NAME STATE
—————————— ———–
DATA MOUNTED

 

If no diskgroup listed in the init.ora file, then the message “ORA-15110: no diskgroups mounted” is displayed. If the listed diskgroups cannot be mounted, then the following messages appear: “ORA-15032: not all alterations performed,” and, “ORA-5063: ASM discovered an insufficient number of disks for diskgroup <diskgroup name>.”

In Oracle Database 11g, ASM introduced the RESTRICTED startup option for the MOUNT command. When an ASM instance is started with the RESTRICTED option, the starting ASM instance exclusively mounts all of the diskgroups listed in  the ASM_DISKGROUPS parameter, and no RDBMS access is permitted in this mode.When the RESTRICTED startup option is used on a diskgroup in an ASM clustered(RAC) environment, no other ASM instance in the cluster can access that diskgroup.The RESTRICTED option is particularly useful when performing maintenance, such as a rebalance, on a diskgroup or set of diskgroups.

For Example :

SQL> startup restrict

ASM instance started

Total System Global Area 283930624 bytes
Fixed Size 2212656 bytes
Variable Size 256552144 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted

SQL> SELECT NAME, STATE FROM V$ASM_DISKGROUP;

NAME STATE
—————————— ———–
DATA RESTRICTED

I am trying to start the database but getting error

SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file ‘+DATA/asmoracle/spfileasmoracle.ora’
ORA-17503: ksfdopn:2 Failed to open file +DATA/asmoracle/spfileasmoracle.ora
ORA-15056: additional error message
ORA-17503: ksfdopn:DGOpenFile05 Failed to open file +DATA/asmoracle/spfileasmoracle.ora
ORA-17503: ksfdopn:2 Failed to open file +DATA/asmoracle/spfileasmoracle.ora
ORA-15236: diskgroup DATA mounted in restricted mode
ORA-06512: at line 4
SQL>

After maintenance work, you need to shutdown the asm instance and startup the asm

SQL> shutdown immediate
ASM diskgroups dismounted
ASM instance shutdown

SQL> startup
ASM instance started

Total System Global Area 283930624 bytes
Fixed Size 2212656 bytes
Variable Size 256552144 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted

SQL> SELECT NAME, STATE FROM V$ASM_DISKGROUP;

NAME STATE
—————————— ———–
DATA MOUNTED

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 140 other followers

%d bloggers like this: