RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Backup Recovery
Admin Tasks
Manual | Automatic Archiving
«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
Manual archiving - Exercise
Manual archiving
Objective:
Test comprehension of manual archive processing
Instructions
Below are 5 steps identifying the normal processing of a manual archive, but they are presented out of order. Drag the steps into the correct order, with the first step at the top of the list. When you think you have the steps in the correct order, click Done.
You will be told whether or not the order is correct. If you didn't get the order right, keep trying.
If you get stuck, try clicking Hint. The steps you have in the correct place will have green lights next to them. The steps that are not in the correct place will have red lights next to them.
When you're ready for an explanation, click the
Submit button
.
Exercise Scoring
This exercise is unscored. It is designed to allow you to check your understanding of manual archive processing. When you are done, click the Submit button.
Open the redo log file members.
Read the headers of the redo log file members
Validate redo log file information with control file information.
Read and verify a group of data blocks from a redo log file member.
Copy the data blocks to an archive log file.