Oracle · Oracle Grid Infrastructure · RAC

Move ASM instance spfile to an ASM diskgroup

Today my grid infrastructure installation failed and I had to set up ASM on my own not using the installer. The same situation may happen If you lost the diskgroup containing the ASM spfile. For solving the problem The only thing I need was an ASM instance and a diskgroup for my spfile.

I created an init file for the asm instance. instance_type parameter is the key parameter in this case.

[oracle@node1DR ~]$ cat /tmp/initasm.ora
*.asm_power_limit=1
*.diagnostic_dest='/u01/app/oracle'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'

ORACLE_HOME and ORACLE_SID must be set properly

[oracle@node1DR ~]$ echo $ORACLE_SID
+ASM
[oracle@node1DR ~]$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/grid

startup the asm instance using the pfile.

[oracle@node1DR ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Mon Jul 8 23:35:21 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup pfile=/tmp/initasm.ora nomount ;
ASM instance started
Total System Global Area 283930624 bytes
Fixed Size 2227664 bytes
Variable Size 256537136 bytes
ASM Cache 25165824 bytes

move the pfile to the diskgroup, in this case it is +DATA

SQL> create spfile='+DATA' from pfile='/tmp/initasm.ora';
File created.

check if the spfile is used by the ASM resource

[oracle@node1DR ~]$ srvctl config asm
ASM home: /u01/app/oracle/product/11.2.0/grid
ASM listener: LISTENER
Spfile: +DATA/asm/asmparameterfile/registry.253.820281649
ASM diskgroup discovery string:

if it is not used by the OCR then you can locate the spfile inside the diskgroup and change the OCR configuration

[oracle@node1DR ~]$ srvctl modify asm -p "+DATA/asm/asmparameterfile/registry.253.820281649"

Confirmation 

[oracle@node1DR ~]$ srvctl stop diskgroup -g DATA
[oracle@node1DR ~]$ srvctl stop asm
[oracle@node1DR ~]$ srvctl start asm
[oracle@node1DR ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 9 00:05:11 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option


SQL> show parameter spfile ;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/asm/asmparameterfile/registry.253.820281649

Advertisements

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