ocp11考纲

来源：互联网发布：更换断桥铝门窗知乎编辑：程序博客网时间：2024/04/30 04:20

Oracle Database 11g: Administration WorkshopI

(5 days)

Description

This course is designed to give students a firm foundation inbasic administration of Oracle Database 11g. In this class,students learn how to install and maintain Oracle Database 11g.Students gain a conceptual understanding of the Oracle databasearchitecture and how its components work and interact with oneanother. Students learn how to create an operational database andproperly manage the various structures in an effective andefficient manner including performance monitoring, databasesecurity, user management, and backup/recovery techniques. Thelesson topics are reinforced with structured hands-onpractices.

This course counts towards the Hands-on course requirement forthe Oracle Database

11g Administrator Certification. Only instructor-led inclass orinstructor-led online

formats of this course will meet the Certification Hands-onRequirement. Self Study

CD-Rom and Knowledge Center courses DO NOT meet the Hands-onRequirement

Audience

• Database Administrator

• Database Designer

• Developer

• TechnicalAdministrator

Required Prerequisites

• Working knowledge ofSQL

Objectives

After completing this course, students shouldbe able to:

• Describe Oracle DatabaseArchitecture

• Install and configure Oracle Database11g

• Configure Oracle Netservices

• Manage the database storage structures

• Create and administer useraccounts

• Perform basic backup andrecovery of a database

• Manage users andschemas

• Manage data andconcurrency

• Monitor and administer undo data

• Backup and recover adatabase

• Monitorperformance

• Use the database diagnosticmonitor

Topics

Exploring the Oracle Database Architecture

• Oracle Database ArchitectureOverview

• Interacting with an OracleDatabase

• Process Architecture

• Database Storage Architecture

• Logical and PhysicalDatabase Structures

• Tablespaces and DataFiles

• SYSTEM and SYSAUXTablespaces

• Segments, Extents, andBlocks

Preparing the Database Environment

• Tasks of an Oracle DatabaseAdministrator

• Tools Used to Administer an OracleDatabase

• Installation: SystemRequirements

• Optimal Flexible Architecture (OFA)

• Setting EnvironmentVariables

• Oracle Universal Installer(OUI)

• Database ConfigurationOptions

• Advanced InstallationOptions

Creating an Oracle Database

• Planning the Database

• Configuring the Listener

• Using the DBCA to Create aDatabase

• PasswordManagement

• Creating a Database DesignTemplate

• Using the DBCA to Delete aDatabase

• Using DBCA For Additional Tasks

Managing the Oracle Instance

• Management Framework

• Oracle EnterpriseManager

• Initialization Parameter

• Database Startup andShutdown

• Shutdown Modes

• Viewing the AlertHistory

• Using Trace Files

• Data Dictionary:Overview

Configuring the Oracle Network Environment

• Oracle Net Services &Listener

• Establishing NetConnections

• Tools for Configuring and Managing theOracle Network

• Net Services AdministrationPages

• Naming Methods

• Directory Naming

• SGA and PGA

• When Not to Use a SharedServer

Managing Database Storage Structures

• Storage Structures

• How Table Data IsStored

• Anatomy of a DatabaseBlock

• Space Management inTablespaces

• Tablespaces in the PreconfiguredDatabase

• Actions with Tablespaces

• Oracle Managed Files (OMF)

• ASM:Concepts

Administering User Security

• Database User Accounts

• Predefined Accounts: SYS andSYSTEM

• AdministratorAuthentication

• Benefits of Roles

• Predefined Roles

• Implementing Password SecurityFeatures

• Assigning Quota toUsers

Managing Schema Objects

• What Is a Schema?

• Accessing SchemaObjects

• Specifying Data Types in Tables

• Creating and Modifying Tables

• Understanding DataIntegrity

• Indexes & Views

• Sequences

• Temporary Tables

Managing Data and Concurrency

• Manipulating Data Through SQL

• PL/SQL

• Administering PL/SQLObjects

• Functions, Procedures, Packages &Triggers

• Data Concurrency

• Enqueue Mechanism

