Tópicos do Exame 1Z0-048

Section I : RAC Administration

RAC Installation

[  ] Install and configure Automatic Storage Management (ASM)
[  ] Install the Oracle database software
[  ] Perform pre?database creation tasks

Database Creation

[  ] Install the Enterprise Manager agent on each cluster node
[  ] Create a cluster database
[  ] Perform post?database creation tasks

RAC DB Administration

[  ] Use Enterprise Manager cluster database pages
[  ] Define and manage redo log files in a RAC environment
[  ] Define and manage undo tablespaces in a RAC environment
[  ] Start and stop RAC databases and instances
[  ] Modify initialization parameters in a RAC environment
[  ] Create and manage ASM instances in a RAC environment
[  ] Create and manage ASM Disk Groups and ASM Files

Backup and Recover a RAC DB

[  ] Configure the RAC database to use ARCHIVELOG mode and the flash recovery area
[  ] Configure RMAN for the RAC environment
[  ] Explain the implications of OracleNet for connecting RMAN for parallel backups

RAC DB Monitoring and Tuning

[  ] Explain RAC-specific tuning considerations and techniques in an environment involving mixed workloads
[  ] Tune instance recovery in RAC
[  ] Determine RAC-specific wait events, global enqueues, and system statistics
[  ] Diagnose and improve common RAC-specific performance problems involving indexes, sequences and undo
[  ] Use the Cluster Database Performance pages
[  ] Use the Automatic Workload Repository (AWR) in RAC
[  ] Use Automatic Database Diagnostic Monitor (ADDM) in RAC

Services

[  ] Configure and manage services in a RAC environment
[  ] Connect your client to a RAC database using services
[  ] 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
[  ] Use the Load Balancing Advisory (LBA)
[  ] Describe the uses of Fast Application Notification
[  ] Describe the uses of server-side callouts
[  ] Describe the purposes of server- and client-side ONS
[  ] Configure Transparent Application Failover (TAF)

Design for HA

[  ] Design a Maximum Availability Architecture in your environment
[  ] Determine the best RAC and Data Guard topologies for your environment
[  ] Explain Data Guard Broker configuration files in a RAC environment
[  ] Decide on the best ASM configuration to use
[  ] Patch your RAC system in a rolling fashion

RAC Technology Overview

[  ] Recommend appropriate use and possible application of RAC technology to address scalability, high availability and grid provisioning requirements

Section II : Cluster Management

Oracle Clusterware Installation

[  ] Describe the capabilities and features of Oracle Clusterware
[  ] Perform preinstallation and cluster setup tasks
[  ] Install Oracle Clusterware
[  ] Describe the different storage options and their implications (OCFS, raw disks, ASM)

Oracle Clusterware Administration

[  ] Manually control the Oracle Clusterware stack
[  ] Change voting disk configuration
[  ] Back up and recover your voting disks
[  ] Manually back up and recover the OCR, and repair the OCR configuration
[  ] Explain application VIPs and change VIP addresses
[  ] Use Clusterware to protect non-Oracle applications
[  ] Prevent automatic instance restarts

Diagnosing the Oracle Clusterware components

[  ] Enable and collect diagnostics for Oracle Clusterware
[  ] Set debugging flags for OCR-related tools
[  ] Enable Oracle Clusterware debugging
[  ] Enable tracing for Java-based tools
[  ] Use Cluster Verify

Node Addition and Removal

[  ] Add a new node to your cluster database
[  ] Remove a node from your cluster database

Red Hat
Oracle
SAP
Furukawa
Prometric