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