• Resolving Lock Conflicts Using SQL

• Deadlocks

Managing Undo Data

• Data Manipulation

• Transactions and UndoData

• Undo Data Versus RedoData

• Configuring UndoRetention

• Guaranteeing UndoRetention

• Using the Undo Advisor

• Viewing SystemActivity

Implementing Oracle Database Security

• Industry SecurityRequirements

• Principle of LeastPrivilege

• Monitoring forCompliance

• Value-Based Auditing

• Fine-Grained Auditing

• DBA Auditing

• Security Updates

• Applying SecurityPatches

Database Maintenance

• IntroducingTerminology

• Optimizer Statistics

• Automatic Workload Repository(AWR)

• Automatic Database Diagnostic Monitor(ADDM)

• Advisory Framework

• Automated MaintenanceTasks

• Server-Generated Alerts

• Reacting to Alerts

Performance Management

• Performance Monitoring

• Managing MemoryComponents

• Enabling Automatic Memory Management(AMM)

• Automatic Shared Memory Advisor

• Using Memory Advisors

• Dynamic PerformanceStatistics

• Troubleshooting and Tuning Views

• Invalid and UnusableObjects

Backup and Recovery Concepts

• Part of Your Job

• Statement Failure

• User Error

• Understanding InstanceRecovery

• Phases of InstanceRecovery

• Using the MTTR Advisor

• Media Failure

• Archive Log Files

Performing Database Backups

• Backup Solutions:Overview

• Oracle Secure Backup

• User-Managed Backup

• Terminology

• Recovery Manager(RMAN)

• Configuring BackupSettings

• Backing Up the Control File to a TraceFile

• Monitoring the Flash RecoveryArea

Performing Database Recovery

• Opening a Database

• Data Recovery Advisor

• Loss of a Control File

• Loss of a Redo LogFile

• Data Recovery Advisor

• Data Failures

• Listing Data Failures

• Data Recovery AdvisorViews

Moving Data

• Moving Data: General Architecture

• Directory Object:Overview

• SQL*Loader: Overview

• Data Pump: Overview

• Performance InitializationParameters

• Using Enterprise Manager to Monitor DataPump Jobs

• Data Dictionary

Enhancing Database Capabilities

• Using EM SupportWorkbench

• Create a ServiceRequest

• Package and upload diagnostic data to OracleSupport

• Track the SR and Implement Repairs

• Incident PackagingConfiguration

• Working with OracleSupport

• MetaLink Integration

• Managing Patches

Suggested Next Course

Oracle Database 11g: Administration Workshop II

Oracle Database 11g: Administration Workshop I DBA Release 2

Duration:5 Days

What you will learn

This course is your first step towards success as an Oracleprofessional, designed to give you a firm foundation in basic

database administration. In this class, you'll learn how toinstall and maintain an Oracle database. You will gain a

conceptual understanding of the Oracle database architecture andhow its components work and interact with one

another. You will also learn how to create an operationaldatabase and properly manage the various structures in an

effective and efficient manner including performance monitoring,database security, user management, and

backup/recovery techniques. The lesson topics are reinforcedwith structured hands-on practices. This course is

designed to prepare you for the corresponding Oracle CertifiedAssociate exam.

Learn To:

Install Oracle Grid Infrastructure

Create and manage users

Install and Configure Oracle Database

Create and manage storage structures

Administer the Oracle Database

Backup and Recovery

This course fulfills the training requirement for an OracleCertification Path. Only instructor-led online (LVC, LWC),

in-class (ILT), or Training On Demand courses will fulfill therequirement. Self-study CD-ROM and Knowledge Center

courses do not fulfill the training requirement.

Database Administrators

Java Developer

Support Engineer

Technical Administrator

Technical Consultant

Prerequisites

Required Prerequisites

Taken Oracle Introduction to SQL course or equivalentexperience

Taken Oracle PL/SQL course or equivalent experience

Suggested Prerequisites

Oracle Database: Introduction to SQL

Course Objectives

Install Oracle Grid Infrastructure

Install and configure Oracle Database 11g

Configure Oracle Net services

