RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Backup Recovery
Admin Tasks
Recovery Considerations
«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
Backup and Recovery Considerations - Quiz
1.
Over what category of failure does a DBA exert the greatest control?
Please select
the best answer
.
A.
Environmental
B.
Hardware
C.
Software
D.
Operational
2.
What are the major consideration(s) you should keep in mind relating to backup and recovery planning?
Please select
all the correct answers
.
A.
Technical
B.
Operational
C.
Business
D.
Programming
3.
The backup and recovery planning process will help determine which of the following:
Please select
all the correct answers
.
A.
The average time to recover a database
B.
How often a database will crash
C.
Which users will need ALTER TABLESPACE privilege
D.
Which tables contain the most data
4.
When you have decided on a backup and recovery strategy, which of the following should you do?
Please select
all the correct answers
.
A.
Test the validity of your strategy
B.
Meet with your management to review your strategy
C.
Buy more disk drives to implement you strategy
D.
Quantify the cost of down time in the event of a failure