Oracle OCM Oracle Certified Master
In order to facilitate learning Oracle for beginners, the following will be updated according to this directory OCM related information, enjoy the attention. (Purely individual learning to organize, not for commercial use.) )
(1) Oracle database Software Installation deployment and upgrade
1, OCM Examination Introduction and course Introduction
Introduction to the OCM exam process
Introduction to OCM Exam syllabus
Introduction to the course arrangement
2. Install and upgrade database software
Installing VMware10
Install and deploy Oracle linux5.4
Install Deployment oracle11.2.0.3.0
Distinguishing PSU/CPU/SPU
Upgrade Oracle to 11.2.0.3.14
Create a database manually
3, Sql/plus tool use
Execute SQL Script
Using the Edit command
Using the spool directive
Formatted column display
Using Set Directives
Use the change, list, input, append directives
Saving SQL in Sqlbuffer to a file
Show Sqlplus Help
Displays the value of the Sqlplus system environment variable.
(2) Oracle database management and configuration
1. Oracle Database Design
Consider the logical design of the database
How and how many databases are created
Where data files and log files are stored
2. Oracle Database Planning
Hardware capacity Planning: Planning for disk space, CPU, I/O, etc.
Software Planning: Operating system Installation and configuration, database planning, database object content, and volume planning
Network planning: Network hardware, network software and protocols, network customer traffic and publishing, network topology and other rules.
Planning of databases based on short, medium, long-term and future business development
3. Oracle Table Space Detailed
Table Space Operations and management
rowID detailed configuration of large file table spaces
rowID detailed
Use manual and automatic management of table spaces
Create and manage table spaces for NFS file management
Explain undo
Encrypt table space
How to create the right tablespace in your work
4, Oracle database storage structure Explained
Data file explanation
Managing Data Files
How to properly plan and add data files
What are segment blocks
Causes and impacts of row migration and row connections and solutions
5. Oracle Database Configuration
Configuring memory size and parameters for a database
How to configure reasonable parameters for a database at work
(3) Oracle Database network Management
1. Configuring the Oracle Network Environment
Oracle Network Configuration
Configuration and management of listeners
Configuration and management of TNSNames
Dynamic registration and Static registration
Using Oracle Configuration Files
Network fault failover
2. Resolve Oracle Network failure
Set up a network trace
Fault Handling
(4) Grid control
1. GC Installation and use
GC Action and application
GC Architecture
GC Installation
Configuring the EM Repository
Create an EM user agent installation and configuration
2. Use of GC
Modifying the database configuration with EM
Using EM to modify database availability
3. Create and use Scheduled tasks
Create and manage Job jobs
Creating and monitoring warnings
Create a notification
Create a scheduled task
Create a Schedule
Specify a time window for a job
Create a program
Create a Job class
Backing up various files with Rman
(5) Oracle database backup and Recovery
1. Basic concepts of backup and recovery
Factors that need to be considered in actual work to develop backup and recovery
Common error types and how to cope
SCN number detailed
Cold and hot Backup
Physical and logical backups
Full and incomplete backups
Full recovery and incomplete recovery
instance recovery and media recovery
2. Use Flash back
Flash back version Query
Flash back Transaction
Flash back Table
Flash back Discard
Flash back to the database
Flash Back Data archive
3. Manual Backup and Recovery
Physical backup of control files and data files using manual methods
Solutions for missing and multiple control files
Missing a log member and a solution for a non-current log group
Recovery scheme for lost system tablespace
Loss of recovery scenarios for non-system table spaces
4. Logical Backup
Analysis of import and export principle
Use the Import Export tool to perform export import of tables, objects, and entire libraries
Import and Export tool common parameters explained
Export and import of tables, objects, and libraries using the data pump Import and Export tool
Data pump Tools Common parameters explained
Transport table Space
Character Set issues
5. Perform backup and recovery using Rman
Rman Catalog
Basic use of Rman tools
Viewing and modifying Rman environment variables
Automatic backup using control files
Using Rman image Backup
Using Rman Backup Optimizations
Use multiple channels for backup
Using Backup to restore redundancy policy
Backing up various files with Rman
Using incremental backups
Backup sets and backup slices
Use Rman to view backups
Verifying backup Sets with Rman
Modify Backup Status
Use Rman for recovery of various scenarios
Using Rman Script
Using Data Recovery Advisor
(6) Oracle Database Migration
1. How to migrate a database
Introduction to different migration scenarios
Choose different migration modes according to different scenarios
migrating databases using the Data Pump Import Export tool
Migrating Data using Dblink
Using Rman to perform migrations
Migrating data using transport table space
Migrating a database using DG
Migrating data using Ogg
2. Manual Backup and Recovery
Perform a cross-version migration using the data Pump Import and Export tool
Perform cross-platform migrations using Rmanconvert
(7) Oracle Performance optimization
1, performance optimization of the script concept
Why to optimize
Optimize your Goals
Common optimization Issues
Production environment Optimization steps
2. Diagnostic and optimization tools
Alarm Log
SQL Trace 10046 10053 event
Data View
AWR performance reports and ADDM
Using SQL Tuning Recommendations
Using SQL query Suggestions
Using SQL Performance Analyzer
Configuration baseline Template
3. I/O tuning
Process and I/O
Instruction minute hand for adjusting I/O
I/O view and AWR data
Full table scan, index scan and physical read
Dbwn and physical writing
Log files and archive files
4. Shared Pool
Shared Pool Concepts
Library Cache
Cursors and shared SQL
Library cache tuning and pin frequently used objects
Reserved area and ora-04031
Shared Pool Advisor
Library Cache Tuning Summary
Tuning the dictionary cache
Candidates
Shared pool-related
5, Buffercache
Buffercache Introduction
Block of Read
Block of writing
2 Concepts of logical reading
CR Fast
Wait for event
6. Redobuffer and Java Pool
Redobuffer
Java Pool
7. SGA Management
Sga_target and Sga_max_size
Memory_target and Memory_max_target
ASMM memory components and non-ASMM memory components Change
8. PGA and sequencing
UGA User Global Zone
CGA calls the global zone
PGA Program Global Zone
PGA Management
Recovery of PGA Memory
Related views
9. SQL optimization
Access path
rowID and RowNum
Table Connection mode
Optimizer
Execution plan and Hints
Diagnostic tools
10. Data collection
What is a data map
Bar chart
Analyze
11. Learn to use various indexes
Learn to use the B tree index
Learn to use various non-btree indexes
Comparison of usage and performance of different indexes
How to determine whether to create an index and select an appropriate index
12. Using the partition table
Why use partitioned Tables
How to determine whether to use a partitioned table in your work
The principle of partitioned tables
Hash partition
List partition
Range Partitioning
Composite partitioning
Create, delete, update, and manage partitions
Global and local indexes
13. Use Index to organize table
Why use index to organize tables
What happens when you use an index to organize tables
The principle of index Organization table
Create, delete, update, and Index organization tables
14. Using Sql*loader and external tables
Reprint Data Using Sqlloader
Why use external Tables
External Table principle
Create, delete, update, and manage external tables
15. Using materialized views
Why use materialized views
Materialized view principle
Create, delete, update, and manage materialized views
Refresh of materialized views
Query rewriting
16. Using ASM
ASM principle
Installing the deployment grid software
Overview of ASM disks, disk groups, failure groups
How to create an ASM disk
How to create an ASM instance
Managing ASM Instances
Managing ASM Disks
Create and manage ASM disk groups
Create and manage ASM fault groups
To create a database that uses ASM disk groups
Using ASM to mirror data
Using ASM to balance data
ASM in the Balance
(8) Oracle database is highly available
1. Using ASM
ASM principle
Installing the deployment grid software
Overview of ASM disks, disk groups, failure groups
How to create an ASM disk
How to create an ASM instance
Managing ASM Instances
Managing ASM Disks
Create and manage ASM disk groups
Create and manage ASM fault groups
To create a database that uses ASM disk groups
Using ASM to mirror data
Using ASM to balance data
ASM in the Balance
2. Using RAC
What happens with RAC
Cluster-related concepts: Brain fissure, amnesia, voting
Deploying a two-node clustered environment using ASM as a storage installation
Installing the grid software on multiple nodes
Installing Oracle database software on multiple nodes
Create and manage a multi-node db instance
RAC Daily Command Summary
Common Troubleshooting for RAC
How RAC environments are optimized
3. Using DG
DG Principle
What is a logical library and what is a physical library
Two-Machine hot standby Application Scenario Description
Description of DG related services: Log sending, transmission, acceptance, application services
DG3 Large Protection Mode introduction
Create a physical standby library
Configure dual-machine, reduce the main library incremental backup overhead
Switch the master repository and switch back to its original state
Configuring a Failover Connection
Converting a standby library to a snapshot standby library
Configure archive deletion policy for dual-machine hot standby
If the Oracle 0 Foundation, please see my OCP directory.
This article is from the "Liang blog" blog, make sure to keep this source http://7038006.blog.51cto.com/7028006/1967461
Oracle OCM Oracle Certified Master