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
|
