The overall objective of this course is to bring database administrators beyond a basic understanding of their environment and to focus attention on more advanced skills needed to effectively configure, administer, monitor and tune the database. Specific subjects to be considered are:
Using flashback technology to recover from user errors and from database failures.
Controlling resource utilization on database servers whose resource demand exceeds its capacity.
Automating routine tasks and functions using the database Scheduler.
Handling database corruption and even preventing such occurrences wherever possible.
Utilizing diagnostic sources in troubleshooting database problems.
Automatic database management, monitoring and tuning facilities. Included is automatic management of storage space and memory resources within the database.
Automatic resumption of database operations even in the face of failures and errors.
User-managed and automatically managed backup strategies and database recovery operations.
• about redo data
• tune redo writing & archiving
• more about instance recovery
• log_checkpoints_to_alert flashback database
• about flashback database
• configuring the flash recovery area
• performing database flashback