Database Reference
In-Depth Information
To add a control file when using a text
init.ora
file, perform the following steps:
1.
Shut down your database:
SQL> shutdown immediate;
2.
Edit your
init.ora
file with an OS utility (such as
vi
), and add the new control file location
and name to the
CONTROL_FILES
parameter. This example opens the
init.ora
file, using
vi
, and adds
control02.ctl
to the
CONTROL_FILES
parameter:
$ vi $ORACLE_HOME/dbs/initO12C.ora
Listed next is the
CONTROL_FILES
parameter after
control02.ctl
is added:
control_files='/u01/dbfile/O12C/control01.ctl',
'/u01/dbfile/O12C/control02.ctl'
3.
From the OS, copy the existing control file to the location, and name of the control file
being added:
$ cp /u01/dbfile/O12C/control01.ctl /u01/dbfile/O12C/control02.ctl
4.
Start up your database:
SQL> startup;
You can view the control files in use by displaying the
CONTROL_FILES
parameter:
SQL> show parameter control_files
For this example, here is the output:
NAME TYPE VALUE
---------------- ----------- ------------------------------
control_files string /u01/dbfile/O12C/control01.ctl
,/u01/dbfile/O12C/control02.ctl
Moving a Control File
You may occasionally need to move a control file from one location to another. For example, if new storage is added to
the database server, you may want to move an existing control file to the newly available location.