11g_OCM提纲

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:11GOCM

 Notes about the exam

    Exam participants work through nine skillsets that are based on the exam objectives.
    Tasks can be performed using CLI or GUI environment and tools when available

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)

To prepare for the OCM exam, candidates should focus on mastering the tasks for each Skillset. Software can be downloaded from the Oracle Technology Network (OTN) to build a practice environment.  Use the latest software available from OTN; it is not necessary to build a practice environment on the exact OS and database software versions used in the OCM exam.  Later releases of Oracle server support nearly all features and functions of earlier ones; for any software version, relevant parameter values, naming differences and obsolete features may be found in the product documentation, which is available from OTN.
It is also recommended that candidates practice on the type of keyboard that they expect to find in OCM Test Center.

    All countries, except those listed will use country-specific keyboards

        United States, Canada, United Kingdom, Netherlands, Greece, Croatia, Italy, Poland, Romania, Slovak Republic, Egypt, Israel, United Arab Emirates, Saudi Arabia, South Africa, Hong Kong, Indonesia, India, Malaysia, Philippines, Singapore, Thailand, Vietnam, Australia, New Zealand.

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 partitioned 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