• 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

  • 相关阅读:
    Oracle数据库(3-7)
    Oracle数据库之PL/SQL程序设计简介
    JAVA总结
    JAVA数据库编程、JAVA XML解析技术
    JAVA网络编程
    【转载】linux启动jmeter,执行./jmeter.sh报错解决方法
    【转载】JMeter学习(十九)JMeter测试MongoDB
    【转载】JMeter学习(二十)JMeter处理Cookie与Session
    【转载】JMeter学习(十八)JMeter测试Java(二)
    【转载】JMeter学习(十七)JMeter测试Java
  • 原文地址:https://www.cnblogs.com/jyzhao/p/4911844.html
Copyright © 2020-2023  润新知