Recovery File Structures
Disaster Recovery Plan
Oracle Memory Processes
Oracle Instance Structure
DBWR Arch Process
Oracle Recovery Data Structures
DB Configuration File
Database Control File
Control File Maintenance
Writing Redo Log Files
Multiplexing Redo Log
Archive Log Files
Physical File Placement
State Structure Database
File Components Conclusion
Physical Logical Backups
Archive Process Options
Normal Arch Processing
Auto ArchiveLog Options
Document Database Installation - Exercise
Document your system
This exercise is worth a total of 10 points. You'll receive up to 2 points for correctly answering each question.
You have installed your general ledger system and as the final task before going live you must document your database installation.
You will need the following download files in order to complete this exercise:
Information about your system is contained in the spool.txt file. This file contains output from several v$ view and server manager commands.
Your init.ora file is named initgl1.ora.
To document your site you must fill out siteinfo.doc, using the information contained in spool.txt and initgl1.ora.
Please download the above files and fill out the siteinfo.doc file using the information contained in spool.txt and initgl1.ora. When you are finished completing the siteinfo.doc file, please answer the following questions about your system and identify where you got your answer. When you are finished entering your responses in the text box that appears below each question, click the
button to send your answers.
Do you have duplexed control files?
Do you have duplexed archive log files?
Are you setup for noarchivelog mode or archivelog mode?
If you are setup for archivelog mode, are you running automatic or manual archiving?
What modifications would you make to your redo log files, if any?