Monitor and administer undo data

Manage the database storage structures

Create and administer user accounts

Perform basic backup and recovery of a database

Manage data concurrency

Monitor performance

Describe Oracle Database Architecture

Course Topics

Exploring the Oracle Database Architecture

Oracle Database Architecture Overview

Oracle ASM Architecture Overview

Process Architecture

Memory structrues

Logical and physical storage structures

ASM storage components

Installing your Oracle Software

Tasks of an Oracle Database Administrator

Tools Used to Administer an Oracle Database

Installation: System Requirements

Oracle Universal Installer (OUI)

Installing Oracle Grid Infrastructure

Installing Oracle Database Software

Silent Install

Creating an Oracle Database

Planning the Database

Using the DBCA to Create a Database

Password Management

Creating a Database Design Template

Using the DBCA to Delete a Database

Managing the Oracle Database Instance

Start and stop the Oracle database and components

Use Oracle Enterprise Manager

Access a database with SQLPlus

Modify database installation parameters

Describe the stages of database startup

Describe database shutdown options

View the alert log

Access dynamic performance views

Manage the ASM Instance

Set up initialization parameter files for ASM instance

Start up and shut down ASM instances

Administer ASM disk groups

Configuring the Oracle Network Environment

Use Enterprise Manager to create and configure the Listener

Enable Oracle Restart to monitor the listener

Use tnsping to test Oracle Net connectivity

Identify when to use shared servers and when to use dedicatedservers

Managing Database Storage Structures

Storage Structures

How Table Data Is Stored

Anatomy of a Database Block

Space Management in Tablespaces

Tablespaces in the Preconfigured Database

Actions with Tablespaces

Oracle Managed Files (OMF)

Administering User Security

Database User Accounts

Predefined Administrative Accounts

Benefits of Roles

Predefined Roles

Implementing Profiles

Managing Data Concurrency

Data Concurrency

Enqueue Mechanism

Resolving Lock Conflicts

Deadlocks

Managing Undo Data

Data Manipulation

Transactions and Undo Data

Undo Data Versus Redo Data

Configuring Undo Retention

Implementing Oracle Database Auditing

Describe DBA responsibilities for security

Enable standard database auditing

Specify audit options

Review audit information

Maintain the audit trail

Database Maintenance

Manage optimizer statistics

Manage the Automatic Workload Repository (AWR)

Use the Automatic Database Diagnostic Monitor (ADDM)

Describe and use the advisory framework

Set alert thresholds

Use server-generated alerts

Use automated tasks

Performance Management

Performance Monitoring

Managing Memory Components

Enabling Automatic Memory Management (AMM)

Automatic Shared Memory Advisor

Using Memory Advisors

Dynamic Performance Statistics

Troubleshooting and Tuning Views

Invalid and Unusable Objects

Backup and Recovery Concepts

Part of Your Job

Statement Failure

User Error

Understanding Instance Recovery

Phases of Instance Recovery

Using the MTTR Advisor

Media Failure

Archive Log Files

Performing Database Backups

Backup Solutions: Overview

Oracle Secure Backup

User-Managed Backup

Terminology

Recovery Manager (RMAN)

Configuring Backup Settings

Backing Up the Control File to a Trace File

Monitoring the Flash Recovery Area

Performing Database Recovery

Opening a Database

Data Recovery Advisor

Loss of a Control File

Loss of a Redo Log File

Data Recovery Advisor

Data Failures

Listing Data Failures

Data Recovery Advisor Views

Moving Data

Describe ways to move data

Create and use directory objects

Use SQL*Loader to move data

Use external tables to move data

General architecture of Oracle Data Pump

Use Data Pump export and import to move data

Working with Support

Use the Enterprise Manager Support Workbench

Work with Oracle Support

Log service requests (SR)

Manage patches

Related Courses

Oracle Database 11g: Administration Workshop I Release 2Self-Study Course

Ad2

Oracle 数据库的核心概念和工具

· Oracle 数据库体系结构概览

· ASM 存储概念

· 连接到数据库和 ASM 实例

· DBA 工具概览

