Thursday, May 15, 2014

How to Move SPFILE & Password file into different ASM DISKGROUP

###############################################################
How to Move SPFILE & Password file into different ASM DISKGROUP
###############################################################


===============
Password File
==============
ASMCMD> pwget --asm
+DATA/ASM/PASSWORD/pwdasm.270.847074049

ASMCMD> pwcopy +DATA/ASM/PASSWORD/pwdasm.270.847074049 +ASMDG/orapwasm
copying +DATA/ASM/PASSWORD/pwdasm.270.847074049 -> +ASMDG/orapwasm

ASMCMD> ls -ltr +ASMDG/orapwasm


Type      Redund  Striped  Time             Sys  Name
PASSWORD  UNPROT  COARSE   MAY 09 03:00:00  N    orapwasm => +ASMDG/ASM/PASSWORD/pwdasm.256.847078823

ASMCMD> pwset --asm +ASMDG/ASM/PASSWORD/pwdasm.256.847078823

ASMCMD> pwget --asm
+ASMDG/ASM/PASSWORD/pwdasm.256.847078823


===============
SPFILE File
==============
ASMCMD> spget
+DATA/ASM/ASMPARAMETERFILE/REGISTRY.253.847072573

Note: I did not create ASM/ASMPFILE folder
ASMCMD> spcopy +DATA/ASM/ASMPARAMETERFILE/REGISTRY.253.847072573 +ASMDG/ASM/ASMPFILE/

ORA-15056: additional error message
ORA-17502: ksfdcre:4 Failed to create file +ASMDG/REGISTRY.253.847072573
ORA-15221: ASM operation requires compatible.asm of 11.2.0.0.0 or higher
ORA-06512: at line 7 (DBD ERROR: OCIStmtExecute)
ASMCMD> exit


SQL>ALTER DISKGROUP ASMDG SET ATTRIBUTE 'compatible.asm'='12.1';

Diskgroup altered.


ASMCMD> ls -ltr +ASMDG/ASM/ASMPARAMETERFILE/

Type              Redund  Striped  Time             Sys  Name
ASMPARAMETERFILE  UNPROT  COARSE   MAY 09 03:00:00  Y    REGISTRY.253.847078307


ASMCMD> spset +ASMDG/ASM/ASMPARAMETERFILE/REGISTRY.253.847078307


ASMCMD> spget --asm
+DATA/ASM/ASMPARAMETERFILE/REGISTRY.253.847072573


============
Verification
============
ASMCMD> shutdown --immediate
ASM diskgroups dismounted
ASM instance shutdown
Connected to an idle instance.


SQL> !crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'dbtrmrk'
CRS-2673: Attempting to stop 'ora.evmd' on 'dbtrmrk'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'dbtrmrk'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'dbtrmrk' succeeded
CRS-2677: Stop of 'ora.evmd' on 'dbtrmrk' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'dbtrmrk'
CRS-2677: Stop of 'ora.cssd' on 'dbtrmrk' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'dbtrmrk' has completed
CRS-4133: Oracle High Availability Services has been stopped.

SQL> !crsctl start has
CRS-4123: Oracle High Availability Services has been started.



ASMCMD> startup
ASM instance started

Total System Global Area 1135747072 bytes
Fixed Size                  2297344 bytes
Variable Size            1108283904 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted

NAME                           STATE
------------------------------ -----------
ASMDG                          MOUNTED
DATA                           MOUNTED


SQL> !asmcmd spget --asm
+ASMDG/ASM/ASMPARAMETERFILE/REGISTRY.253.847078307

SQL>  !asmcmd pwget --asm
+ASMDG/ASM/PASSWORD/pwdasm.256.847078823



============
Remove old
============
ASMCMD> rm -r DATA/orapwasm
You may delete multiple files and/or directories.
Are you sure? (y/n) y


ASMCMD> rm -r DATA/ASM/ASMPARAMETERFILE
You may delete multiple files and/or directories.
Are you sure? (y/n) y

Enjoy....Abid Malik

No comments:

Post a Comment