OCM大师认证全面解析及经验分享 - 侯圣文（secooler）

Size: px

Start display at page:

Download "OCM大师认证全面解析及经验分享 - 侯圣文（secooler）"

江黯别
5 years ago
Views:

1 11g OCM 大师认证全面解析及经验分享挑战自我, 提升价值!

2 个人介绍 Oracle DBA 成功之路 Oracle 认证体系介绍 OCM 考试条件及其要求 OCM 考点解析及考试范围概述考试技巧心得及考场经验分享

com) 创始人 ACOUG 成员 ITPUB 论坛资深版主 DataGuru 专家团成员个人技术

3 个人介绍姓名 : 侯圣文网络 ID:Secooler 北京大学理学硕士 Oracle ACE 总监获 Oracle OCM 认证 OCM 联盟 ( 创始人恩墨学院 ( 创始人 ACOUG 成员 ITPUB 论坛资深版主 DataGuru 专家团成员个人技术 Blog: 微博 : 电话 :

4 个人介绍 Oracle DBA 成功之路 Oracle 认证体系介绍 OCM 考试条件及其要求 OCM 考点解析及考试范围概述考试技巧心得及考场经验分享

5 Oracle DBA 成功之路将会得到的享受阳光与咖啡高薪水受尊敬需要承受的挫折心酸压力随时待命从容应对第一份 DBA 工作融入到 DBA 圈子中 ; 寻找一位良师初级 DBA 晋级为中级 DBA 创建自己的资料库 ; 参与技术讨论中级 DBA 晋级为高级 DBA 阅读官方文档 ; 成为某一领域专家 ; 撰写技术文章 DBA 四条守则 1. 备份重于一切 ;2. 三思后行 ;3.rm 是危险的 ;4. 指定规范

6 个人介绍 Oracle DBA 成功之路 Oracle 认证体系介绍 OCM 考试条件及其要求 OCM 考点解析及考试范围概述考试技巧心得及考场经验分享

7 Oracle 认证体系介绍 OCM 含金量最高业界公认专家身份的象征 OCP 值得信赖知识完备 OCA 低级别认证具备基本技能

8 个人介绍 Oracle DBA 成功之路 Oracle 认证体系介绍 OCM 考试条件及其要求 OCM 考点解析及考试范围概述考试技巧心得及考场经验分享

9 OCM 考试条件及其要求获得 OCP 认证参加云和恩墨的培训 ( 可选三门 ) 或参加 1 门 OU 培训课程通过三门笔试 ( 选择题 ) DBA 经验积累要求至少 5 年一线 DBA 工作经验能够熟练处理数据库故障经验重于一切获得 OCM 认证参加云和恩墨 OCM 培训或参加 2 门 OU 的 OCM 培训课程参加 OU 为期两天的 OCM 实战上机考试

10 10g OCM 认证获取路径方法直接考取路径 10g OCP( 三门选择题笔试 ) 10g OCM( 两天上机直接考试 ) 升级路径 9i OCP 10g OCP( 一门升级选择题笔试 ) 10g OCM( 两天上机直接考试 ) 10g OCP 10g OCM( 两天上机考试 ) 11g OCP 10g OCM( 两天上机考试 )

11 11g OCM 认证获取路径方法直接考取路径 11g OCP( 三门选择题笔试 ) 11g OCM( 两天上机直接考试 ) 升级路径 9i OCP 11g OCP( 一门升级选择题笔试 ) 11g OCM( 两天上机直接考试 ) 9i OCP 10g OCP( 一门升级选择题笔试 ) 10g OCM( 两天上机直接考试 ) 11g OCM( 一天上机升级考试 ) 10g OCP 11g OCP( 一门升级选择题笔试 ) 11g OCM( 两天上机直接考试 ) 10g OCP 10g OCM( 两天上机考试 ) 11g OCM( 一天上机升级考试 ) 此路径将获得 4 个认证证书 : 10g OCP 11g OCP( 赠送 ) 10g OCM 11g OCM 10g OCP 10g OCM( 两天上机考试 ) 11g OCM( 两天上机直接考试 ) 11g OCP 10g OCM( 两天上机考试 ) 11g OCM( 一天上机升级考试 ) 11g OCP 10g OCM( 两天上机考试 ) 11g OCM( 两天上机直接考试 )

12 个人介绍 Oracle DBA 成功之路 Oracle 认证体系介绍 OCM 考试条件及其要求 OCM 考点解析及考试范围概述考试技巧心得及考场经验分享

13 11g OCM 考场环境介绍熟悉考场环境 Check: 电源网络键盘鼠标主机配置信息设备环境每位考生 4 套环境和一套共享设备奇数机偶数机 RAC 的两个节点 RAC 环境通过 ssh 或 vncview 方式访问考生不能互相访问对方数据考试期间不可提前离开考场 ( 提前交卷除外 ) 每个场景结束后由考官采集成绩交评分组审批审评制度出成绩周期较长,4 到 6 周, 历史最快 3 天!

14 11g OCM 考试形式及考试范围概述 11g OCM 直接考试 : 两天上机考试 11g OCM 升级考试 : 一天上机考试 11g OCM 直接考试大纲 Oracle Database 11g Certified Master Exam 1GOCM&p_org_id=&lang= 11g OCM 升级考试大纲 Oracle Database 11g Certified Master Upgrade Exam 1GOCMU&p_org_id=&lang=

15 11g OCM 两天直接考大纲解析 1.Server Configuration 2.Enterprise Manager Grid Control 3.Managing Database Availability 4.Data Management 5.Data Warehouse Management 6.Performance Management 7.Grid Infrastructure and ASM 8.Real Application Clusters 9.Data Guard

16 11g OCM 两天直接考大纲解析 1.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

17 11g OCM 两天直接考大纲解析 2.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

18 11g OCM 两天直接考大纲解析 3.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

19 11g OCM 两天直接考大纲解析 4.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

20 11g OCM 两天直接考大纲解析 5.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

21 11g OCM 两天直接考大纲解析 6.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

22 11g OCM 两天直接考大纲解析 7.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 8.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

23 11g OCM 两天直接考大纲解析 9.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

24 11g OCM 一天升级考大纲解析 1.Database, RMAN, EM and Network Configuration 2.Data Guard 3.Data and Data Warehouse Management 4.Performance Management

25 11g OCM 一天升级考大纲解析 1.Database, RMAN, EM and Network Configuration Configure server-side network Configure client-side network Create and Manage encrypted tablespaces Create and Manage a tablespace that uses NFS mounted file system file Set up ADR file based repository Perform cold database backup Manage user accounts and use case sensitive passwords Use OPatch to install a patch Install and configure EM Agent Create Base Recovery Catalog Configure RMAN Perform multisection backup of a datafile Create an Archival Backup

26 11g OCM 一天升级考大纲解析 2. 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 Convert the standby to a snapshot standby Configure archivelog deletion policy for the dataguard configuration

27 11g OCM 一天升级考大纲解析 3. Data and Data Warehouse Management Troubleshoot fast materialized views to fast refresh and query rewrite Add a tablespace by using Transportable Tablespace Feature of Data Pump Import (cross platform transportable tablespace) Configure a schema to support a star transformation query Configure and use parallel execution for queries Use and access SecureFile LOBS Create partitioned tables (includes reference and interval partitioning) Configure Flashback Data Archive Use Oracle Streams to capture and propagate changes in a table

28 11g OCM 一天升级考大纲解析 4. Performance Management Set up and configure Resource Manager to control active sessions, number of I/Os, execution time..etc Use Result Cache Use multi column statistics Gather statistics on a specific table without invalidating cursors Use partitioned indexes Use SQL Tuning Advisor Use SQL Access Advisor Configure baseline templates Use SQL Plan Management feature Replay a captured workload

29 个人介绍 Oracle DBA 成功之路 Oracle 认证体系介绍 OCM 考试条件及其要求 OCM 考点解析及考试范围概述考试技巧心得及考场经验分享

30 OCM 考试技巧与心得 OCM 考试技巧知识点烂熟于胸, 做到下意识操作熟练使用官方文档不参考任何文档充分利用所有时间, 熟练使用 vi 和 SQL*Plus 工具 OCM 考试心得只有平时多流汗, 才能战时少流血! -OCM 备考箴言对 Oracle 原理通透理解故障处理思路要清晰做好充分有效的备份确保每场分数可采集

31 考试现场经验分享 11g OCM 考试难度大, 需要大量上机训练! 对操作熟练度要求极高 : 时间短, 任务重考试范围广你必须对每一个知识点都有非常丰富的实际操作经验! 设备故障极有可能遭遇环境问题, 有备无患! 考试过程是结交 Oracle 界高手的绝好机会 Good luck!

33 百名 OCM 大师合影留念温暖的大家庭

34 ENMO_OCM 西点军校欢迎您

个人介绍 Oracle DBA 成功之路 Oracle 认证体系介绍 OCM 考试条件及其要求 OCM 考点解析及考试范围概述考试技巧心得及考场经验分享

10g OCM 大师认证全面解析及经验分享挑战自我, 提升价值! 崔旭 @dbstyle 个人介绍 Oracle DBA 成功之路 Oracle 认证体系介绍 OCM 考试条件及其要求 OCM 考点解析及考试范围概述考试技巧心得及考场经验分享个人介绍姓名 : 崔旭网络 ID:dbstyle 获 Oracle OCM 认证 OCM 联盟核心成员个人技术 Blog:http://www.dbstyle.net