Oracle OCM Oracle Certified Master

Source: Internet
Author: User
Tags failover sqlplus

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.