This section describes the steps to make a back up copy of an Oracle ASM SPFILE in another disk group using the ASMCMD commands. If necessary, then the backup copy can be used to restore the Oracle ASM SPFILE.
The source and target disk groups must have the disk group attribute COMPATIBLE.ASM
set to 11.2
or higher.
To make a copy of the Oracle ASM SPFILE in another disk group with the spcopy
command perform the following steps:
-
Locate the Oracle ASM SPFILE using the ASMCMD spget
command.
For example:
ASMCMD [+] > spget
+DATA/ASM/ASMPARAMETERFILE/registry.253.849343867
-
Copy the Oracle ASM SPFILE to another disk group with spcopy
command.
For example:
ASMCMD [+] > spcopy +DATA/ASM/ASMPARAMETERFILE/registry.253.849343867 +FRA/spfileCopyASM.ora
Running spcopy
without the -u
option does not update the location of the Oracle ASM SPFILE. You can use spset
to set the location of the Oracle ASM SPFILE in the Grid Plug and Play (GPnP) profile.
-
List all the copies of the Oracle ASM SPFILE file contained in the FRA disk group using the ASMCMD ls
command.
For example:
ASMCMD [+] > ls -l --absolutepath FRA/ASM/ASMPARAMETERFILE
Type Redund Striped Time Sys Name
ASMPARAMETERFILE MIRROR COARSE JUN 06 13:00:00 Y +FRA/spfileCopyASM.ora => REGISTRY.253.849533009
-
Verify the current location of the Oracle ASM SPFILE file with the spget
command.
For example:
ASMCMD [+] > spget
+DATA/ASM/ASMPARAMETERFILE/registry.253.849343867
In the event that the current Oracle ASM SPFILE file in a disk group has been corrupted or that disk group is not accessible, you can use spset
or spcopy
with the -u
option to restore the Oracle ASM SPFILE file using the backup copy that you have previously created.
For example:
ASMCMD [+] > spcopy -u +FRA/spfileCopyASM.ora +DATA2/ASM/spfileASM.ora