Oracle OCP 1Z0-053 Exam Topics

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