Oracle Database 11g: Administration Workshop II
About This Course
This course is offered as an e-Learning course and is comprised
of nine (9) modules.
Target Audience
Database Administrators, Database Designers, Developer Support
Engineers, and Technical Administrators.
Course Outline
Module 1: Oracle Database 11g: Database Architecture and
ASM
Overview/Description
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.
Lesson Objectives
Oracle Database 11g: Database
Architecture and ASM
- identify the characteristics of elements of the Oracle Database
11g architecture.
- recognize the steps for managing database files using Automatic
Storage Management (ASM) and disk groups.
- identify ways to manage disk groups and their attributes and
also configure and manage ASM instances.
- recognize the steps for managing ASM storage, scalability, and
performance using the ALTER command and also the ASMCMD
utility.
- reate an ASM instance and disk group and use the ASMCMD to view
disk group data.
Module 2: Oracle Database 11g: Configuring for
Recovery
Overview/Description
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.
Lesson Objectives
Oracle Database 11g: Configuring for
Recovery
- identify the benefits of Oracle Database 11g's backup and
recovery functionality.
- recognize the steps for configuring a database for backup.
- recognize the steps for configuring the Flash Recovery
Area.
- recognize the steps for creating an RMAN recovery catalog and
using it to store database backups.
- identify the steps for resynchronizing a recovery catalog,
using RMAN stored scripts, and backing up a recovery catalog.
- create and configure a recovery catalog and register a database
in the recovery catalog in a given scenario.
Module 3: Oracle Database 11g: Configuring for
Backups
Overview/Description
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.
Lesson Objectives
Oracle Database 11g: Configuring for
Backups
- recognize the steps for preparing and optimizing a database for
a backup.
- recognize the steps for creating fast incremental backup and
duplex backup sets using RMAN.
- recognize the steps for creating archival and multisection
backups and also for compressing and encrypting backups using
RMAN.
- recognize the steps for backing up to sequential media, such as
tape drives, and for using reports and views to monitor
backups.
- 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.
- recognize the steps involved in a complete and an incomplete
recovery, and identify the steps for performing a user-managed
backup.
- recognize the steps for performing different types of
user-managed recoveries.
- back up a database and recover a lost online redo log file in a
given scenario.
Module 4: Oracle Database 11g: Using RMAN for
Recovery
Overview/Description
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.
Lesson Objectives
Oracle Database 11g: Using RMAN for
Recovery
- identify the steps for performing a complete recovery using
RMAN.
- recognize the steps for using RMAN to perform an incomplete
recovery, restore a database to a new host, and perform a disaster
recovery.
- identify the steps for using RMAN to recover a database in a
given scenario.
- recognize the steps for creating a duplicate database using
RMAN and Enterprise Manager.
- recognize the steps for performing a tablespace point-in-time
recovery (TSPITR).
- clone a database and complete a tablespace point-in-time
recovery (TSPITR) in a given scenario.
Module 5: Oracle Database 11g: Supporting RMAN and Using
Flashback Technology
Overview/Description
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.
Lesson Objectives
Oracle Database 11g: Supporting RMAN and Using Flashback
Technology
- recognize the steps for monitoring
RMAN.
- recognize the benefits of RMAN backup and restore operations in
terms of performing RMAN tuning operations, such as
multiplexing.
- identify the steps for performing RMAN tuning operations.
- recognize the steps for enabling flashback features and for
using the recycle bin in Oracle Database 11g.
- recognize the steps for using flashback to query data, retrieve
versions of rows, view changes made at the transaction level, and
reverse a transaction.
- use flashback to reverse a transaction in a given
scenario.
- 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.
- identify the steps for using guaranteed restore points, for
monitoring Flashback Database, and for tracking and archiving data
with Flashback Data Archive.
Module 6: Oracle Database 11g: Diagnosing the Database
and Managing Memory
Overview/Description
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.
Lesson Objectives
Oracle Database 11g: Diagnosing the Database and
Managing Memory
- identify the steps for viewing diagnostic data and incidents
associated with a database problem via Automatic Diagnostic
Repository and Support Workbench.
- 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.
- recognize the steps for handling block corruption and for
detecting, analyzing, and repairing failures with the help of Data
Recovery Advisor.
- identify the functions of different memory structures in Oracle
Database 11g.
- recognize the steps for enabling and monitoring automatic
memory management (AMM) and for enabling, configuring, and
disabling automatic shared memory management (ASMM).
- 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.
- enable automatic memory management and view automatic memory
settings in a given scenario.
Module 7: Oracle Database 11g: Database Performance and
Space Management
Overview/Description
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.
Lesson Objectives
Oracle Database 11g: Database Performance and Space
Management
- identify the tuning steps required to establish the Oracle
Database 11g environment.
- identify the steps for monitoring and managing session
performance using Enterprise Manager, views, Automatic Workload
Repository (AWR) statistics, and SQL advisors.
- recognize the steps for using the SQL Tuning Advisor and SQL
Access Advisors to analyze SQL statements and improve data
retrieval.
- recognize the general steps required to capture a production
workload and replay it in a test environment, using the Database
Replay feature.
- identify a high load SQL statement and then tune it using the
SQL Tuning Advisor.
- recognize the steps for generally managing and monitoring space
in Oracle Database 11g.
- recognize the steps for shrinking segments and reclaiming
available space using the Segment Advisor and resumable
statements.
- identify the steps for moving large volumes of data between two
Oracle Database 11g databases, using transportable
tablespaces.
Module 8: Oracle Database 11g: Managing Resources and
Task Automation
Overview/Description
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.
Lesson Objectives
Oracle Database 11g: Managing Resources and Task
Automation
- identify the steps for accessing and creating resource plans
and consumer groups using the Database Resource Manager.
- identify the steps for planning and monitoring resource
allocation to consumer groups, using resource plan directives.
- use the Database Resource Manager to address system resource
utilization and control in a given scenario.
- recognize the steps for using the Scheduler to create, schedule
and monitor regular and lightweight jobs.
- distinguish between time-based and event-based schedules for
executing jobs and job chains using the Scheduler.
- recognize the steps for performing advanced Scheduler
administration to manage job windows, prioritize jobs, and make the
best use of resources
Module 9: Oracle Database 11g:
Globalization
Overview/Description
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.
Lesson Objectives
Oracle Database 11g: Globalization
- identify the steps for selecting the database character set
that meets your needs and for specifying language-dependent
behavior.
- recognize the steps for performing and customizing linguistic
searches and sorts.
- identify the steps for performing multiple character set
conversions, and for scanning an unknown file set to determine its
language.
- modify language, date, and time formats for a session and
perform a linguistic sort in a given scenario