根据OU官方发布的考试大纲,OCP 1Z0-053考点如下: 1. 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
2. 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
3. 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
4. Configuring Backup Specifications
- Configure backup settings
- Allocate channels to use in backing up
- Configure backup optimization
5. 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
6. 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
7. 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
8. Using RMAN to Duplicate a Database
- Creating a duplicate database
- Using a duplicate database
9. Performing Tablespace Point-in-Time Recovery
- Identify the situations that require TSPITR
- Perform automated TSPITR
10. Monitoring and Tuning RMAN
- Monitoring RMAN sessions and jobs
- Tuning RMAN
- Configure RMAN for Asynchronous I/O
11. Using Flashback Technology
- Restore dropped tables from the recycle bin
- Perform Flashback Query
- Use Flashback Transaction
12. Additional Flashback Operations
- Perform Flashback Table operations
- Configure, Monitor Flashback Database and Perform Flashback Database operations
- Set up and use a Flashback Data Archive
13. Diagnosing the Database
- Set up Automatic Diagnostic Repository
- Using Support Workbench
- Perform Block Media Recovery
14. Managing Memory
- Implement Automatic Memory Management
- Manually configure SGA parameters
- Configure automatic PGA memory management
15. Managing Database Performance
- Use the SQL Tuning Advisor
- Use the SQL Access Advisor to tune a workload
- Understand Database Replay
16. 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
17. Managing Resources
- Understand the database resource manager
- Create and use Database Resource Manager Components
18. 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
19. Administering the Scheduler
- Create Windows and Job Classes
- Use advanced Scheduler concepts to prioritize jobs