RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Backup Recovery
Admin Tasks
Controlfile DB Parameters
«Prev
Next»
DBA Taks
Database Monitoring
What To Monitor
Alert Log Information
Finding Alert Log
Alert Log Contents
Renaming Alert Log
Checking License Compliance
Monitoring Free Space
Checking For Objects
DatabaseBuffer Cache HitRatio
Improve Cache HitRatio
Buffer Cache Hit
SharedPool Hit Ratios
Collecting Statistics
Monitoring Io
Detecting Redo Log
Database Monitoring Conclusion
Control File Parameters
Protecting Control Files
Removing Control File
Add Control File
Backingup Control File
Recreating Control Files
Checking Parameter Values
v Parameter Dynamic
Changing DB Parameters
Managing DB Parameters
Managing Redo Log
Protecting redoLog Files
Listing RedoLog Files
Create Redo Log Files
Dropping Redo Log Files
Moving Redo Log Files
Manually Switch Log Files
Managing RedoLog Conclusion
Redolog Files
Archivelog Mode
Archive Log Destination
Naming Archive Log Files
Manually Archiving Log File
Archive Log History
Archivelog Mode Conclusion
Manage Tablespace Files
Adding Control File - Exercise
Add Control Files to Oracle Database
Objective:
Add a control file to the COIN database.
Exercise scoring
This is an auto-scored exercise worth 20 points.
Background/overview
You have recently experienced a number of disk drive failures and are becoming a bit worried that you might get hit with multiple drive failures at once, causing you to lose your control file. To allow yourself to sleep better at night, you decide to add a new control file to your database.
Instructions
Go through the process of adding a control file to your COIN database. Remember to change the
control_files
parameter in your initialization file, and remember that Oracle reads only that file when you start an instance.
Submitting your Exercise
Enter your text into the TextBox below and click
Submit
.