Oracle 11g Admin II Certification - Exam 1Z0-053 Guide

Share this page:

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.
  • Manage Alerts and Thresholds.

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.

© 2024 Unisoft Technologies - Nagpur | Developed By In House Team