Files in Support of Backup and Recovery Operations - Oracle RMAN for Absolute Beginners - page 19

The procedure for moving a control file is very similar to adding a control file. The only difference is that you
rename the control file instead of copying it. This example shows how to move a control file when you're using an
spfile :

1. Determine the CONTROL_FILES parameter's current value:

SQL> show parameter control_files

NAME TYPE VALUE
----------------- ----------- ------------------------------
control_files string /u01/dbfile/O12C/control01.ctl

2. Alter your CONTROL_FILES parameter to reflect that you're moving a control file. In this

example the control file is currently in this location:

/u01/dbfile/O12C/control01.ctl

You're moving the control file to this location:

/u02/dbfile/O12C/control01.ctl

Alter the spfile to reflect the new location for the control file. You have to specify
SCOPE=SPFILE because the CONTROL_FILES parameter can't be modified in memory:

SQL> alter system set
control_files='/u02/dbfile/O12C/control01.ctl' scope=spfile;

3. Shut down your database:

SQL> shutdown immediate;

At the OS prompt, move the control file to the new location. This example uses the OS mv
command:

4.

$ mv /u01/dbfile/O12C/control01.ctl /u02/dbfile/O12C/control01.ctl

5. Start up your database:

SQL> startup;

You can verify that the new control file is being used by displaying the CONTROL_FILES parameter:

SQL> show parameter control_files

Here is the output for this example:

NAME TYPE VALUE
---------------- ----------- ------------------------------
control_files string /u02/dbfile/O12C/control01.ctl