Font size:

Description:

This is a bundled training package. It contains training for each of the bundled items below:

Course Price
Oracle Database 11g Release 2: Database Architecture and Recovery Operations $74.95
Oracle Database 11g Release 2: The RMAN Catalog and Creating Backups $74.95
Oracle Database 11g Release 2: Performing Restore and Recovery Tasks $74.95
Oracle Database 11g Release 2: Using, Monitoring and Tuning RMAN $74.95
Oracle Database 11g Release 2: Database Diagnostics and Flashback Technologies $74.95
Oracle Database 11g Release 2: Managing Database Memory and Performance $74.95
Oracle Database 11g Release 2: Managing Database Resources and the Scheduler $74.95
Oracle Database 11g Release 2: Managing Database Space and Duplication $74.95

Bundle Price: $289.00
Total Savings: $310.60


Oracle Database 11g Release 2: Database Architecture and Recovery Operations

An important aspect of Oracle Database administration is to understand how a database and its major components function. Also as an Oracle Database administrator, you need to be able to recover when problems occur in the database. This is accomplished using backups, which are used to protect against problems such as media failure, user errors, and application errors. This course reviews the major architectural components of the Oracle Database 11g architecture, such as memory structures, background processes, and the logical and physical storage structures. This course also discusses how to prepare an Oracle Database 11g database for recovery and backup using RMAN, ARCHIVELOG mode, retention policies, and a Flash Recovery Area. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle Database 11g: Administration II (1Z0-053) exam.
  • identify the characteristics of the database memory structures and process architecture
  • identify the characteristics of the database storage architecture
  • recognize the purposes of configuration and management DBA tools
  • recognize key characteristics of Oracle Database 11g's backup and recovery functionality
  • use Recovery Manager
  • configure ARCHIVELOG mode and retention policy for a database
  • configure the Fast Recovery Area in a database
  • configure the database for recovery

Oracle Database 11g Release 2: The RMAN Catalog and Creating Backups

RMAN uses a recovery catalog to store metadata about Oracle databases, and allows stored scripts to be used to run sequences of RMAN commands stored in the catalog. When administering an Oracle Database, it is important to be familiar with what a backup is, how the process of creating a backup is completed, and the various types of backups available. This knowledge allows you to make an informed decision on the best way to maintain the integrity of your data and the availability of your database. This course discusses how to create and manage the recovery catalog. It also explains how to configure backup specifications, including methods of optimizing a backup and how to use RMAN to create backups. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle Database 11g: Administration II (1Z0-053) exam.
  • identify the characteristics of the RMAN recovery catalog
  • use RMAN stored scripts
  • identify the steps for backing up a recovery catalog
  • use virtual private catalogs
  • configure a recovery catalog
  • recognize the processes involved in preparing and optimizing a database for a backup
  • create fast incremental backup and duplex backup sets using RMAN
  • identify the features of archival backups
  • create and manage backups using RMAN

Oracle Database 11g Release 2: Performing Restore and Recovery Tasks

As a database administrator it is very important to understand how to restore and recover your database in the event of a loss of a file due to media, hardware, or user error. The restoration process involves moving a backup into place to be used by the database when a file is damaged. The recovery process involves applying redo to bring the file forward in time to before the failure or up to the failure point. This course discusses the type of failures that can occur and how to recover from them. It also discusses how to perform user-managed backup and recoveries. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle Database 11g: Administration II (1Z0-053) exam.
  • identify the causes of file loss
  • recover log files and indexes
  • identify the major recovery processes
  • recover a read-only tablespace
  • recover an Oracle database
  • recognize the different types of user-managed backup and recovery practices
  • perform different types of user-managed recoveries

Oracle Database 11g Release 2: Using, Monitoring and Tuning RMAN

Reconstructing the contents of all or part of a database from a backup typically involves two phases. The first phase is the retrieval of a copy of the data file from the backups. The second involves reapplying changes to the file that occurred since the backup, using archived and online redo logs. To effectively administer an Oracle Database 11g database, recovery should be performed when critical or non-critical files are lost. Once you configure RMAN to perform recovery operations, it is important to have measures in place to monitor RMAN jobs. This course explains how to use RMAN to perform recovery operations, such as recovering a database from an incremental backup, switching to image copies for fast recovery, restoring a database to a new host, and using a backup control file for recovery and performing an automatic tablespace point-in-time recovery (TSPITR) are also covered. It also discusses how to monitor the progress of RMAN jobs, including how to interpret RMAN output such as messages and error stacks. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle Database 11g: Administration II (1Z0-053) exam.
  • perform a complete recovery using RMAN
  • identify alternatives to complete recovery
  • perform a tablespace point-in-time recovery
  • monitor RMAN progress
  • recognize the benefits of tuning RMAN
  • tune RMAN operations to prevent bottlenecks
  • configure RMAN to perform recoveries and monitored recovery operations

Oracle Database 11g Release 2: Database Diagnostics and Flashback Technologies

