Oracle Database 11g: Administration Workshop I
Course code
MUK-ODB2
Duration
5 Days, 40 Acad. Hours
Course Overview
Objectives
Prerequisites
Course Outline
Course Overview
Course overview
This Oracle Database 11g: Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You’ll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery.
Objectives
Course objective
- Configure the Oracle Database for optimal recovery
- Configure the database instance such that resources are appropriately allocated among sessions and tasks
- Schedule jobs to run inside or outside of the database
- Use compression to optimize database storage and duplicate a database
- Back and recover a database (and its parts) with RMAN (command-line and Enterprise Manager)
- Use flashback technology to view past states of data and to revert either objects or the entire database back to a past state
- Use an appropriate and flexible memory configuration for your database
- Identify burdensome database sessions and poorly performing SQL
Prerequisites
Suggested Prerequisite
- Working knowledge of SQL and how to use PL/SQL packages
Required Prerequisite
- Oracle Database 11g: Administration Workshop I Ed 2
- Oracle Database 11g Database Administration
Audience
- Administrator
- Database Administrator
- Implementer
Course Outline
Course outline
- Core Concepts and Tools of the Oracle Database
- Configuring for Recoverability
- Using the RMAN Recovery Catalog
- Configuring Backup Settings
- Creating Backups with RMAN
- Restore and Recovery Task
- Using RMAN to Perform Recovery
- Monitoring and Tuning RMAN
- Diagnosing the Database
- Using Flashback Technology I
- Using Flashback Technology II
- Performing Flashback Database
- Managing Memory
- Managing Database Performance
- Managing Performance by SQL Tuning
- Managing Resources
- Automating Tasks with the Scheduler
- Managing Space in Blocks
- Managing Space in Segments
- Managing Space for the Database
- Duplicating a Database
Request the training
Oracle Database 11g: Administration Workshop I
Course code:
MUK-ODB2
Duration:
5 Days, 40 Acad. Hours
