| 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 |
|