How to add an additional controlfile
213061Nov 30 2003 — edited Dec 1 2003Hi, I need to add an additional controlfile for my Oracle 9i instance. After consult the Oracle manual, it advises me the following steps for my goal:
1. Shut down the database (nomount).
2. Copy an existing controlfile to my desired location.
3. Amend the parameter 'CONTROL_FILE' on the initialization file of the database.
4. Start the database.
However, the initialization file of my database named spfile{$SID}.ora which is located on $ORACLE_HOME/dbs, is not a text file. I have tried to amend it's content with the vi editor but finally make it corrupted. So, my main question is how to amend the initialization file to accept the new configuration setting of my controlfile.