Oracle Database 11g: Administration Workshop I<wbr></wbr>
<wbr></wbr>
(5 days)
<wbr></wbr>
Description
<wbr></wbr>
This course is designed to give students a firm foundation in basic 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 database architecture and how its components work and interact with one another. Students learn how to create an operational database 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 reinforced with structured hands-on practices.
This course counts towards the Hands-on course requirement for the Oracle Database
11g Administrator Certification. Only instructor-led inclass or instructor-led online
formats of this course will meet the Certification Hands-on Requirement. Self Study
CD-Rom and Knowledge Center courses DO NOT meet the Hands-on Requirement
<wbr></wbr>
<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
Audience
<wbr><wbr> •<wbr> Database Administrator</wbr></wbr></wbr>
•<wbr> Database Designer</wbr>
•<wbr> Developer</wbr>
•<wbr> Technical Administrator<wbr></wbr></wbr>
<wbr></wbr>
<wbr></wbr>
Required Prerequisites
<wbr> •<wbr> Working knowledge of SQL</wbr></wbr>
<wbr></wbr>
<wbr></wbr>
Objectives
<wbr> After completing this course, students should be able to:</wbr>
•<wbr> Describe Oracle Database Architecture<wbr></wbr></wbr>
•<wbr> Install and configure Oracle Database 11g<wbr></wbr></wbr>
•<wbr> Configure Oracle Net services<wbr></wbr></wbr>
•<wbr> Manage the database storage structures</wbr>
•<wbr><wbr> Create and administer user accounts</wbr></wbr>
•<wbr><wbr> Perform basic backup and recovery of a database<wbr></wbr></wbr></wbr>
•<wbr> Manage users and schemas<wbr></wbr></wbr>
•<wbr> Manage data and concurrency<wbr></wbr></wbr>
•<wbr> Monitor and administer undo data</wbr>
•<wbr><wbr> Backup and recover a database</wbr></wbr>
•<wbr><wbr> Monitor performance<wbr></wbr></wbr></wbr>
•<wbr> Use the database diagnostic monitor<wbr></wbr></wbr>
<wbr></wbr>
<wbr></wbr>
<wbr></wbr>
Topics
<wbr></wbr>
Exploring the Oracle Database Architecture<wbr></wbr>
•<wbr> Oracle Database Architecture Overview<wbr></wbr></wbr>
•<wbr> Interacting with an Oracle Database<wbr></wbr></wbr>
<wbr> 2</wbr>
•<wbr> Process Architecture<wbr></wbr></wbr>
•<wbr> Database Storage Architecture</wbr>
•<wbr><wbr> Logical and Physical Database Structures<wbr></wbr></wbr></wbr>
•<wbr> Tablespaces and Data Files<wbr></wbr></wbr>
•<wbr> SYSTEM and SYSAUX Tablespaces<wbr></wbr></wbr>
•<wbr> Segments, Extents, and Blocks<wbr></wbr></wbr>
Preparing the Database Environment
•<wbr> Tasks of an Oracle Database Administrator<wbr></wbr></wbr>
•<wbr> Tools Used to Administer an Oracle Database</wbr>
•<wbr><wbr> Installation: System Requirements<wbr></wbr></wbr></wbr>
•<wbr> Optimal Flexible Architecture (OFA)</wbr>
•<wbr><wbr> Setting Environment Variables<wbr></wbr></wbr></wbr>
•<wbr> Oracle Universal Installer (OUI)<wbr></wbr></wbr>
•<wbr> Database Configuration Options<wbr></wbr></wbr>
•<wbr> Advanced Installation Options<wbr></wbr></wbr>
Creating an Oracle Database
•<wbr> Planning the Database</wbr>
•<wbr> Configuring the Listener</wbr>
•<wbr><wbr> Using the DBCA to Create a Database</wbr></wbr>
•<wbr><wbr> Password Management<wbr></wbr></wbr></wbr>
•<wbr> Creating a Database Design Template<wbr></wbr></wbr>
•<wbr> Using the DBCA to Delete a Database<wbr></wbr></wbr>
•<wbr> Using DBCA For Additional Tasks</wbr>
Managing the Oracle Instance
•<wbr> Management Framework<wbr></wbr></wbr>
•<wbr> Oracle Enterprise Manager<wbr></wbr></wbr>
•<wbr> Initialization Parameter</wbr>
•<wbr> Database Startup and Shutdown<wbr></wbr></wbr>
•<wbr> Shutdown Modes</wbr>
•<wbr> Viewing the Alert History<wbr></wbr></wbr>
•<wbr> Using Trace Files</wbr>
•<wbr><wbr> Data Dictionary: Overview<wbr></wbr></wbr></wbr>
<wbr></wbr>
Configuring the Oracle Network Environment
•<wbr> Oracle Net Services & Listener<wbr></wbr></wbr>
•<wbr> Establishing Net Connections<wbr></wbr></wbr>
•<wbr> Tools for Configuring and Managing the Oracle Network<wbr></wbr></wbr>
•<wbr> Net Services Administration Pages<wbr></wbr></wbr>
•<wbr> Naming Methods<wbr></wbr></wbr>
•<wbr> Directory Naming<wbr></wbr></wbr>
•<wbr> SGA and PGA<wbr></wbr></wbr>
•<wbr> When Not to Use a Shared Server<wbr></wbr></wbr>
<wbr></wbr>
<wbr>Managing Database Storage Structures</wbr>
•<wbr> Storage Structures <wbr></wbr></wbr>
•<wbr> How Table Data Is Stored<wbr></wbr></wbr>
•<wbr> Anatomy of a Database Block<wbr></wbr></wbr>
•<wbr> Space Management in Tablespaces<wbr></wbr></wbr>
•<wbr> Tablespaces in the Preconfigured Database<wbr></wbr></wbr>
•<wbr> Actions with Tablespaces</wbr>
•<wbr> Oracle Managed Files (OMF)</wbr>
<wbr> 3</wbr>
•<wbr><wbr> ASM: Concepts<wbr></wbr></wbr></wbr>
Administering User Security
•<wbr> Database User Accounts<wbr></wbr></wbr>
•<wbr> Predefined Accounts: SYS and SYSTEM<wbr></wbr></wbr>
•<wbr> Administrator Authentication<wbr></wbr></wbr>
•<wbr> Benefits of Roles<wbr></wbr></wbr>
•<wbr> Predefined Roles<wbr></wbr></wbr>
•<wbr> Implementing Password Security Features<wbr></wbr></wbr>
•<wbr> Assigning Quota to Users<wbr></wbr></wbr>
Managing Schema Objects
•<wbr> What Is a Schema?</wbr>
•<wbr> Accessing Schema Objects<wbr></wbr></wbr>
•<wbr> Specifying Data Types in Tables</wbr>
•<wbr> Creating and Modifying Tables</wbr>
•<wbr><wbr> Understanding Data Integrity<wbr></wbr></wbr></wbr>
•<wbr> Indexes & Views<wbr></wbr></wbr>
•<wbr> Sequences<wbr></wbr></wbr>
•<wbr> Temporary Tables<wbr></wbr></wbr>
Managing Data and Concurrency
•<wbr> Manipulating Data Through SQL</wbr>
•<wbr><wbr> PL/SQL<wbr></wbr></wbr></wbr>
•<wbr> Administering PL/SQL Objects<wbr></wbr></wbr>
•<wbr> Functions, Procedures, Packages & Triggers<wbr></wbr></wbr>
•<wbr> Data Concurrency<wbr></wbr></wbr>
•<wbr> Enqueue Mechanism<wbr></wbr></wbr>
•<wbr> Resolving Lock Conflicts Using SQL</wbr>
•<wbr><wbr> Deadlocks<wbr></wbr></wbr></wbr>
Managing Undo Data
•<wbr> Data Manipulation</wbr>
•<wbr> Transactions and Undo Data<wbr></wbr></wbr>
•<wbr> Undo Data Versus Redo Data<wbr></wbr></wbr>
•<wbr> Configuring Undo Retention<wbr></wbr></wbr>
•<wbr> Guaranteeing Undo Retention<wbr></wbr></wbr>
•<wbr> Using the Undo Advisor<wbr></wbr></wbr>
•<wbr> Viewing System Activity<wbr></wbr></wbr>
Implementing Oracle Database Security
•<wbr> Industry Security Requirements<wbr></wbr></wbr>
•<wbr> Principle of Least Privilege<wbr></wbr></wbr>
•<wbr> Monitoring for Compliance<wbr></wbr></wbr>
•<wbr> Value-Based Auditing<wbr></wbr></wbr>
•<wbr> Fine-Grained Auditing<wbr></wbr></wbr>
•<wbr> DBA Auditing<wbr></wbr></wbr>
•<wbr> Security Updates<wbr></wbr></wbr>
•<wbr> Applying Security Patches<wbr></wbr></wbr>
<wbr></wbr>
Database Maintenance
•<wbr> Introducing Terminology<wbr></wbr></wbr>
•<wbr> Optimizer Statistics<wbr></wbr></wbr>
•<wbr> Automatic Workload Repository (AWR)<wbr></wbr></wbr>
•<wbr> Automatic Database Diagnostic Monitor (ADDM)<wbr></wbr></wbr>
•<wbr> Advisory Framework<wbr></wbr></wbr>
<wbr> 4</wbr>
•<wbr> Automated Maintenance Tasks<wbr></wbr></wbr>
•<wbr> Server-Generated Alerts</wbr>
•<wbr> Reacting to Alerts<wbr></wbr></wbr>
<wbr></wbr>
Performance Management
•<wbr> Performance Monitoring<wbr></wbr></wbr>
•<wbr> Managing Memory Components<wbr></wbr></wbr>
•<wbr> Enabling Automatic Memory Management (AMM)<wbr></wbr></wbr>
•<wbr> Automatic Shared Memory Advisor</wbr>
•<wbr> Using Memory Advisors<wbr></wbr></wbr>
•<wbr> Dynamic Performance Statistics<wbr></wbr></wbr>
•<wbr> Troubleshooting and Tuning Views</wbr>
•<wbr><wbr> Invalid and Unusable Objects<wbr></wbr></wbr></wbr>
<wbr></wbr>
Backup and Recovery Concepts
•<wbr> Part of Your Job<wbr></wbr></wbr>
•<wbr> Statement Failure<wbr></wbr></wbr>
•<wbr> User Error<wbr></wbr></wbr>
•<wbr> Understanding Instance Recovery<wbr></wbr></wbr>
•<wbr> Phases of Instance Recovery<wbr></wbr></wbr>
•<wbr> Using the MTTR Advisor<wbr></wbr></wbr>
•<wbr> Media Failure<wbr></wbr></wbr>
•<wbr> Archive Log Files<wbr></wbr></wbr>
<wbr></wbr>
Performing Database Backups
•<wbr> Backup Solutions: Overview<wbr></wbr></wbr>
•<wbr> Oracle Secure Backup<wbr></wbr></wbr>
•<wbr> User-Managed Backup<wbr></wbr></wbr>
•<wbr> Terminology<wbr></wbr></wbr>
•<wbr> Recovery Manager (RMAN)<wbr></wbr></wbr>
•<wbr> Configuring Backup Settings<wbr></wbr></wbr>
•<wbr> Backing Up the Control File to a Trace File<wbr></wbr></wbr>
•<wbr> Monitoring the Flash Recovery Area<wbr></wbr></wbr>
Performing Database Recovery
•<wbr> Opening a Database<wbr></wbr></wbr>
•<wbr> Data Recovery Advisor<wbr></wbr></wbr>
•<wbr> Loss of a Control File<wbr></wbr></wbr>
•<wbr> Loss of a Redo Log File<wbr></wbr></wbr>
•<wbr> Data Recovery Advisor<wbr></wbr></wbr>
•<wbr> Data Failures<wbr></wbr></wbr>
•<wbr> Listing Data Failures<wbr></wbr></wbr>
•<wbr> Data Recovery Advisor Views<wbr></wbr></wbr>
<wbr></wbr>
Moving Data
•<wbr> Moving Data: General Architecture</wbr>
•<wbr> Directory Object: Overview<wbr></wbr></wbr>
•<wbr> SQL*Loader: Overview<wbr></wbr></wbr>
•<wbr> Data Pump: Overview<wbr></wbr></wbr>
•<wbr> Performance Initialization Parameters<wbr></wbr></wbr>
•<wbr> Using Enterprise Manager to Monitor Data Pump Jobs<wbr></wbr></wbr>
•<wbr> Data Dictionary<wbr></wbr></wbr>
<wbr></wbr>
Enhancing Database Capabilities
•<wbr> Using EM Support Workbench<wbr></wbr></wbr>
•<wbr> Create a Service Request<wbr></wbr></wbr>
•<wbr> Package and upload diagnostic data to Oracle Support<wbr></wbr></wbr>
•<wbr> Track the SR and Implement Repairs</wbr>
•<wbr> Incident Packaging Configuration<wbr></wbr></wbr>
•<wbr> Working with Oracle Support<wbr></wbr></wbr>
•<wbr> MetaLink Integration<wbr></wbr></wbr>
•<wbr> Managing Patches<wbr></wbr></wbr>
<wbr></wbr>
<wbr></wbr>
<wbr></wbr>
Suggested Next Course
<wbr><wbr></wbr></wbr>
Oracle Database 11g: Administration Workshop II
<wbr></wbr>
<wbr></wbr>
<wbr></wbr>
<wbr></wbr>
<wbr></wbr>
<wbr></wbr>
<wbr></wbr>
<wbr></wbr>
<wbr></wbr>
<wbr></wbr>
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 Oracle professional, designed to give you a firm foundation in basic
database administration. In this class, you'll learn how to install and maintain an Oracle database. You will gain a
conceptual understanding of the Oracle database architecture and how its components work and interact with one
another. You will also learn how to create an operational database 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 reinforced with structured hands-on practices. This course is
designed to prepare you for the corresponding Oracle Certified Associate 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 Oracle Certification Path. Only instructor-led online (LVC, LWC),
in-class (ILT), or Training On Demand courses will fulfill the requirement. 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 equivalent experience
Taken Oracle PL/SQL course or equivalent experience
Suggested Prerequisites
Oracle Database: Introduction to SQL
Course Objectives
Install Oracle Grid Infrastructure
Copyright © 2011, Oracle. All rights reserved. Page<wbr> 1</wbr>
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
Copyright © 2011, Oracle. All rights reserved. Page<wbr> 2</wbr>
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 dedicated servers
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
Copyright © 2011, Oracle. All rights reserved. Page<wbr> 3</wbr>
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
Copyright © 2011, Oracle. All rights reserved. Page<wbr> 4</wbr>
Related Courses
Oracle Database 11g: Administration Workshop I Release 2 Self-Study Course
<wbr></wbr>
Ad2
Oracle 数据库的核心概念和工具
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> Oracle 数据库体系结构概览</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> ASM 存储概念</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 连接到数据库和 ASM 实例</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> DBA 工具概览</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
配置可恢复性
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 备份和恢复 (B&R) 的用途、典型任务和术语</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 使用 Recovery Manager (RMAN)</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 配置数据库进行 B&R 操作</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 配置 Archivelog 模式</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 配置备份保留</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 配置和使用快速恢复区 (FRA)</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
使用 RMAN 恢复目录
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 跟踪和存储备份信息</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 设置恢复目录</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 记录备份</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 使用 RMAN 存储脚本</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 管理恢复目录（备份、导出、导入、升级、删除和虚拟专用目录）</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
配置备份设置
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 为 RMAN 配置和管理永久性设置</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 配置控制文件的自动备份</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 备份优化</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 高级配置设置：压缩备份</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 配置大型文件（多节）的备份和恢复</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
使用 RMAN 创建备份
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> RMAN 备份类型</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 创建和使用下列项：</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> - 备份集和映像副本</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> - 数据库整体备份</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> - 快速增量备份</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> - 配置备份目标</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> - 双重备份集</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> - 归档备份</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
还原和恢复任务
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 还原和恢复</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 文件丢失的原因</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 自动临时文件恢复</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 从重做日志组丢失中恢复</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 从丢失的索引表空间恢复</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 重新创建口令验证文件</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 完全及不完全恢复</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 其它恢复操作</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
使用 RMAN 执行恢复
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 丢失关键性或非关键性数据文件后的完全恢复</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 恢复映像副本及切换文件</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 在 NOARCHIVELOG 模式下数据库的还原和恢复</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 不完全恢复</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 使用备份控制文件执行恢复</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 从自动备份还原：服务器参数文件和控制文件</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 在新主机上还原和恢复数据库</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
监视和优化 RMAN
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 监视 RMAN 作业</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 备份速度与恢复速度之间的平衡</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> RMAN 多路复用</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 同步和异步 I/O</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 说明 MAXPIECESIZE、FILESPERSET、MAXOPENFILES 和 BACKUP DURATION 的性能影响</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
诊断数据库
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 数据恢复指导 (DRA)</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 块损坏</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 自动诊断资料档案库 (ADR)</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 健康监视运行</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> ADR 命令行工具，ADRCI</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
使用闪回技术 I
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 闪回技术：概览和设置</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 使用闪回技术查询数据</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 闪回表</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 闪回事务处理查询</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 执行闪回事务处理恢复</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
使用闪回技术 II
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> Oracle Total Recall</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 闪回删除和回收站</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
Performing Flashback Database
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 配置闪回数据库</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 执行闪回数据库操作</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 监视闪回数据库</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
管理内存
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> Oracle 内存结构</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> Oracle 数据库内存参数</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 使用自动内存管理</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 自动共享内存管理</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 使用内存指导</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 使用数据字典视图</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
管理数据库性能
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 优化活动</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 使用统计首选项</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 优化程序统计数据收集</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 监视会话和服务的性能</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 自动工作量资料档案库 (AWR)</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 描述数据库重放的优点</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
通过 SQL 优化管理性能
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> SQL 优化和 SQL 指导</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 使用 SQL 优化指导</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> SQL 访问指导：</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> SQL 性能分析器概览</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
管理资源
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 数据库资源管理器：概览和概念</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 访问和创建资源计划</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 创建使用者组</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 指定资源计划指令，包括：</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 在数据库级别限制 CPU 使用率</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 实例锁定</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 激活资源计划</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 监视资源管理器</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
使用调度程序自动执行任务
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 简化管理任务</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 创建作业、方案和调度</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 使用基于时间、基于事件的以及复杂的调度</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 描述窗口、窗口组、作业类以及使用者组的使用</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 多目标作业</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
管理块中的空间
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 可用空间管理</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 监视空间</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 压缩数据</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
管理段中的空间
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 按需创建段</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 其它自动节约空间功能</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 收缩段</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 段指导</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 管理可恢复的空间分配</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 使用 4 KB 扇区磁盘</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 传输表空间</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 传输数据库</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
复制数据库
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 克隆数据库的用途和方法</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 使用 RMAN 创建重复数据库</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 基于备份克隆数据库</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 基于运行实例复制数据库</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
·<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 无目标复制数据库</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
<wbr></wbr>
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
