Oracle Database 11g: Administration II (1Z0-053 )

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