RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Backup Recovery
Admin Tasks
Recovery File Structures
«Prev
Next»
Backup Recovery
Backup Considerations
DBA Responsibilities
DBA Role Considerations
Operational Considerations
Technical Considerations
Disaster Recovery Plan
Plans Testing
Backup Recovery Strategy
Oracle Memory Processes
Oracle Instance Structure
DBWR Arch Process
Oracle Recovery Data Structures
DB Configuration File
Database Control File
Control File Maintenance
RedoLog Files
Writing Redo Log Files
Multiplexing Redo Log
Archive Log Files
Checkpoint Process
Physical File Placement
State Structure Database
File Components Conclusion
Archivelog Noarchivelog
Physical Logical Backups
Archivelog Mode
Archiving Options
Archive Process Options
Normal Arch Processing
Manual Archiving
Auto ArchiveLog Options
Retrieve ArchiveLog
Standby Database
VM Conclusion
Control file maintenance - Exercise
Objective:
Test your understanding of parameter information for Control file maintenance in Oracle
Exercise Instructions
Match items in the left column with the items in the right column.
In the left column below are 9 items with their corresponding definitions in the right column. Match the term in the left column with the definition in the right column. When you have all of the terms and their definitions matched, click the
Submit
button to see whether or not you've matched the terms correctly.
When you complete the exercise, click the
Submit
button to see the correct answers.
Exercise Scoring
This exercise is unscored. It is designed to allow you to check your understanding of control files. When you are done, click the OK, I'm Done button.
INIT.ORA
V$SGA
V$DATABASE
ORC1
CTR1ORC1.ORA
B
32
Server Manager
Instance Manager
Will provide redo buffer size
Default MAXLOGFILE value
A typical default control file name
Will provide archive mode
Line mode tool
Default MAXLOGMEMBER value
Identifies the location of your control files
GUI tool
A typical default database name