Oracle Database 11g R2: Administration II
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 within a large-scale enterprise. At Course Completion Specific subject areas to be explored and objectives to be reached are:
•Automatic database management, monitoring and tuning facilities. Included is automatic management of storage space and memory resources within the database.
•Using Oracle flashback technology to recover from user errors and from database failures, including flashback data archive and flashback transaction backout along with the Total Recall capability.
•Controlling resource utilization on database servers whose resource demand exceeds its capacity.
•Automating launching routine maintenance tasks and even application functions using the database Scheduler.
•Handling database corruption.
•Utilizing diagnostic sources in troubleshooting database problems and employing the Fault Diagnosability Infrastructure to capture fault data.
•Automatic resumption of database operations even in the face of failures and errors.
•User-managed and automatically managed backup strategies and database recovery operations.
•Use advanced Enterprise Manager wizards and tools, including the integrated LogMiner, Flasback Transaction Backout wizard, database Recovery Wizard, and others.
•Automatic Storage Management (ASM) of some or all database files, providing a database-centric and optimized storage subsystem and volume manager.