Font size:

Description:

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

Course Price
Oracle Database 11g: Database Architecture and ASM $74.95
Oracle Database 11g: Configuring for Recovery $74.95
Oracle Database 11g: Configuring for Backups $74.95
Oracle Database 11g: Using RMAN for Recovery $74.95
Oracle Database 11g: Supporting RMAN and Using Flashback Technology $74.95
Oracle Database 11g: Diagnosing the Database and Managing Memory $74.95
Oracle Database 11g: Database Performance and Space Management $74.95
Oracle Database 11g: Managing Resources and Task Automation $74.95
Oracle Database 11g: Globalization $74.95

Bundle Price: $319.00
Total Savings: $355.55


Oracle Database 11g: Database Architecture and ASM

To recognize the structural elements in Oracle Database 11g's architecture, including and Automatic Storage Management (ASM), and recognize the steps for managing storage using disk groups.
  • Oracle Database 11g Architecture - identify the characteristics of elements of the Oracle Database 11g architecture.
  • ASM and Disk Groups Overview - recognize the steps for managing database files using Automatic Storage Management (ASM) and disk groups.
  • Managing Disk Groups - identify ways to manage disk groups and their attributes and also configure and manage ASM instances.
  • ASM Storage - recognize the steps for managing ASM storage, scalability, and performance using the ALTER command and also the ASMCMD utility.
  • Creating an ASM Instance and Disk Groups - create an ASM instance and disk group and use the ASMCMD to view disk group data.

Oracle Database 11g: Configuring for Recovery

To recognize the steps for configuring all aspects of backup and recovery functionality in Oracle Database 11g, using ARCHIVELOG mode, retention policies, a Flash Recovery Area, and an RMAN recovery catalog.
  • Backup and Recovery Functionality - identify the benefits of Oracle Database 11g's backup and recovery functionality.
  • Configuring for Backup Operations - recognize the steps for configuring a database for backup.
  • Configuring for Recovery Operations - recognize the steps for configuring the Flash Recovery Area.
  • RMAN Recovery Overview - recognize the steps for creating an RMAN recovery catalog and using it to store database backups.
  • Manipulating a Recovery Catalog - identify the steps for resynchronizing a recovery catalog, using RMAN stored scripts, and backing up a recovery catalog.
  • Configuring a Recovery Catalog - create and configure a recovery catalog and register a database in the recovery catalog in a given scenario.

Oracle Database 11g: Configuring for Backups

To identify the steps for preparing a database for backup and then for performing various types of RMAN backups and monitoring them using reports and dynamic performance views, and also for performing user-managed backups and recoveries.
  • Configuring Backup Specifications - recognize the steps for preparing and optimizing a database for a backup.
  • Creating RMAN Backups - recognize the steps for creating fast incremental backup and duplex backup sets using RMAN.
  • Archival and Multisection Backups - recognize the steps for creating archival and multisection backups and also for compressing and encrypting backups using RMAN.
  • Media Manager and Backup Monitoring - recognize the steps for backing up to sequential media, such as tape drives, and for using reports and views to monitor backups.
  • Restoring and Recovering Files - identify the different types of file loss that can occur and the steps for restoring the files and recovering the database in a given scenario.
  • User-Managed Backups - recognize the steps involved in a complete and an incomplete recovery, and identify the steps for performing a user-managed backup.
  • Performing User-Managed Recoveries - recognize the steps for performing different types of user-managed recoveries.
  • Backing Up and Restoring - back up a database and recover a lost online redo log file in a given scenario.

Oracle Database 11g: Using RMAN for Recovery

To identify ways to use RMAN to ensure that data is not lost in Oracle Database 11g, by performing complete and incomplete recoveries as well as disaster recoveries, by cloning databases, and by restoring a tablespace to a particular point in time.
  • Complete Recoveries - identify the steps for performing a complete recovery using RMAN.
  • Other RMAN Recoveries - recognize the steps for using RMAN to perform an incomplete recovery, restore a database to a new host, and perform a disaster recovery.
  • Performing Recoveries with RMAN - identify the steps for using RMAN to recover a database in a given scenario.
  • Cloning a Database - recognize the steps for creating a duplicate database using RMAN and Enterprise Manager.
  • Tablespace Point-in-Time Recovery - recognize the steps for performing a tablespace point-in-time recovery (TSPITR).
  • Cloning and Recovering a Database - clone a database and complete a tablespace point-in-time recovery (TSPITR) in a given scenario.

Oracle Database 11g: Supporting RMAN and Using Flashback Technology

