###############################################################
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
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