How can I add another control file to my database?
Answer: Adding and changing the control files is easy. All you do is
copy the file and change the value of your control_files
Let's say I have this setting:
If I want to add a new control file, I follow these steps:
Make sure that the new control file resides on
a SEPARATE physical disk. The purpose of multiple control files
is to protect the database in case of a disk failure.
Check to ensure that the new disk exists (the
mount point or Windows drive letter) and that Oracle has
permission to create the control file on that mount point.
If not, you may
ORA-00344 unable to re-create log:
ORA-00344: unable to re-create online log
ORA-27040: skgfrcre: create error, unable
to create file
OSD-04002: unable to open file O/S-Error: (OS 5) Access is
Shutdown Oracle and use the cp command to copy
one of the old control files to the new location
Change the control_files parameter
for your instance:
Start your instance.