Transcription
Oracle Database 11g: Administration II – Exam Study GuideThe Oracle Database 11g: Administration II Exam Study Guide is designed to provide students withthe information that can help them learn more to pass the Oracle Database 11g Administration II (1Z0053) Exam.The exam audience is represented by Oracle Database 11g administrators, that have a strong foundationand expertise in the industry’s most advanced database management system.For each exam topic there have been identified alternative training options that are available at Oracle.Please note that some of the training recommended can cover multiple exam topics.The exam covers 19 topics.Topic 1: Database Architecture and ASMObjectivesDescribe Automatic Storage Management (ASM)Set up initialization parameter files for ASM and database instancesStart up and shut down ASM instancesAdminister ASM disk groupsTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Administration Workshop II DBA Release 2Topic 2: Configuring for RecoverabilityObjectivesConfigure multiple archive log file destinations to increase availabilityDefine, apply and use a retention policyConfigure the Flash Recovery AreaUse Flash Recovery AreaTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Administration Workshop II DBA Release 2Topic 3: Using the RMAN Recovery CatalogObjectivesIdentify situations that require RMAN recovery catalogCreate and configure a recovery catalogSynchronize the recovery catalog1
Create and Use RMAN stored scriptsBack up the recovery catalogCreate and use a virtual private catalogTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Administration Workshop II DBA Release 2Topic 4: Configuring Backup SpecificationsObjectivesConfigure backup settingsAllocate channels to use in backing upConfigure backup optimizationTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Administration Workshop II DBA Release 2Topic 5: Using RMAN to Create BackupsObjectivesCreate image file backupsCreate a whole database backupEnable fast incremental backupCreate duplex backup and back up backup setsCreate an archival backup for long-term retentionCreate a multisection, compressed and encrypted backupReport on and maintain backupsTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Administration Workshop II DBA Release 2Topic 6: Performing User-Managed Backup and RecoveryObjectivesRecover from a lost TEMP fileRecover from a lost redo log groupRecover from the loss of password filePerform user-managed complete database recoveryPerform user-managed incomplete database recoveryPerform user-managed and server managed backupsIdentify the need of backup mode2
Back up and recover a control fileTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Administration Workshop II DBA Release 2Topic 7: Using RMAN to Perform RecoveryObjectivesPerform complete recovery from a critical or noncritical data file loss using RMANPerform incomplete recovery using RMANRecover using incrementally updated backupsSwitch to image copies for fast recoveryRestore a database onto a new hostRecover using a backup control filePerform Disaster recoveryTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Administration Workshop II DBA Release 2Topic 8: Using RMAN to Duplicate a DatabaseObjectivesCreating a duplicate databaseUsing a duplicate databaseTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Administration Workshop II DBA Release 2Topic 9: Performing Tablespace Point-in-Time RecoveryObjectivesIdentify the situations that require TSPITRPerform automated TSPITRTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Administration Workshop II DBA Release 2Topic 10: Monitoring and Tuning RMAN3
ObjectivesMonitoring RMAN sessions and jobsTuning RMANConfigure RMAN for Asynchronous I/OTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Administration Workshop II DBA Release 2Topic 11: Using Flashback TechnologyObjectivesRestore dropped tables from the recycle binPerform Flashback QueryUse Flashback TransactionTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Administration Workshop II DBA Release 2Topic 12: Additional Flashback OperationsObjectivesPerform Flashback Table operationsConfigure, Monitor Flashback Database and Perform Flashback DatabaseoperationsSet up and use a Flashback Data ArchiveTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Administration Workshop II DBA Release 2Topic 13: Diagnosing the DatabaseObjectivesSet up Automatic Diagnostic RepositoryUsing Support WorkbenchPerform Block Media RecoveryTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Administration Workshop II DBA Release 24
Topic 14: Managing MemoryObjectivesImplement Automatic Memory ManagementManually configure SGA parametersConfigure automatic PGA memory managementTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Administration Workshop II DBA Release 2Topic 15: Managing Database PerformanceObjectivesUse the SQL Tuning AdvisorUse the SQL Access Advisor to tune a workloadUnderstand Database ReplayTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Administration Workshop II DBA Release 2Topic 16: Space ManagementObjectivesManage resumable space allocationDescribe the concepts of transportable tablespaces and databasesReclaim wasted space from tables and indexes by using the segment shrinkfunctionalityTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Administration Workshop II DBA Release 2Topic 17: Managing ResourcesObjectivesUnderstand the database resource managerCreate and use Database Resource Manager ComponentsTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Administration Workshop II DBA Release 25
Topic 18: Automating Tasks with the SchedulerObjectivesCreate a job, program, and scheduleUse a time-based or event-based schedule for executing Scheduler jobsCreate lightweight jobsUse job chains to perform a series of related tasksTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Administration Workshop II DBA Release 2Topic 19: Administering the SchedulerObjectivesCreate Windows and Job ClassesUse advanced Scheduler concepts to prioritize jobsTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Administration Workshop II DBA Release 2Copyright 2011, Oracle and/or its affiliates. All rights reserved.This document is provided for information purposes only and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any otherwarranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaimany liability with respect to this document and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in anyform or by any means, electronic or mechanical, for any purpose, without our prior written permission.Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. 01096
Oracle Database 11g: Administration Workshop II DBA Release 2 Topic 5: Using RMAN to Create Backups Objectives 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