Administering an Oracle database requires monitoring and diagnosing data failures and recovering from them. Oracle Database 11g Release 2 provides the Data Recovery Advisor which eases this task by automatically detecting errors when they occur and providing repair advice. The use of the Automatic Diagnostic Repository can also be used, which holds diagnostic information about critical error events. Flashback technology can be used when a logical corruption occurs in the Oracle database and you need to recover data quickly and easily. With the use of a Flashback Table, you can recover a set of tables to a specific point in time without having to perform traditional point-in-time recovery operations. This course explains how to use the Data Recovery Advisor and how to set up Automatic Diagnostic Repository, how to use the Support Workbench, run health checks, as well as detect and repair database corruption within the Oracle Database 11g environment. This course discusses how to use the Oracle Flashback technologies, including Flashback query, table and transaction, as well as Flashback Data Archive. It also discusses how to restore items from the Recycle Bin and how to flash back a database using Flashback Database. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle Database 11g: Administration II (1Z0-053) exam.
  • use Data Recovery Advisor to detect, analyze, and repair database failures
  • handle block corruption in an Oracle Database
  • view diagnostic data
  • monitor the health of a database
  • use Flashback Query
  • use Flashback Table
  • use Flashback Transaction
  • use Flashback Data Archive
  • use the recycle bin to recover data
  • use Flashback Database
  • use Flashback Data Archive
  • use the recycle bin in Enterprise Manager
  • use Flashback Database

Oracle Database 11g Release 2: Managing Database Memory and Performance

Because there is a finite amount of memory available on a database server and on an Oracle Database 11g instance, you must pay attention to how memory is allocated. Also, database planning must include a balance between performance, cost, and reliability. You must consider the investment in the system architecture, which includes the hardware and software infrastructure needed to meet your requirements. This course explores the database's memory structures, focusing on how to configure SGA parameters and how to implement Automatic Memory Management and Automatic Shared Memory Management, and how to configure automatic PGA memory management. This course also explains how to monitor the performance of sessions and services, including how the Automatic Workload Repository (AWR) works, and how to use the SQL Tuning Advisor to identify and tune SQL statements that are using the most resources. This course also describes the benefits of Database Replay within your Oracle environment. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle Database 11g: Administration II (1Z0-053) exam.
  • identify the functions of different memory structures in Oracle Database 11g
  • implement Automatic Memory Management
  • implement Automatic Shared Memory Management
  • tune the Oracle Database 11g environment
  • manage the performance of sessions and services
  • use the SQL Tuning Advisor to manage the performance of SQL statements
  • use the SQL Access Advisor to manage the performance of SQL statements
  • use the SQL Performance Analyzer
  • manage memory issues in Oracle Database
  • manage database performance issues

Oracle Database 11g Release 2: Managing Database Resources and the Scheduler

By using the Database Resource Manager, you have more control over the allocation of machine resources than is normally possible through operating system resource management alone. Many tasks in the Oracle environment need job-scheduling capabilities. Using advanced Scheduler features, you can exercise more control over various aspects of scheduling, such as job windows and prioritizing jobs. This course explains how to configure the Database Resource Manager to access and create resource plans, create, configure, and administer consumer groups, as well as activate a resource plan and monitor the Resource Manager. This course also explores how to simplify management tasks by using the Scheduler to create, program, schedule, and monitor job execution as well as how to use a time-based or event-based schedule for executing Scheduler jobs. Incorporating advanced Scheduler concepts such as how to use the Scheduler to prioritize jobs is also covered. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle Database 11g: Administration II (1Z0-053) exam.
  • access and create resource plans and consumer groups using the Database Resource Manager
  • use resource plan directives to plan and monitor resource allocation to consumer groups
  • obtain Resource Manager information and monitor its functions
  • address system resource utilization and control using the Database Resource Manager
  • use the Scheduler to create, schedule, and monitor regular and lightweight jobs
  • distinguish between time-based and event-based schedules
  • perform advanced Scheduler administration
  • manage Scheduler jobs on remote systems
  • view Scheduler meta data

Oracle Database 11g Release 2: Managing Database Space and Duplication

To effectively manage space, you can configure automatic management by the Oracle database server. This allows you to generate alerts about potential problems and recommend possible solutions. This course explores how to use the Oracle database server for automatic space management, proactively monitor and manage tablespace space usage, and reclaim wasted space from tables and indexes by using the segment shrink functionality. Using the segment advisor, resumable space allocation, and moving tablespaces are also covered. This course will also explore how to duplicate a database using RMAN and Enterprise Manager. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle Database 11g: Administration II (1Z0-053) exam.
  • recognize how the Oracle server manages space
  • recognize how to use table compression to save space
  • recognize how to monitor space usage, shrink segments, and reclaim space
  • recognize the features of the Segment Advisor
  • identify how to manage and use resumable space
  • recognize how 4-KB sector disks are used in database storage
  • move large volumes of data between two Oracle Database 11g databases
  • manage storage in a database
  • recognize techniques for duplicating a database
  • recognize how to create a backup-based duplicate database using RMAN
  • use Enterprise Manager to clone a database
Register Now
Oracle Database 11g: Administration Workshop II Release 2 e-learning bundle
  • Course ID:
    271467
  • Duration:
    n/a
  • Price:
    $289