|
Audience:
Database Administrators
Prerequisites:
Required Prerequisites:
Oracle Database 10g: New Features
for Administrators
Oracle Database 10g:
Administration Workshop I
Course
Objectives:
Identify Real Application Clusters
components
Install, create,
administer, and monitor a Real Application Clusters database
Use configuration and
management tools for Real Application Clusters databases
Migrate your database
storage to Automatic Storage Management
Setup services for
workloads management, and applications high availability
Develop a backup and
recovery strategy for Real Application Clusters databases
Review high
availability best practices
Course
Topics:
Introduction
Define a cluster
Define Oracle Real
Application Clusters
List the advantages of
using RAC
Define scalability
High availability and
RAC
Architecture and Concepts
List the various components of Cluster
Ready Services (CRS) and Real Application Clusters (RAC)
Describe the various
types of files used by a RAC database
Describe the various
techniques used to share database files across a cluster
Describe the purpose of
using services with RAC
RAC Installation and Configuration Part I
Outline Oracle 10g RAC Installation
Preinstallation Tasks
Cluster Setup Tasks
Installing OCFS
Installing Cluster
Ready Services
RAC Installation and Configuration Part II
Install Database Software
Launching VIPCA with
root.sh
Database Precreation
Tasks
Creating the Cluster
Database
Database
Postinstallation Tasks
Administering
Enterprise Manager Jobs in Real Application Clusters
Node Addition and
Deletion and the SYSAUX Tablespace
AWR snapshots in RAC
RAC Database Instances Administration
Understand the EM Cluster Database Home
Page
Starting and Stopping
RAC Instances
RAC Initialization
Parameter Files
Adding a Node to a
Cluster
Deleting Instances from
a RAC Database
Quiescing RAC Databases
Administering Alerts
with Enterprise Manager
Administering Storage in RAC Part I
Describe automatic storage management (ASM)
Install the ASM
software
Set up initialization
parameter files for ASM and database instances
Start up and shut down
ASM instances
Add ASM instances to
the target list of Database Control
Use Database Control to
administer ASM in a RAC environment
Administering Storage in RAC Part II
Manage redo log groups in a RAC
environment
Manage undo tablespaces
in a RAC environment
Use SRVCTL to manage
ASM instances
Migrate database files
to ASM
Manage and recover the
OCR file and voting disk
Services
Configure and manage services in a RAC
environment
Use services with
client applications
Use services with the
Database Resource Manager
Use services with the
Scheduler
Set performance-metric
thresholds on services
Configure services
aggregation and tracing
High Availability of Connections
Configure client side connect-time load
balancing
Configure client side
connect-time failover
Configure server side
connect-time load balancing
Benefit from Fast
Application Notification (FAN)
Configure server-side
callouts
Configure the server
and client-side ONS
Configure Transparent
Application Failover (TAF)
Managing Backup and Recovery in RAC
Configure RAC Recovery Settings with EM
Configure RAC Backup
Settings with EM
Initiate Archiving
Configuring RMAN
RAC Backup and Recovery
Using EM
RAC Performance Tuning
Determine RAC specific tuning components
Tune instance recovery
in RAC
Determine RAC specific
wait events, global enqueues, and system statistics
Implement most common
RAC tuning tips
Use the Cluster
Database Performance pages
Use Automatic Workload
Repository and Automatic Database Diagnostic Monitor in RAC
Design for High Availability
Design a Maximum Availability
Architecture in your environment
Determine the best RAC
and Data Guard topologies for your environment
Configure the Data
Guard Broker configuration files in a RAC environment
Patch your RAC system
in a rolling fashion
|
