OCM Preparation - 1

Exam Environment

• Oracle Linux Release 5.4 (32-bit)
• Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 (32-bit)
• Oracle Enterprise Manager 11g Grid Control Release 1 (11.1.0.1.0)  (32-bit)
• Non-Searchable Documentation

Exam Topics

Server Configuration

• Create the database
• Determine and set sizing parameters for database structures
• Create and manage temporary, permanent, and undo tablespaces
• Stripe data files across multiple physical devices and locations
• Configure the database environment to support optimal data access performance
• Create and manage database configuration files
• Create and manage bigfile tablespaces
• Create and Manage a tablespace that uses NFS mounted file system file  
• Create and manage multiple network configuration files
• Create and configure a listener
• Configure the database instance to support shared server connections
• Set up network tracing
• Manage Oracle network processes  
• Configure the network environment to allow connections to multiple databases
• Use configurationless connections
• Use OPatch to install a patch
• Use Grid Infrastructure to manage oracle databases and other resources
• Use Enterprise Manager Configuration Assistant(EMCA) utility

Enterprise Manager Grid Control

• Install and Patch Enterprise Manager Grid Control software
• Configure the Enterprise Manager repository
• Create Enterprise Manager Grid Control users
• Use Enterprise Manager to modify a database configuration
• Configure Enterprise Manager to modify database availability
• Create and manage jobs
• Create and monitor alerts
• Create notifications
• Implement Grid Control and Database Control
• Choose the appropriate tablespace type for the intended use
• Create Scheduler jobs
• Create schedules
• Assign jobs to windows
• Create programs
• Create job classes
• Install the Enterprise Manager Grid Control infrastructure
• Deploy Enterprise Manager Grid Control agents
• Configure Grid Control for business requirements

Managing Database Availability

• Mantain recovery catalogs
• Configure Recovery Manager
• Use Recovery Manager to perform database backups
• Use Recover Manager to perform complete database restore and recovery operations
• Configure RMAN
• Create different types of RMAN backups to cater for different performance and retention requirements
• Set Flashback Database parameters
• Configure a Fast Recovery Area
• Perform various recovery operations using Flashback technology

Data Management

• Manage Materialized Views to improve rewrite and refresh performance
• Configure and manage distributed materialized views
• Create and Manage encrypted tablespaces
• Manage Transport of tablespaces across platforms
• Configure a schema to support a star transformation query
• Administer external tables
• Implement Data Pump export and import jobs for data transfer
• Implement Data Pump to and from remote databases  
• Configure and use parallel execution for queries
• Use SQL*Loader
• Administer, manage and tune parallel execution

Data Warehouse Management  

• Administer partitioned tables and indexes using appropriate methods and keys 
• Perform partition maintenance operations  
• Maintain indexes on a pa rtitioned table
• Implement securefile LOB
• Create and manage LOB segments  
• Implement fine-grained access control  
• Create and manage contexts
• Administer flashback data archive and schema evolution

Performance Management  

• Administer Resource Manager 
• Use Result Cache 
• Use multi column statistics 
• Gather statistics on a specific table without invalidating cursors 
• Use partitioned indexes 
• Administer and tune schema object to support various access methods 
• Interpret execution plan  
• Use SQL tuning tools and features 
• Use SQL Tuning Advisor 
• Use SQL Access Advisor 
• Use SQL Performance Analyzer
• Configure baseline templates  
• Use SQL Plan Management feature
• Implement instance caging 

Grid Infrastructure and ASM

• Install Oracle Grid Infrastructure 
• Create ASM Disk Groups 
• Create and manage as ASM instance
• Implement ASM failure groups
• Creating ACFS File System   
• Start, stop, configure and administer Oracle Grid Infrastructure

Real Application Clusters  

• Install the Oracle Database 11gR2 software
• Configure ASM for the shared disks and create a clustered database   
• Configure archiving  
• Configure services using both Manual and Policy Managed methods 

Data Guard  

• Create Physical Standby Database with real-time apply. 
• Configure the data guard environment to reduce overheads of fast incremental backups on the primary database 
• Configure the Observer 
• Switchover and switch back  
• Configure connect time failover
• Convert the standby to a snapshot standby 
• Configure archivelog deletion policy for the Dataguard configuration

This will be used as the base documentation for this series, hereafter.