Oracle Database 11g Administration II (1Z0-053) - Online Course

Prepare for the Oracle Database 11g Administration II exam and learn everything you need to pass it on your first try! This study guide series covers some of the more in-depth database administration topics, such as database structure and Oracle Automatic Storage Management, Oracle Recovery Manager (RMAN), Oracle Flashback, disk space and resource management, and database globalization. Practice exams are part of the series, containing questions using the same format as the exam and including in-depth instructional feedback.

This series is for anyone who is preparing for the Oracle Database 11g Administration II (1Z0-053) exam. This online course contains 13 lessons and 4 practice exams and should take approximately 26 hours to complete.

Lesson 1: Using Oracle ASM (2.0) hours

Using Oracle ASM teaches you how to describe Automatic Storage Management (ASM), set up initialization parameter files for ASM and database instances, start up and shut down ASM instances, and administer ASM diskgroups. This course discusses how Automatic Storage Management (ASM) can help manage disk space for all Oracle file types, including online and archived logs, RMAN backup sets, flashback logs, and even initialization parameter files (spfiles). This course examines what ASM is, how to configure an ASM instance, how to manage an ASM instance, and how to use ASM from within an Oracle database. Topics include Using Oracle ASM.

Lesson 2: Performing User-Managed Backups (2.0) hours

Performing User-Managed Backups teaches you how to configure backup settings, configure multiple archive log file destinations to increase availability, identify the need of backup mode, perform user-managed backups and server-managed backups, and back up and recover a control file. This course provides an overview of Oracle 11g backup and recovery. Topics include Performing User-Managed Backups.

Lesson 3: Performing User-Managed Database Recoveries (2.0) hours

Performing User-Managed Database Recoveries teaches you how to perform user-managed complete database recovery, perform user-managed incomplete database recovery, backup and recover a control file, recover from a lost TEMP file, recover from a lost redo log group, and recover from the loss of a password file. This course shows you how to restore databases with user-based backups. It covers backups taken in NOARCHIVELOG mode and ARCHIVELOG mode. Topics include Performing User-Managed Database Recoveries.

Lesson 4: Configuring and Backing Up Using RMAN (2.0) hours

Configuring and Backing Up Using RMAN teaches you how to allocate channels to use in backing up, configure backup optimization, define, apply and use a retention policy, configure the Flash Recovery Area, use Flash Recovery Area, 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, and create a multi-section compressed and encrypted backup. This course provides an introduction to RMAN: its features and configuration and how to use it to back up your Oracle database. Topics include Configuring and Backing Up Using RMAN.

Lesson 5: Using the RMAN Recovery Catalog (1.0) hour

Using the RMAN Recovery Catalog teaches you how to identify situations that require an RMAN recovery catalog, create and configure a recovery catalog, synchronize the recovery catalog, create and use RMAN stored scripts, back up the recovery catalog, and create and use a virtual private catalog. This course provides an overview of RMAN recovery catalogs, which can make your life as a DBA easier by providing a centralized repository for RMAN-related data. Topics include Using the RMAN Recovery Catalog.

Lesson 6: Recovering Databases with RMAN (1.0) hour

Recovering Databases with RMAN teaches you how to perform complete recovery from a critical or non-critical data file loss using RMAN, perform incomplete recovery using RMAN, recover using incrementally updated backups, switch to image copies for fast recovery, and recover using a backup control file. This course provides an overview of the use of Oracle Recovery Manager RMAN for database backup and recovery. Topics include Recovering Databases with RMAN.

Lesson 7: Reporting, Monitoring, and Tuning with RMAN (1.0) hour

Reporting, Monitoring, and Tuning with RMAN teaches you how to monitor RMAN sessions and jobs, tune RMAN, configure RMAN for Asynchronous I/O, and report on and maintain backups. This course provides information on the reporting, monitoring, and tuning features available in RMAN. Topics include Reporting, Monitoring, and Tuning with RMAN.

Lesson 8: Performing Advanced Recovery (1.0) hour

Performing Advanced Recovery teaches you how to restore a database onto a new host, perform disaster recovery, create a duplicate database, use a duplicate database, identify the situations that require TSPITR, and perform automated TSPITR. This course covers advanced recovery topics, including RMAN incarnations, RMAN database duplication, tablespace point-in-time recovery, and disaster recovery for Oracle databases. Topics include Performing Advanced Recovery.

Lesson 9: Understanding Flashback Technology (2.0) hours

Understanding Flashback Technology teaches you how to restore dropped tables from the Recycle Bin, use Flashback Query and Flashback Transaction Query, perform Flashback Table operations, configure, monitor, and perform Flashback Database operations, and set up and use a Flashback Data Archive. This course gives an overview of the functionality provided by Flashback technology in Oracle 11g, including the recovery of dropped objects, querying data as it existed at a point in time in the past, and returning the entire database to a point in time or SCN. Topics include Understanding Flashback Technology.

Lesson 10: Diagnosing the Database and Managing Performance (2.0) hours

Diagnosing the Database and Managing Performance teaches you how to set up Automatic Diagnostic Repository, use Support Workbench, perform block media recovery, use the SQL Tuning Advisor, use the SQL Access Advisor to tune a workload, and recognize Database Replay. This course introduces tools you can use to diagnose problems in a database, and then detect and resolve performance issues. Topics include Diagnosing the Database and Managing Performance.

Lesson 11: Managing Database Resources (2.0) hours

Managing Database Resources teaches you how to implement Automatic Memory Management, configure SGA parameters, configure automatic PGA memory management, manage resumable space allocation, use segment shrink functionality to reclaim table and index space, and create and use Database Resource Manager Components. This course describes how to effectively manage memory, space, and resources in Oracle 11g. Topics include Managing Memory, Managing Space, and Managing Resources.

Lesson 12: Using the Scheduler to Automate Tasks (2.0) hours

Using the Scheduler to Automate Tasks teaches you how to 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, create Windows and Job Classes, and use advanced Scheduler concepts to prioritize jobs. This course provides an overview of Oracle Scheduler and how to use it to manage jobs in the Oracle database. Topics include Using the Scheduler to Automate Tasks.

Lesson 13: Implementing Globalization Support (2.0) hours

Implementing Globalization Support teaches you how to customize language-dependent behavior for the database and individual sessions, and work with database and NLS character sets. This course explains how Oracle's globalization support lets you manage data in multiple native languages within the same database instance and simplifies global application development. Topics include Implementing Globalization Support.

4 Practice Exams

This course presents questions that will help you prepare for the Oracle Database 11g Administration II (1Z0-053) exam.