To recognize the steps for making sure that you can recover data quickly by tuning RMAN to avoid bottlenecks, and also for making sure that any changes to a database can be easily reversed, if necessary, using Oracle Database 11g's flashback features.
  • Monitoring RMAN - recognize the steps for monitoring RMAN.
  • Overview of Tuning RMAN - recognize the benefits of RMAN backup and restore operations in terms of performing RMAN tuning operations, such as multiplexing.
  • Tuning RMAN - identify the steps for performing RMAN tuning operations.
  • Flashback and the Recycle Bin - recognize the steps for enabling flashback features and for using the recycle bin in Oracle Database 11g.
  • Flashback Technology in Use - recognize the steps for using flashback to query data, retrieve versions of rows, view changes made at the transaction level, and reverse a transaction.
  • Flashing Back a Transaction - use flashback to reverse a transaction in a given scenario.
  • Flashing Back Tables and Databases - recognize the steps for recovering a set of tables or an entire database to a specific point in time, using Flashback Tables and Flashback Database.
  • Monitoring and Archiving with Flashback - identify the steps for using guaranteed restore points, for monitoring Flashback Database, and for tracking and archiving data with Flashback Data Archive.

Oracle Database 11g: Diagnosing the Database and Managing Memory

To identify the steps for diagnosing and repairing database problems with the help of Oracle Support using Automatic Diagnostic Repository, Support Workbench, and health checks, and also for enabling and configuring automatic memory management and automatic shared memory management.
  • Diagnosing Database Issues - identify the steps for viewing diagnostic data and incidents associated with a database problem via Automatic Diagnostic Repository and Support Workbench.
  • Incident Reporting and Health Monitoring - identify the steps for creating a service request (SR) for an incident and packaging and uploading the associated diagnostic data to Oracle Support, and also for monitoring your database's health.
  • Block Corruption and Data Recovery Advisor - recognize the steps for handling block corruption and for detecting, analyzing, and repairing failures with the help of Data Recovery Advisor.
  • Overview of Memory Management - identify the functions of different memory structures in Oracle Database 11g.
  • Automatic Memory Management - recognize the steps for enabling and monitoring automatic memory management (AMM) and for enabling, configuring, and disabling automatic shared memory management (ASMM).
  • Program Global Area and Memory Usage - identify the steps for controlling automatic memory management in the PGA and for sizing the SGA and PGA, and recognize the guidelines for efficient memory usage.
  • Using Automatic Memory Management - enable automatic memory management and view automatic memory settings in a given scenario.

Oracle Database 11g: Database Performance and Space Management

To identify the steps for making sure your Oracle Database 11g database is performing well and has adequate space, by monitoring statistics, tuning SQL, testing workloads, managing space, and transporting tablespaces.
  • Planning and Tuning Activities - identify the tuning steps required to establish the Oracle Database 11g environment.
  • Performance Monitoring and Management - identify the steps for monitoring and managing session performance using Enterprise Manager, views, Automatic Workload Repository (AWR) statistics, and SQL advisors.
  • SQL Tuning and Access Advisors - recognize the steps for using the SQL Tuning Advisor and SQL Access Advisors to analyze SQL statements and improve data retrieval.
  • Using Database Replay - recognize the general steps required to capture a production workload and replay it in a test environment, using the Database Replay feature.
  • Tuning a SQL Statement - identify a high load SQL statement and then tune it using the SQL Tuning Advisor.
  • Managing and Monitoring Space - recognize the steps for generally managing and monitoring space in Oracle Database 11g.
  • Reclaiming Space - recognize the steps for shrinking segments and reclaiming available space using the Segment Advisor and resumable statements.
  • Transportable Tablespaces - identify the steps for moving large volumes of data between two Oracle Database 11g databases, using transportable tablespaces.

Oracle Database 11g: Managing Resources and Task Automation

To identify ways to ensure that resources are being put to best use and database jobs are performed when they should be, using the Database Resource Manager and the Scheduler.
  • Resource Plans and Groups - identify the steps for accessing and creating resource plans and consumer groups using the Database Resource Manager.
  • Resource Plan Directives - identify the steps for planning and monitoring resource allocation to consumer groups, using resource plan directives.
  • Managing Resources - use the Database Resource Manager to address system resource utilization and control in a given scenario.
  • The Task Scheduler - recognize the steps for using the Scheduler to create, schedule and monitor regular and lightweight jobs.
  • Time and Event Based Jobs - distinguish between time-based and event-based schedules for executing jobs and job chains using the Scheduler.
  • Administering the Scheduler - recognize the steps for performing advanced Scheduler administration to manage job windows, prioritize jobs, and make the best use of resources.

Oracle Database 11g: Globalization

To recognize the steps for utilizing Oracle Database 11g's globalization support features to ensure that information and data is displayed in a user's native language, and that territory and language-dependent conventions are adhered to.
  • Selecting a Character Set - identify the steps for selecting the database character set that meets your needs and for specifying language-dependent behavior.
  • Linguistic Searching and Sorting - recognize the steps for performing and customizing linguistic searches and sorts.
  • Conversions and Scans - identify the steps for performing multiple character set conversions, and for scanning an unknown file set to determine its language.
  • Using Globalization Support - modify language, date, and time formats for a session and perform a linguistic sort in a given scenario.
Register Now
Oracle Database 11g: Administration Workshop II e-learning bundle
  • Course ID:
    271466
  • Duration:
    n/a
  • Price:
    $319