Oracle Database 11g:
Administration Workshop II
Volume I • Student Guide
D50079GC20
Edition 2.0
September 2010
D62543
Copyright © 2010, Oracle and/or its affiliates. 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 and Java are registered trademarks of Oracle and/or its affiliates. Other names
may be trademarks of their respective owners.
Author
Maria Billings
Technical Contributors
and Reviewers
Christian Bauwens
Yanti Chang
Timothy Chien
Joe Fong
Andy Fortunak
Gerlinde Frenzen
Mark Fuller
Peter Fusek
Joel Goodman
Vimala Jacob
Dominique Jeunot
Pete Jones
Fukue Kawabe
Donna Keesling
Sean Kim
Achiel Langers
Gwen Lazenby
Jerry Lee
Deidre Matishak
Bill Millar
Lakshmi Naraparreddi
Ira Singer
Ranbir Singh
James Spiller
Matt Taylor
Branislav Valny
Jean-Francois Verrier
Editors
Nita Pavitran
Raj Kumar
Graphic Designer
Satish Bettegowda
Publisher
Jayanthy Keshavamurthy
iii
Contents
I Introduction
Course Objectives I-2
Suggested Schedule I-3
Oracle Database 11g: “g” Stands for Grid I-4
Grid Infrastructure for Single-Instance I-6
Course Examples: HR Sample Schema I-8
1 Core Concepts and Tools of the Oracle Database
Objectives 1-2
Naming the Core Components of an Oracle Database Server 1-3
Oracle Database Server Architecture Overview 1-4
Instance-Database Configurations 1-6
Naming the Memory Structures of an Oracle Database Instance 1-7
Oracle Database Memory Structures 1-8
Process Architecture 1-10
Process Structures 1-11
Adding Process Names 1-13
Process Startup Sequence 1-14
Database Storage Architecture 1-15
Logical and Physical Database Structures 1-17
Automatic Storage Management 1-19
ASM Storage Components 1-20
ASM Instance 1-21
DBA Configuration Tools 1-23
Management Framework and Related DBA Tools 1-25
Facilitating Database Management with Oracle Restart 1-26
Notes: Facilitating Database Management with Oracle Restart 1-27
Quiz 1-28
Summary 1-29
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-5
iv
Oracle Backup Solutions 2-6
Terminology Review 2-7
What You Already Know: Oracle-Suggested Backup 2-9
Using Recovery Manager 2-10
Types of RMAN Commands 2-11
Job Commands: Example 2-12
Configuring Your Database for Backup and Recovery Operations 2-13
ARCHIVELOG Mode 2-14
Configuring ARCHIVELOG Mode 2-15
Configuring Archive Log Destinations 2-16
Guaranteeing Archive Log Success 2-17
Specifying a Retention Policy 2-19
A Recovery Window Retention Policy: Example 2-21
Using a Fast Recovery Area 2-22
Defining a Fast Recovery Area 2-24
Fast Recovery Area Space Management 2-25
Fast Recovery Area Space Usage 2-27
What Is Done Automatically for You 2-29
Monitoring the FRA 2-30
Benefits of Using a Fast Recovery Area 2-31
Quiz 2-32
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
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
Unregistering a Target Database from the Recovery Catalog 3-13
Cataloging Additional Backup Files 3-14
Recovery Catalog Resynchronization: Concepts 3-16
Manually Resynchronizing the Recovery Catalog 3-17
Using RMAN Stored Scripts 3-18
v
Executing RMAN Stored Scripts 3-19
Maintaining RMAN Stored Scripts 3-20
Backing Up the Recovery Catalog 3-21
Re-Creating an Unrecoverable Recovery Catalog 3-22
Exporting and Importing the Recovery Catalog 3-23
Upgrading and Dropping the Recovery Catalog 3-24
IMPORT CATALOG Command 3-25
Creating and Using Virtual Private Catalogs 3-27
Using RMAN Virtual Private Catalogs 3-28
Recovery Catalogs Summary 3-30
Quiz 3-32
Summary 3-34
Practice 3 Overview: Using the RMAN Recovery Catalog 3-35
4 Configuring Backup Settings
Objectives 4-2
Configuring Persistent Settings for RMAN 4-3
Viewing Persistent Settings 4-4
Control File Autobackups 4-5
Managing Persistent Settings 4-7
Using a Media Manager 4-8
Specifying a Backup Destination 4-10
Configuring and Allocating Channels 4-11
Creating Duplexed Backup Sets 4-12
Creating Duplexed Backup Sets Using CONFIGURE BACKUP COPIES 4-13
Backup Optimization 4-14
Saving Backup Space with Unused Block Compression 4-16
Compressing Backups 4-17
Using RMAN Backup Compression 4-18
Encrypting Backups 4-19
Quiz 4-20
Summary 4-22
Practice 4 Overview: Configuring Backup Specifications 4-23
5 Creating Backups with RMAN
Objectives 5-2
Creating Backup Sets 5-3
Creating Image Copies 5-4
Creating a Whole Database Backup 5-6
RMAN Backup Types 5-8
Fast Incremental Backup 5-10
- 1
- 2
- 3
前往页