Database Reference
In-Depth Information
The output shows that this database is using only one control file:
NAME TYPE VALUE
----------------- ----------- ------------------------------
control_files string /u01/dbfile/O12C/control01.ctl
2.
Alter your
CONTROL_FILES
parameter to include the new control file that you want to add,
but limit the scope of the operation to the
spfile
(you can't modify this parameter in
memory). Make sure you also include any control files listed in step 1:
SQL> alter system set control_files='/u01/dbfile/O12C/control01.ctl',
'/u01/dbfile/O12C/control02.ctl' scope=spfile;
3.
Shut down your database:
SQL> shutdown immediate;
4.
Copy an existing control file to the new location and name. In this example a new control
file named
control02.ctl
is created via the OS
cp
command:
$ cp /u01/dbfile/O12C/control01.ctl /u01/dbfile/O12C/control02.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 /u01/dbfile/O12C/control01.ctl
,/u01/dbfile/O12C/control02.ctl
Init.ora Scenario
Run the following statement to verify that you're using an
init.ora
file. If you're not using an
spfile
, the
VALUE
column is blank:
SQL> show parameter spfile
NAME TYPE VALUE
---------- ----------- ------------------------------
spfile string