سرفصل های این دوره



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