Purpose
Copies an Oracle ASM SPFILE from the source location to an SPFILE in the destination location.
Syntax and Description
spcopy [-u] source destination
Table 10-19 lists the options for the spcopy
command.
Table 10-19 Options for the spcopy command
Option | Description |
---|---|
|
Updates the Grid Plug and Play (GPnP) profile. |
|
Specifies the source file name. |
|
Specifies the destination. |
Note the following about the use of spcopy
:
spcopy
can copy an Oracle ASM SPFILE from a disk group to a different disk group or to an operating system file.
spcopy
can copy an Oracle ASM SPFILE from an operating system file to a disk group.
spcopy
can copy an Oracle ASM SPFILE when the SPFILE is being used by an open Oracle ASM instance.
spcopy
cannot make multiple copies of an Oracle ASM SPFILE in the same disk group. You can use spbackup
for that purpose.
To update the GPnP profile, include the -u
option with spcopy
. You can also use spset
to update the GPnP profile if spcopy
is run without the -u
option. See "spset". For information about copying and moving an Oracle ASM instance initialization parameter file after upgrading, see "About Backing Up_ Copying_ and Moving an Oracle ASM Initialization Parameter File".
After copying the SPFILE and updating the GPnP profile, you must restart the instance with the SPFILE in the new location to use that SPFILE. When the Oracle ASM instance is running with the SPFILE in the new location, you can remove the source SPFILE.
To copy an Oracle ASM SPFILE into a disk group using spcopy
, the COMPATIBLE.ASM
attribute must be set to 11.2
or greater in the target disk group.
The CREATE SPFILE
SQL statement in the Oracle Database SQL Language Reference for information about creating a server parameter file
Example
The following are examples of the spcopy
command. The first example copies the Oracle ASM SPFILE from the data
disk group to the fra
disk group. The second example copies the Oracle ASM SPFILE from the data
disk group to an operating system location. The third example copies an Oracle ASM SPFILE from an operating system location to the data
disk group and updates the GPnP profile with the -u
option.
Example 10-24 Using the ASMCMD spcopy command
ASMCMD> spcopy +DATA/asm/asmparameterfile/registry.253.721810181 +FRA/spfileCopyASM.ora ASMCMD> spcopy +DATA/asm/asmparameterfile/registry.253.721810181 $ORACLE_HOME/dbs/spfileCopyASM.ora ASMCMD> spcopy -u /oracle/product/11.2.0/grid/dbs/spfileTestASM.ora +DATA/ASM/spfileCopyASM.ora