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

 

转载于:https://www.cnblogs.com/mengheyun/archive/2011/01/23/1949560.html