Monday, May 27, 2013

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.

No comments:

Post a Comment