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
 
Search WWH ::




Custom Search