I use Oracle9i release 1 on Windows 2000. I need help multiplexing my control file. I take a copy of my control...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
file through operating system command and add a new path of this control file in parameter file. But when I restart my instance and apply this query...
(select * from control_files )
... I am not shown the new control file path. What do I do?
Also, when the instance is started, which file is read pfile or spfile?
When you start an instance, the following order is used to know which parameter file to use:
1. Use the explicitly stated parameter file in the STARTUP command, if provided.
2. Use the $ORACLE_HOME/dbs/spfileSID.ora (Unix) or %ORACLE_HOME%databasespfileSID.ora (Windows) if available.
3. Use the $ORACLE_HOME/dbs/initSID.ora (Unix) or %ORACLE_HOME%databaseinitSID.ora (Windows) if available.
4. Use the $ORACLE_HOME/dbs/init.ora (Unix) or %ORACLE_HOME%databaseinit.ora (Windows) if available.
5. No parameter files were available so issue an error message and abort the startup of the database.
So when you wanted to change your CONTROL_FILES parameter, you needed to make that change in your SPFILE. Your changes in the INIT.ORA were never read. Make the change in your SPFILE (ALTER SYSTEM SET CONTROL_FILES='file1','file2' SCOPE=SPFILE) and bounce the database.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.