配置可恢复性

· 备份和恢复 (B&R) 的用途、典型任务和术语

· 使用 Recovery Manager (RMAN)

· 配置数据库进行 B&R 操作

· 配置 Archivelog 模式

· 配置备份保留

· 配置和使用快速恢复区 (FRA)

使用 RMAN 恢复目录

· 跟踪和存储备份信息

· 设置恢复目录

· 记录备份

· 使用 RMAN 存储脚本

· 管理恢复目录（备份、导出、导入、升级、删除和虚拟专用目录）

配置备份设置

· 为 RMAN 配置和管理永久性设置

· 配置控制文件的自动备份

· 备份优化

· 高级配置设置：压缩备份

· 配置大型文件（多节）的备份和恢复

使用 RMAN 创建备份

· RMAN 备份类型

· 创建和使用下列项：

· - 备份集和映像副本

· - 数据库整体备份

· - 快速增量备份

· - 配置备份目标

· - 双重备份集

· - 归档备份

还原和恢复任务

· 还原和恢复

· 文件丢失的原因

· 自动临时文件恢复

· 从重做日志组丢失中恢复

· 从丢失的索引表空间恢复

· 重新创建口令验证文件

· 完全及不完全恢复

· 其它恢复操作

使用 RMAN 执行恢复

· 丢失关键性或非关键性数据文件后的完全恢复

· 恢复映像副本及切换文件

· 在 NOARCHIVELOG 模式下数据库的还原和恢复

· 不完全恢复

· 使用备份控制文件执行恢复

· 从自动备份还原：服务器参数文件和控制文件

· 在新主机上还原和恢复数据库

监视和优化 RMAN

· 监视 RMAN 作业

· 备份速度与恢复速度之间的平衡

· RMAN 多路复用

· 同步和异步 I/O

· 说明 MAXPIECESIZE、FILESPERSET、MAXOPENFILES 和 BACKUP DURATION的性能影响

诊断数据库

· 数据恢复指导 (DRA)

· 块损坏

· 自动诊断资料档案库 (ADR)

· 健康监视运行

· ADR 命令行工具，ADRCI

使用闪回技术 I

· 闪回技术：概览和设置

· 使用闪回技术查询数据

· 闪回表

· 闪回事务处理查询

· 执行闪回事务处理恢复

使用闪回技术 II

· Oracle Total Recall

· 闪回删除和回收站

Performing Flashback Database

· 配置闪回数据库

· 执行闪回数据库操作

· 监视闪回数据库

管理内存

· Oracle 内存结构

· Oracle 数据库内存参数

· 使用自动内存管理

· 自动共享内存管理

· 使用内存指导

· 使用数据字典视图

管理数据库性能

· 优化活动

· 使用统计首选项

· 优化程序统计数据收集

· 监视会话和服务的性能

· 自动工作量资料档案库 (AWR)

· 描述数据库重放的优点

通过 SQL 优化管理性能

· SQL 优化和 SQL 指导

· 使用 SQL 优化指导

· SQL 访问指导：

· SQL 性能分析器概览

管理资源

· 数据库资源管理器：概览和概念

· 访问和创建资源计划

· 创建使用者组

· 指定资源计划指令，包括：

· 在数据库级别限制 CPU 使用率

· 实例锁定

· 激活资源计划

· 监视资源管理器

使用调度程序自动执行任务

· 简化管理任务

· 创建作业、方案和调度

· 使用基于时间、基于事件的以及复杂的调度

· 描述窗口、窗口组、作业类以及使用者组的使用

· 多目标作业

管理块中的空间

· 可用空间管理

· 监视空间

· 压缩数据

管理段中的空间

· 按需创建段

· 其它自动节约空间功能

· 收缩段

· 段指导

· 管理可恢复的空间分配

管理数据库的空间

· 使用 4 KB 扇区磁盘

· 传输表空间

· 传输数据库

复制数据库

· 克隆数据库的用途和方法

· 使用 RMAN 创建重复数据库

· 基于备份克隆数据库

· 基于运行实例复制数据库

· 无目标复制数据库