没有合适的资源?快使用搜索试试~ 我知道了~
Oracle_Database11g-Administration_Workshop2-2-1212.pdf
需积分: 9 2 下载量 61 浏览量
2020-04-02
10:29:15
上传
评论
收藏 5.65MB PDF 举报
温馨提示
I Introduction 1 Exploring the Oracle Database Architecture 2 Installing your Oracle Software 3 Creating an Oracle Database Using DBCA 4 Managing the Database instance 5 Managing the ASM Instance 6 Configuring the Oracle Network Environment 7 Managing Database Storage Structures 8 Administering User Security 9 Managing Data Concurrency 10 Managing Undo Data 11 Implementing Oracle Database Auditing 12 Database Maintenance 13 Performance Management 14 Backup and Recovery Concepts 15 Performing Database Backups 16 Performing Database Recovery 17 Moving Data 18 Working with Support
资源推荐
资源详情
资源评论
Oracle Database 11g:
Administration Workshop II
Volume II • Student Guide
D50079GC10
Edition 1.0
November 2007
D53299
®
Oracle Internal & OAI Use Only
Copyright © 2007, Oracle. All rights reserved.
Disclaimer
This document contains proprietary information and is protected by copyright and
other intellectual property laws. You may copy and print this document solely for your
own use in an Oracle training course. The document may not be modified or altered in
any way. Except where your use constitutes "fair use" under copyright law, you may
not use, share, download, upload, copy, print, display, perform, reproduce, publish,
license, post, transmit, or distribute this document in whole or in part without the
express authorization of Oracle.
The information contained in this document is subject to change without notice. If you
find any problems in the document, please report them in writing to: Oracle University,
500 Oracle Parkway, Redwood Shores, California 94065 USA. This document is not
warranted to be error-free.
Restricted Rights Notice
If this documentation is delivered to the United States Government or anyone using
the documentation on behalf of the United States Government, the following notice is
applicable:
U.S. GOVERNMENT RIGHTS
The U.S. Government’s rights to use, modify, reproduce, release, perform, display, or
disclose these training materials are restricted by the terms of the applicable Oracle
license agreement and/or the applicable U.S. Government contract.
Trademark Notice
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other
names may be trademarks of their respective owners.
Authors
Tom Best
James Spiller
James Womack
Maria Billings
Technical Contributors
and Reviewers
Sharath Bhujani
Timothy Chien
Al Flournoy
Andy Fortunak
Gerlinde Frenzen
Joel Goodman
Magnus Isaksson
Pete Jones
Donna Keesling
Pierre Labrousse
Gwen Lazenby
Jerry Lee
Hakan Lindfors
Isabelle Marchand
Srinivas Putrevu
Andreas Reinhardt
Ira Singer
Editors
Arijit Ghosh
Amitha Narayan
Atanu Raychaudhuri
Graphic Designer
Rajiv Chandrabhanu
Publishers
Nita Brozowski
Giri Venugopal
Oracle Internal & OAI Use Only
iii
Contents
1 Database Architecture and ASM
Objectives 1-2
The Oracle Database 1-3
Oracle Database Architecture: Overview 1-4
Connecting to the Database 1-5
Oracle Database Server Structures 1-6
Oracle Memory Architecture 1-7
Process Architecture 1-9
Process Structures 1-10
Database Storage Architecture 1-12
Logical and Physical Database Structures 1-14
Tablespaces and Data Files 1-16
SYSTEM and SYSAUX Tablespaces 1-17
Segments, Extents, and Blocks 1-18
Database Architecture: Summary of Structural Components 1-19
Automatic Storage Management: Review 1-20
ASM: General Architecture 1-22
Creating an ASM Instance 1-23
ASM Instance Initialization Parameters 1-24
Starting Up an ASM Instance 1-25
SYSASM Role 1-26
Accessing an ASM Instance 1-27
Using Enterprise Manager to Manage ASM Users 1-28
Shutting Down an ASM Instance 1-29
ASM Storage: Concepts 1-30
ASM Disk Group 1-31
Failure Group 1-33
Disk Group Mirroring 1-34
Disk Group Dynamic Rebalancing 1-35
Managing Disk Groups 1-36
Creating and Dropping Disk Groups 1-37
Adding Disks to Disk Groups 1-38
ASM Disk Group Compatibility 1-39
ASM Disk Group Attributes 1-41
Using Enterprise Manager to Edit Disk Group Attributes 1-42
Oracle Internal & OAI Use Only
iv
Miscellaneous ALTER Commands 1-43
ASMCMD Utility 1-44
ASM Scalability and Performance 1-46
Summary 1-48
Practice 1 Overview: Database Architecture and ASM 1-49
2 Configuring for Recoverability
Objectives 2-2
Purpose of Backup and Recovery Functionality 2-3
Typical Backup and Recovery Tasks 2-4
Oracle Backup and Recovery Solutions 2-6
Using Recovery Manager 2-7
Types of RMAN Commands 2-9
Job Commands: Example 2-10
Configuring Your Database for Backup and Recovery Operations 2-11
ARCHIVELOG Mode 2-12
Configuring ARCHIVELOG Mode 2-13
Configuring Archive Log Destinations 2-15
Guaranteeing Archive Log Success 2-17
Specifying a Backup Destination 2-19
Specifying a Retention Policy 2-21
A Recovery Window Retention Policy: Example 2-23
Using a Flash Recovery Area 2-24
Defining a Flash Recovery Area 2-26
Defining a Flash Recovery Area Using Enterprise Manager 2-27
Flash Recovery Area Space Management 2-28
Flash Recovery Area Space Usage 2-30
Monitoring the Flash Recovery Area 2-32
Benefits of Using a Flash Recovery Area 2-33
Summary 2-34
Practice 2 Overview: Configuring for Recoverability 2-35
3 Using the RMAN Recovery Catalog
Objectives 3-2
RMAN Repository Data Storage: Comparison of Options 3-3
Storing Information in the Recovery Catalog 3-4
Reasons to Use a Recovery Catalog 3-5
Creating the Recovery Catalog: Three Steps 3-6
Configuring the Recovery Catalog Database 3-7
Creating the Recovery Catalog Owner 3-8
Creating the Recovery Catalog 3-9
Oracle Internal & OAI Use Only
v
Managing Target Database Records in the Recovery Catalog 3-10
Registering a Database in the Recovery Catalog 3-11
Using Enterprise Manager to Register a Database 3-12
Registering a Duplicated Database 3-15
Changing the DBID of a Database 3-16
Unregistering a Target Database from the Recovery Catalog 3-17
Cataloging Additional Backup Files 3-18
Recovery Catalog Resynchronization: Concepts 3-20
Manually Resynchronizing the Recovery Catalog 3-21
Using RMAN Stored Scripts 3-22
Creating RMAN Stored Scripts 3-23
Executing RMAN Stored Scripts 3-24
Displaying RMAN Stored Script Information 3-25
Updating and Deleting RMAN Stored Scripts 3-26
Backing Up the Recovery Catalog 3-27
Re-Creating an Unrecoverable Recovery Catalog 3-28
Exporting and Importing the Recovery Catalog 3-29
Upgrading the Recovery Catalog 3-30
Dropping the Recovery Catalog 3-31
Using a Virtual Private Catalog 3-32
Creating an RMAN Virtual Private Catalog 3-34
Summary 3-36
Practice 3 Overview: Using the RMAN Recovery Catalog 3-37
4 Configuring Backup Specifications
Objectives 4-2
Using RMAN to Create Backups 4-3
Backup Destinations 4-4
Configuring Persistent Settings for RMAN 4-5
Using Enterprise Manager to Configure RMAN Settings 4-6
Control File Autobackups 4-7
Managing Persistent Settings 4-9
Configuring Devices for Backup 4-10
Configuring and Allocating Channels for Use in Backups 4-12
Configuring Backup Optimization 4-13
Summary 4-15
Practice 4 Overview: Configuring Backup Specifications 4-16
5 Using RMAN to Create Backups
Objectives 5-2
Creating Backup Sets 5-3
Oracle Internal & OAI Use Only
剩余265页未读,继续阅读
资源评论
sword0810
- 粉丝: 0
- 资源: 14
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功