Course Name:Oracle Database 11g Administration II(1Z0-053)
Course Fees:10,000
Course Duration:1 month
Syllabus:
Database Architecture and ASM
- Describe Automatic Storage Management (ASM)
- Set up initialization parameter files for ASM and database instances
- Start up and shut down ASM instances
- Administer ASM disk groups
Configuring for Recoverability
- Configure multiple archive log file destinations to increase availability
- Define, apply and use a retention policy
- Configure the Flash Recovery Area
- Use Flash Recovery Area
Using the RMAN Recovery Catalog
- Identify situations that require RMAN recovery catalog
- Create and configure a recovery catalog
- Synchronize the recovery catalog
- Create and Use RMAN stored scripts
- Back up the recovery catalog
- Create and use a virtual private catalog
Configuring Backup Specifications
- Configure backup settings
- Allocate channels to use in backing up
- Configure backup optimization
Using RMAN to Create Backups
- Create image file backups
- Create a whole database backup
- Enable fast incremental backup
- Create duplex backup and back up backup sets
- Create an archival backup for long-term retention
- Create a multisection, compressed and encrypted backup
- Report on and maintain backups
Performing User-Managed Backup and Recovery
- Recover from a lost TEMP file
- Recover from a lost redo log group
- Recover from the loss of password file
- Perform user-managed complete database recovery
- Perform user-managed incomplete database recovery
- Perform user-managed and server managed backups
- Identify the need of backup mode
- Back up and recover a control file
Using RMAN to Perform Recovery
- Perform complete recovery from a critical or noncritical data file loss using RMAN
- Perform incomplete recovery using RMAN
- Recover using incrementally updated backups
- Switch to image copies for fast recovery
- Restore a database onto a new host
- Recover using a backup control file
- Perform Disaster recovery
Using RMAN to Duplicate a Database
- Creating a duplicate database
- Using a duplicate database
Performing Tablespace Point-in-Time Recovery
- Identify the situations that require TSPITR
- Perform automated TSPITR
Monitoring and Tuning RMAN
- Monitoring RMAN sessions and jobs
- Tuning RMAN
- Configure RMAN for Asynchronous I/O
Using Flashback Technology
- Restore dropped tables from the recycle bin
- Perform Flashback Query
- Use Flashback Transaction
Additional Flashback Operations
- Perform Flashback Table operations
- Configure, Monitor Flashback Database and Perform Flashback Database operations
- Set up and use a Flashback Data Archive
Diagnosing the Database
- Set up Automatic Diagnostic Repository
- Using Support Workbench
- Perform Block Media Recovery
Managing Memory
- Implement Automatic Memory Management
- Manually configure SGA parameters
- Configure automatic PGA memory management
Managing Database Performance
- Use the SQL Tuning Advisor
- Use the SQL Access Advisor to tune a workload
- Understand Database Replay
Space Management
- Manage resumable space allocation
- Describe the concepts of transportable tablespaces and databases
- Reclaim wasted space from tables and indexes by using the segment shrink functionality
Managing Resources
- Understand the database resource manager
- Create and use Database Resource Manager Components
Automating Tasks with the Scheduler
- Create a job, program, and schedule
- Use a time-based or event-based schedule for executing Scheduler jobs
- Create lightweight jobs
- Use job chains to perform a series of related tasks
Administering the Scheduler
- Create Windows and Job Classes
- Use advanced Scheduler concepts to prioritize jobs