|
|
|
|
|
|
| Re: How to add a new control file to oracle 10G R2 database [message #156970 is a reply to message #156961] |
Mon, 30 January 2006 07:48  |
alliejane
Messages: 59
Registered: July 2005
Location: Glasgow
|
Member |
|
|
Hi Maria,
Although the last post will work, there is a much easer way of multiplexing your controlfiles.
Oracle uses the "control_files =" entry in the parameter file to find the location of the controlfile(s) on database startup, you need to update this entry to point to multiple locations where you have placed identical copys of your 1 original controlfile.
You can only copy the controlfile when the database is closed so the order in which you perform these steps is very important.
In addition to that, there is two types of parameter files (init.ora and spfiles) which of the following instructions you follow depends of which type of file you are using.
To check which on type you are using, use the following command.
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string ?/spfile@.ora
If there is an entry in the value colum as above then you are using a server parameter file and it can't be update with a text editor, therefor follow the steps below.
SPFILE STEPS.
1. Use sqlplus to update your spfile with the location of the original controlfile and the two new ones that you will copy in the next step.
ALTER SYSTEM SET control_files =
'full path of original file','full path of copy 1','full path of copy 2' scope=spfile;
eg ...
ALTER SYSTEM SET control_files =
'$ORACLE_HOME/ORADATA/u01/control1.ctl','$ORACLE_HOME/ORADATA/u02/control2.ctl','$ORACLE_HOME/ORADATA/u03/control3.ctl'
scope=spfile;
2. shutdown immediate
3. Copy the controlfile to it's two new locations
4. Startup
If the value shows a blank
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ---------------
spfile string
Then follow the steps below.
INIT.ORA STEPS
1. Shutdown immdiate
2. Open the init.ora file in a text editor like vi (you should find it in the $ORACLE_HOME/dbs directory)
control_files='$ORACLE_HOME/ORADATA/u01/control1.ctl','$ORACLE_HOME/ORADATA/u02/control2.ctl','$ORACLE_HOME/ORADATA/u03/control3.ctl'
3. Copy the original file to it's two new locations.
4. Startup immediate.
Hope that helps, get back to me if you need any more information or support.
Good luck.
Allie
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
