Starting with ASM version 11.2, the ASM spfile can be stored in an ASM disk group. Indeed, during a new ASM installation, the Oracle Universal Installer (OUI) will place the ASM spfile in the disk group that gets created during the installation.

New ASMCMD commands
To support this feature, new ASMCMD commands were introduced to back up, copy and move the ASM spfile. The commands are:
  • spbackup – Backs up an ASM spfile to a backup file. The backup file is not a special file type and is not identified as an spfile.
  • spcopy – Copies an ASM spfile from the source location to an spfile in the destination location.
  • spmove – moves an ASM spfile from source to destination and automatically updates the GPnP profile.
  • spget – Retrieves the location of the Oracle ASM SPFILE.

Taking backup of current spfile

spmove will copy the current spfile to the new location and update the gpnp profile for next startup.This command throw errors as not all alterations performed as current spfile is being used, in the next startup the new spfile will be effective and we can manually remove the old spfile

lets move the spfile to the $ORACLE_HOME/dbs directory.

Restart the HA stack to verify that ASM starts up fine with moved spfile

Lets check current location of SPFILE

Comments

Leave a Reply