Practice 6: Maintaining the Control File
1 Where is the existing control file located and what is the name?
2 Try to start the database without any control files. (You can simulate this by
changing the name of the control file in the parameter file or just changing the
name of the control file.) What happens?
3 Multiplex the existing control file using the directory DISK2 and name the new
control file control02.con. Make sure that the Oracle Server is able to write to
the new control file. For example, on UNIX use the command chmod 660.
Confirm that both control files are being used.
4 What is the initial sizing of the datafile section in your control file?
Practice 6: Maintaining the Control File
1 Where is the existing control file located and what is the name?
Hint: Query the dynamic performance view V$CONTROLFILE or
V$PARAMETER, or execute the SHOW PARAMETER command to
display the name and the location of the control file.
2 Try to start the database without any control files (You can simulate this by
changing the name of the control file in the parameter file or just changing the
name of the control file.) What happens?
Hint: There is no hint for this question.
3 Multiplex the existing control file using the directory DISK2 and name the new
control file control02.con. Make sure that the Oracle server is able to write to the
new control file. For example, on UNIX use the command chmod 660. Confirm
that both control files are being used.
Hint
– Shut down the database.
– Copy the existing control file to a new file with the name control02.con to
the directory DISK2.
– Use the command chmod 660 on UNIX.
– Modify the parameter file to include the new filename.
– Start up the database.
– Query the dynamic performance view V$CONTROLFILE or
V$PARAMETER or use the SHO PARAMETER command to confirm both
control files are being used.
4 What is the initial sizing of the data file section in your control file?
Hint: There is no hint for this question.