Muutke küpsiste eelistusi

Oracle RMAN 11g Backup and Recovery [Pehme köide]

3.71/5 (13 hinnangut Goodreads-ist)
,
  • Formaat: Paperback / softback, 688 pages, kõrgus x laius x paksus: 234x185x33 mm, kaal: 1118 g, 175 Illustrations
  • Sari: Oracle Press
  • Ilmumisaeg: 16-Jun-2010
  • Kirjastus: Osborne/McGraw-Hill
  • ISBN-10: 0071628606
  • ISBN-13: 9780071628600
Teised raamatud teemal:
Oracle RMAN 11g Backup and RecoverySuurem pilt
  • Formaat: Paperback / softback, 688 pages, kõrgus x laius x paksus: 234x185x33 mm, kaal: 1118 g, 175 Illustrations
  • Sari: Oracle Press
  • Ilmumisaeg: 16-Jun-2010
  • Kirjastus: Osborne/McGraw-Hill
  • ISBN-10: 0071628606
  • ISBN-13: 9780071628600
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780071628600.html
Märksõnad:
Protect your databases from hardware, software, and operator failures using the detailed information in this Oracle Press guide. Oracle RMAN 11g Backup and Recovery explains how to configure databases, generate accurate archives, and carry out system restores. Work from the command line or Oracle Enterprise Manager, automate the backup process, perform Oracle Flashback recoveries, and integrate cloud computing technology. This authoritative resource also shows you how to create reports, optimize performance, and implement third-party administration utilities.

In this comprehensive and authoritative guide, database gurus Freeman and Hart explain how to use the latest version of Oracle Recovery Manager (RMAN) to configure databases, generate archives, and perform system restores. Clear explanations and examples show readers how to protect databases against hardware and software failures, or operator errors. Topics include setting up, configuring, and maintaining Oracle RMAN; automating the backup process; working with catalogs, packages, and control files; producing clone and stand-by databases on local or remote servers, and integrating cloud computing technology. Annotation ©2010 Book News, Inc., Portland, OR (booknews.com)

A fully updated Oracle Press bestseller, covering Oracle Database 11g Release 2Andnbsp;RMAN

Complete with full details on the latest release of Oracle Recovery Manager, this is an indispensable guide for Oracle database and systems administrators, providing both in-depth explanations and examples. This expert guide will serve as both a desk reference and guided instruction for understanding, configuring, and administering RMAN.

Oracle Database 11g RMAN Backup And Recovery begins by covering the conceptual framework and moves to a heavily hands-on approach. You will learn techniques for setting up RMAN-ready databases, creating reliable backups, and performing accurate Oracle system restores.

Acknowledgments xxiii
Introduction xxv
PART I Getting Started with RMAN in Oracle Database 11g
1 Oracle Database 11g Backup and Recovery Architecture Tour
3(30)
Backup and Recovery Essentials
5(2)
High Availability
5(1)
Backup and Recovery
5(2)
A Few Oracle Terms to Know
7(3)
Controlling the Database Software
10(1)
Oracle Architecture
11(2)
The Oracle Processes
11(2)
Oracle Memory and RMAN
13(3)
The Oracle Database
14(2)
More About the Oracle Redo Logs
16(5)
Archivelog Mode vs. Noarchivelog Mode
20(1)
Oracle Logical Structures
21(1)
The Combined Picture
21(5)
Startup and Shutdown of the Database
21(2)
Using the Database and Internals
23(3)
Oracle Backup and Recovery Primer
26(6)
Logical Backup and Recovery
26(1)
Oracle Physical Backup and Recovery
26(5)
Backing Up Other Oracle Components
31(1)
Summary
32(1)
2 Introduction to the RMAN Architecture
33(28)
Server-Managed Recovery
34(1)
The RMAN Utility
34(2)
RMAN and Database Privileges
35(1)
The Network Topology of RMAN Backups
36(3)
Running RMAN Remotely
36(1)
Running RMAN Locally from the Target Database's Oracle_Home
37(2)
The Database Control File
39(3)
Record Reuse in the Control File
39(1)
The Snapshot Control File
40(2)
The RMAN Server Processes
42(1)
RMAN Channel Processes
42(1)
The SYS Packages Used by RMAN
43(1)
SYS.DBMS_RCVMAN
43(1)
SYS.DBMS_BACKUP_RESTORE
43(1)
Backing Up the Data Block
44(3)
The Data Block Backup Overview
44(1)
The Benefits of Block-Level Backups
45(2)
RMAN in Memory
47(3)
Input Memory Buffers
48(1)
RMAN Memory Utilization: PGA vs. SGA
49(1)
The Recovery Catalog
50(1)
The Auxiliary Database
51(2)
Compatibility Issues
53(1)
The Target and the RMAN Executable
53(1)
The Catalog Database and Catalog Schema
53(1)
The Auxiliary Database
54(1)
The RMAN Process: From Start to Finish
54(2)
The Flash Recovery Area
56(1)
Summary
57(4)
PART II Setup Principles and Practices
3 RMAN Setup and Configuration
61(40)
Configuring Your Database to Run in Archivelog Mode
62(11)
Archivelog Destination Directories
62(2)
The Flash Recovery Area
64(7)
Should You Use the FRA?
71(1)
Switching Between Archivelog Modes
71(1)
If You Created Your Database with the Oracle Database Configuration Assistant
71(1)
RMAN Workshop: Put the Database in Archivelog Mode
72(1)
The Oracle Database 11g Fault Diagnosability Infrastructure
73(3)
The RMAN Command Line
76(4)
Connecting via the RMAN Command Line
76(3)
RMAN Client Compatibility
79(1)
Using the RMAN connect Command
79(1)
Exiting the RMAN Client
80(1)
Configuring the Database for RMAN Operations
80(3)
Setting Up the Database User
80(1)
RMAN Workshop: Create the Target Database RMAN Backup Account
80(1)
Setting Up Database Security
81(1)
Setting the CONTROL_FILE_RECORD_KEEP_TIME Parameter
82(1)
Configuring RMAN Default Settings
83(15)
Introducing the configure Command
83(1)
Configuring Various RMAN Default Settings
84(1)
Examples of Using the configure Command
85(12)
If You Are Using Shared Servers
97(1)
Summary of RMAN Configuration Tasks
98(1)
Other Backup and Recovery Setup and Configuration Considerations
99(1)
Summary
99(2)
4 Media Management Considerations
101(12)
Tape Backups in a Disk Backup World
102(1)
RMAN and the Media Manager: An Overview
103(4)
The Media Manager Catalog
103(1)
The Media Manager: Other Software Components
104(1)
Media Management Library
105(1)
RMAN Workshop: Test Tape Channels with the Oracle Default SBT Interface
105(2)
Interfacing with the MML
107(1)
The SBT API
107(1)
Back Up to Tape: From Start to Finish
108(1)
Restore from Tape: From Start to Finish
109(1)
Using sbttest and loadsbt.exe
109(1)
Media Management Errors
110(1)
Summary
111(2)
5 Oracle Secure Backup
113(30)
Features of Oracle Secure Backup
114(2)
Oracle Secure Backup and Recovery Manager
115(1)
Differences Between OSB and OSB Express
115(1)
Backup Encryption
115(1)
Fast Database Backup Compression
116(1)
Oracle Secure Backup Cloud Module
116(1)
Oracle Secure Backup Interfaces
116(1)
Oracle Secure Backup Components
117(5)
Oracle Secure Backup Daemons
119(1)
Host Access Modes
119(1)
Administrative Data
119(1)
Oracle Secure Backup Users and Classes
120(1)
Operating System Accounts
120(1)
NDMP Hosts
121(1)
Oracle Secure Backup Rights and Classes
121(1)
Installing and Configuring Oracle Secure Backup
122(11)
RMAN Workshop: Install and Configure Oracle Secure Backup
123(10)
Oracle Database and File System Data Backup Using Oracle Secure Backup
133(5)
RMAN Workshop: Schedule Oracle Database and File System Data Backups
133(5)
Oracle Database Backup Using Oracle Secure Backup Cloud Module
138(3)
RMAN Workshop: Installing OSB Cloud Module and Using it for OSB Backups
138(3)
Summary
141(2)
6 Backing Up to Amazon Web Services Using the Oracle Secure Backup Cloud Module
143(10)
Conventional Backups: Assumptions and Limitations
144(1)
The Oracle Secure Backup Cloud Module
144(1)
What is Cloud Computing?
144(1)
Oracle and the Amazon Cloud
145(1)
Elastic Compute Cloud (EC2) and Elastic Block Store (EBS)
145(1)
Simple Storage Service (S3)---Oracle's Cloud Backup Solution
145(1)
RMAN Backup to S3: The Oracle Secure Backup Cloud Module
145(1)
S3 Backup over the Internet or from Amazon EC2
145(1)
Oracle Cloud Backup Advantages
146(2)
RMAN Workshop: Deploying RMAN Backups to Amazon S3
146(2)
Performing Backups by Using the OSB Cloud Module
148(4)
Listing RMAN Backups and Backup Sets Stored on S3
150(1)
Optimizing Backups and Recoveries over the Internet Using the OSB Cloud Module and Amazon S3
150(2)
Licensing Considerations
152(1)
Summary
152(1)
7 Enhancing RMAN with VERITAS NetBackup™ for Oracle
153(20)
Key Features
154(1)
Necessary Components
155(1)
Storage/Media Device Configuration
155(1)
NetBackup Installation
155(2)
Pre-Installation Tasks for NetBackup for Oracle Agent
156(1)
NetBackup for Oracle Agent Installation Steps
157(1)
How to Link Oracle to NetBackup Media Manager
157(2)
Automatic Link Method
158(1)
Manual Link Method
158(1)
Architecture
159(1)
Configuring NetBackup Policies
160(7)
Adding New Policies
160(3)
Defining Schedules
163(2)
Defining a Backup Selection
165(1)
Defining Policy Clients
166(1)
Managing Expired Backup Images
167(1)
Delete Expired Backups Using NetBackup Repository
167(1)
Delete Expired Backups Using RMAN
167(1)
RMAN Sample Scripts
168(1)
Troubleshooting
169(1)
Use NetBackup Logs
169(1)
Determine Which Library is in Use
170(1)
Security Best Practices
170(1)
Cost Justification
171(1)
Summary
171(2)
8 Configuring HP Data Protector for Oracle
173(16)
Integration of Oracle and Data Protector
174(5)
Support Matrix
174(1)
Integration Components
174(2)
RMAN Workshop: Integration Configuration
176(3)
RMAN Backup Configuration on Data Protector
179(5)
RMAN Workshop: Backup Configuration
179(5)
Editing the Oracle RMAN Script
184(1)
RMAN Backup
184(1)
Backup Methods
184(1)
Backup Procedure
185(1)
Restoring Oracle Using the Data Protector GUI
185(2)
Restoring the Control File
186(1)
Restoring Oracle Database Objects
186(1)
Oracle RMAN Metadata and Data Protector Media Management Database Synchronization
187(1)
Summary
187(2)
9 RMAN and Tivoli Storage Manager
189(18)
Overview of Tivoli Storage Manager
190(9)
TSM Server System Objects
190(3)
TSM Client
193(1)
TSM Administration Center and Web Client
194(1)
RMAN Workshop: Configuring TDPO for Oracle
194(5)
Performing an RMAN Backup Using TDPO
199(5)
Deleting Database Backups
204(1)
Troubleshooting Common Backup Scenarios
204(2)
Additional Troubleshooting
206(1)
Summary
206(1)
10 Using the Recovery Catalog
207(18)
What is the Recovery Catalog?
208(6)
Creating the Recovery Catalog
209(1)
RMAN Workshop: Create the Recovery Catalog User Account
210(1)
RMAN Workshop: Create the Recovery Catalog
211(1)
RMAN Workshop: Register Your Database in the Recovery Catalog
211(2)
Utilizing a Virtual Private Catalog
213(1)
RMAN Workshop: Create a Virtual Private Catalog
213(1)
Merging Multiple Recovery Catalogs
214(1)
RMAN Workshop: Merge Two Recovery Catalogs
214(1)
Recovery Catalog Maintenance
214(2)
Unregistering a Database in RMAN
215(1)
Database Migration/Upgrade Issues
215(1)
Manually Resetting the Database Incarnation (reset catalog)
215(1)
Manually Resynchronizing the Recovery Catalog (resync catalog)
216(1)
Purging Recovery Catalog Records
216(1)
Backing Up the Recovery Catalog
216(1)
Recovery Catalog Views
217(8)
RC_Archived_Log (V$Archived_Log)
217(1)
RC_Backup_Controlfile (V$Backup_Datafile)
218(1)
RC_Backup_Corruption (V$Backup_Corruption)
218(1)
RC_Backup_Datafile (V$Backup_Datafile)
218(1)
RC_Backup_Files (V$Backup_Files)
218(1)
RC_Backup_Piece (V$Backup_Piece)
219(1)
RC_Backup_Redolog (V$Backup_Redolog)
219(1)
RC_Backup_Set (V$Backup_Set)
219(1)
RC_Backup_Spfile (V$Backup_Spfile)
219(1)
RC_Controlfile_Copy (V$Datafile_Copy)
219(1)
RC_Copy_Corruption (V$Copy_Corruption)
219(1)
RC_Database (V$Database)
220(1)
RC_Database_Block_Corruption (V$Database_Block_Corruption)
220(1)
Database_Incarnation (V$Database_Incarnation)
220(1)
RC_Datafile (V$Datafile)
220(1)
RC_Datafile_Copy (V$Datafile_Copy)
220(1)
RC_Log_History (V$Log_History)
221(1)
RC_Offline_Range (V$Offline_Range)
221(1)
RC_Redo_Log (V$Log, V$Logfile)
221(1)
RC_Redo_Thread (V$Thread)
221(1)
RC_Resync
221(1)
RC_Rman_Configuration (V$Rman_Configuration)
221(1)
RC_Tablespace (V$Tablespace)
222(1)
RC_Tempfile (V$Tempfile)
222(1)
Catalog Views Intended for Use by Oracle Enterprise Manager
222(3)
11 RMAN Backups
225(40)
Benefits of RMAN Backups vs. Scripted Backups
226(1)
RMAN Compatibility Issues
227(1)
Monitoring RMAN Backup Status
228(1)
Offline RMAN Database Backups
229(7)
Offline Backups Using Default Settings
229(1)
RMAN Workshop: Do an Offline Backup
230(2)
Offline Backups Without Using Configured Defaults
232(4)
Backup Command Options
236(10)
Multisection Backups
236(1)
Compression
236(2)
Tags and Restore Points
238(1)
Limiting Backup Impacts
238(1)
Limiting the Size of a Backup Set
239(1)
Backing Up to a Specific Device Type
240(1)
Modifying the Retention Policy for a Backup Set
240(2)
Archive Log Deletion Policies
242(1)
Overriding the configure exclude Command
243(1)
Checking the Database for Errors with the backup Command
243(1)
Skipping Offline, Inaccessible, or Read-Only Datafiles
243(1)
Forcing a Backup of Read-Only Datafiles
244(1)
Backing Up Datafiles Based on Their Last Backup Time
244(1)
Making Copies of Backups on Your RMAN Copier
245(1)
Capturing the Elusive Control File
246(1)
Introducing the set Command
246(1)
Online RMAN Database Backups
247(6)
Online Database Backups
247(1)
RMAN Workshop: Do an Online Backup
248(1)
Tablespace Backups
249(1)
Datafile Backups
250(1)
Archived Redo Log Backups
250(1)
Control File and Parameter File Backups
251(1)
Backup Set Backups
252(1)
Flash Recovery Area Backups
253(1)
Copies
253(2)
Introducing Image Copies
253(1)
Database, Tablespace, and Datafile Image Copies
253(1)
Control File Copies
254(1)
Archivelog Image Copies
255(1)
Incremental RMAN Backups
255(6)
The Block Change Tracking File
255(1)
The Base Backup
256(1)
Differential vs. Cumulative Incremental Backups
257(3)
RMAN Workshop: Do an Incremental Backup
260(1)
Getting Started
261(3)
RMAN Workshop: Get Your Database Backed Up!
261(3)
Summary
264(1)
RMAN Restore and Recovery
265(42)
RMAN Restore and Recovery Basics
266(1)
Before You Can Restore the Database
267(1)
Before RMAN Can Get Going
267(13)
A Note about Recoveries, the Recovery Catalog, and the MML Layer
268(1)
Restoring the SPFILE
269(4)
Restoring the Control File
273(1)
Recovering the Control File from an Autobackup Using RMAN and the FRA
274(5)
RMAN Workshop: Recover Your Control File
279(1)
The restore and recover Commands
280(1)
The restore Command
280(1)
The recover Command
281(1)
Restore and Recover the Database in Noarchivelog Mode
281(6)
Preparing for the Restore
281(2)
Restoring to a Different Location
283(3)
RMAN Workshop: Recover Your Noarchivelog Mode Database
286(1)
Database Recoveries in Archivelog Mode
287(6)
Point-of-Failure Database Recoveries
287(3)
RMAN Workshop: Complete Recovery of Your Archivelog Mode Databse
290(1)
Tablespace Recoveries
291(1)
Datafile Recoveries
292(1)
What if I Use Incremental Backups?
293(1)
Recovering from Online Redo Log Loss
293(4)
Loss of an Inactive Online Redo Log Group Member
294(1)
Loss of an Inactive Online Redo Log Group
295(1)
Loss of an Active but Not Current Online Redo Log Group
296(1)
Loss of the Current Online Redo Log Group
296(1)
The Data Recovery Advisor
297(6)
Using the Data Recovery Advisor Through RMAN
297(6)
Summary
303(4)
PART III Using RMAN Effectively
13 Using Oracle Enterprise Manager for Backup and Recovery
307(38)
Oracle Enterprise Manager: The New Paradigm
308(3)
Grid Control
311(2)
The Grid Control Architecture
312(1)
Installing and Configuring Grid Control
313(1)
Database Control
313(5)
The Database Control Architecture
313(2)
Installing and Configuring Database Control
315(1)
Using Enterprise Manager Configuration Assistant to Configure Database Control
316(1)
RMAN Workshop: Configure Database Control Using emca
316(2)
Configuring Backup Settings in Enterprise Manager
318(4)
Device Configuration
319(1)
Backup Set Configuration
319(1)
Policy Settings
320(1)
What is Missing from OEM's Backup Configuration?
321(1)
RMAN Workshop: Configure Backup Settings in OEM
321(1)
Configuring Recovery Settings
322(3)
Instance Recovery
322(1)
Media Recovery
323(1)
Flash Recovery
323(2)
RMAN Workshop: Configure Recovery Settings in OEM
325(1)
Configuring Recovery Catalogs in OEM
325(2)
RMAN Workshop: Register the Recovery Catalog with OEM
326(1)
Related Links for Recovery Catalog Settings
327(1)
Database Backups from Enterprise Manager
327(7)
Oracle-Suggested Backup Strategy
327(3)
Scheduling a Customized Backup
330(1)
RMAN Script Job vs. Scheduled Backup Wizard
331(1)
RMAN Workshop: Create an RMAN Script Job in OEM
332(2)
Performing Recovery in Enterprise Manager
334(7)
Data Recovery Advisor and the OEM Checkers
335(4)
User Directed Recovery
339(1)
RMAN Workshop: Perform Database Recovery from OEM
340(1)
Backup Management and Reporting
341(2)
Managing Current Backups
342(1)
Managing Restore Points
342(1)
Creating Backup Reports
343(1)
Database Cloning from Enterprise Manager
343(1)
Summary
344(1)
14 RMAN Advanced Recovery Topics
345(32)
Incomplete Recoveries
346(4)
Using the resetlogs Command
347(1)
Establishing a Point to Recover To
347(1)
Time-Based Recovery
348(1)
SCN-Based Recovery
348(1)
Log Sequence-Based Recovery
349(1)
Cancel-Based Recovery
349(1)
Recovery Using Restore Points
349(1)
Other RMAN Recovery Topics
350(6)
Read-Only Tablespace Recovery Considerations
350(1)
Archived Redo Log Restores
350(1)
Datafile Copy Restores
350(1)
Recovering Corrupted Data Blocks
351(2)
Recovering to a Previous Incarnation
353(3)
Tablespace Point-In-Time Recovery
356(10)
Performing Automated TSPITR
357(3)
Manual TSPITR
360(6)
TSPITR Restrictions
366(1)
Verifying Your Backups Are Recoverable
366(5)
The restore preview Command
367(2)
Restoring with the validate and check logical Commands
369(1)
Using the validate backupset Command
370(1)
Call the Movers! Cross-Platform Database Movement and RMAN
371(2)
Introduction to Cross-Platform Transportable Tablespaces
372(1)
Byte Ordering and Datafile Conversion
372(1)
We Like to Move It! Move It!
373(1)
Sometimes Things Just Go Wrong
374(2)
Summary
376(1)
15 Surviving User Errors: Flashback Technologies
377(22)
Prepared for the Inevitable: Flashback Technology
378(1)
Flashback Query
379(5)
Flashback and the Undo Segment: A Love Story
379(1)
Performing Flashback Query
380(1)
Flashback Versions Query with Oracle Enterprise Manager
380(1)
RMAN Workshop: Explore Flashback Versions Query
381(3)
Flashback Table
384(3)
Performing the Flashback Table Operation from SQL
384(1)
Flashback Table with Oracle Enterprise Manager
385(1)
RMAN Workshop: Explore Flashback Table
385(2)
Flashback Transaction
387(2)
RMAN Workshop: Utilize Flashback Transaction from Enterprise Manager
388(1)
Flashback Drop
389(4)
The Recycle Bin
389(2)
RMAN Workshop: Explore Flashback Drop and the Recycle Bin
391(2)
Flashback Database
393(4)
Flashback Logs
393(1)
Flashback Retention Target
394(1)
RMAN Workshop: Configure for Flashback Database
394(1)
Flashback Database: Tuning and Tweaking
395(1)
RMAN Workshop: Perform Flashback Database
396(1)
Flashback Data Archive (Total Recall)
397(1)
RMAN Workshop: Create a Flashback Data Archive
398(1)
Summary
398(1)
16 Maintaining RMAN
399(24)
RMAN Maintenance
400(18)
Cross-Checking RMAN Backups
400(2)
RMAN Workshop: Using the crosscheck Command
402(2)
Validation of RMAN Backups
404(1)
Backup Retention Policies
405(3)
The change Command
408(6)
RMAN Workshop: Using the change Command
414(2)
The delete Command
416(1)
RMAN Workshop: Using the delete Command
417(1)
Cataloging Other Backups in RMAN
417(1)
RMAN Stored Scripts
418(3)
Creating Stored Scripts
419(1)
Querying the Recovery Catalog for Stored Script Information
419(1)
Changing Stored Scripts
419(1)
Deleting Stored Scripts
419(1)
Using Stored Scripts
420(1)
Printing Stored Scripts
420(1)
RMAN Workshop: Using RMAN Stored Scripts
420(1)
When You Just Can't Take It Anymore
421(1)
Summary
421(2)
17 Monitoring and Reporting on RMAN
423(22)
The RMAN list Command
424(14)
Listing Incamations
424(1)
Listing Backups
425(10)
Listing Image Copies
435(3)
The RMAN report Command
438(3)
Reporting on Datafiles That Have Not Been Backed Up Recently
438(1)
Reporting on Backup Redundancy or Recovery Window
439(1)
Reporting on Unrecoverable Operations on Datafiles
439(1)
Reporting on the Database Schema
440(1)
Reporting on Obsolete Backups
440(1)
Data Dictionary Views for Reporting
441(2)
Summary
443(2)
18 Performance Tuning RMAN Backup and Recovery Operations
445(20)
Before You Tune RMAN
446(5)
RMAN Performance: What Can Be Achieved?
446(1)
Have the Right Hardware in Place
447(1)
Tune the Database
448(3)
Tuning RMAN
451(9)
Tuning RMAN Settings
451(3)
Tune the MML Layer
454(1)
Identifying Database-Related RMAN Issues
454(6)
Tracing RMAN Sessions
460(2)
Summary
462(3)
PART IV RMAN in the Oracle Ecosystem
19 Duplication: Cloning the Target Database
465(26)
RMAN Duplication: A Primer
466(8)
Why Use RMAN Duplication?
466(2)
Different Types of RMAN Duplication
468(1)
The Duplication Architecture
468(6)
Duplication: Location Considerations
474(7)
Duplication to the Same Server: An Overview
474(1)
Duplication to the Same Server, Different Oracle_Home
475(1)
Duplication to a Remote Server: An Overview
475(4)
Duplication and the Network
479(1)
RMAN Workshop: Build a Password File
479(2)
Duplication to the Same Server
481(3)
RMAN Workshop: Duplication to the Same Server, Using Disk Backups
482(2)
Using Tape Backups
484(1)
Duplication to a Remote Server
484(3)
RMAN Workshop: Duplication to a Remote Server, Using Disk Backups
485(2)
Using Tape Backups for Remote Server Duplication
487(1)
Target-Less Duplication in 11g
487(2)
Incomplete Duplication: Using the DBNEWID Utility
488(1)
Summary
489(2)
20 RMAN and Data Guard
491(10)
RMAN and the Standby Database
492(6)
Requirements for Using RMAN for Standby Database Creation
493(1)
The duplicate...for standby Command
494(1)
RMAN Workshop: Create a Standby Database Using RMAN
495(3)
Taking Backups from the Standby Database
498(2)
Datafile Backups from the Standby Database
499(1)
Archive Log Backups from the Standby Database
499(1)
Using Flashback Database for Standby Database Reinstantiation
500(1)
Summary
500(1)
21 RMAN and Real Application Clusters
501(16)
Real Application Clusters: Unique Backup Challenges
502(5)
Datafile Backups
503(1)
Archive Log Backups
504(3)
RAC Recovery Challenges
507(2)
Restore Operations
507(1)
Media Management Considerations During a Restore
508(1)
Recovery Considerations After a Restore
508(1)
Advanced RMAN/RAC Topics
509(7)
Duplication to a Single-Node System
509(1)
RMAN Workshop: Duplicating a RAC Database to a Single-Node Database
510(2)
The Single-Node Standby Database
512(1)
RMAN Workshop: Creating a Single-Node Standby Database from a RAC Database
512(3)
Backing Up the Multinode RAC Database
515(1)
Summary
516(1)
22 RMAN in Sync and Split Technology
517(14)
Sync and Split: Broken Mirror Backups
518(2)
Oracle Databases on Sync and Split Volumes
520(3)
Datafiles
521(1)
Control Files
522(1)
Redo Log Files
522(1)
Archive Logs
522(1)
Benefits of the Split Mirror Backup
523(1)
Fast Point-In-Time Recovery
523(1)
Speedy-Looking Backups
523(1)
Mounting a Split Mirror Volume on Another Server
523(1)
Taking Backups from the Split Mirror
524(1)
RMAN and Sync and Split
524(5)
Registering Split Mirror Copies with RMAN
524(1)
Taking RMAN Backups from the Split Mirror
525(1)
RMAN Workshop: Configure RMAN to Back Up from the Split Mirror
526(1)
Getting Sync and Split Functionality from Oracle Software
527(1)
Using a Standby Database, Flashback Database, and Incremental Apply for Sync and Split
527(1)
Benefits of the Oracle Sync and Split Solution
528(1)
Oracle-Integrated Shadow Copy Services for Windows
529(1)
Summary
529(2)
23 RMAN in the Workplace: Case Studies
531(102)
Before the Recovery
532(1)
What is the Exact Nature of the Failure?
532(1)
What Recovery Options Are Available?
533(1)
Might Oracle Support Be Needed?
533(1)
Who Can Act as a Second Pair of Eyes During Recovery?
533(1)
Recovery Case Studies
533(22)
Case #1: Recovering from Complete Database Loss (Noarchivelog Mode) with a Recovery Catalog
534(2)
Case #2: Recovering from Complete Database Loss (Noarchivelog Mode) Without a Recovery Catalog
536(1)
Case #3: Recovering from Complete Database Loss (Archivelog Mode) Without a Recovery Catalog
537(3)
Case #4: Recovering from Complete Database Loss (Archivelog Mode) with a Recovery Catalog
540(2)
Case #5: Recovering from the Loss of the System Tablespace
542(1)
Case #6: Recovering Online from the Loss of a Datafile or Tablespace
543(1)
Case #7: Recovering from Loss of an Unarchived Online Redo Log
544(1)
Case #8: Recovering Through resetlogs
545(2)
Case #9: Completing a Failed Duplication Manually
547(1)
Case #10: Using RMAN Duplication to Create a Historical Subset of the Target Database
548(2)
Case #11: Recovering from a Lost Datafile (Archivelog Mode) Using an Image Copy in the Flash Recovery Area
550(2)
Case #12: Recovering from Running the Production Datafile Out of the Flash Recovery Area
552(1)
Case #13: Using Flashback Database and Media Recovery to Pinpoint the Exact Moment to Open the Database with resetlogs
553(2)
Summary
555(4)
PART V Appendixes
A RMAN Syntax Reference Guide
559(62)
RMAN Reserved Words
560(2)
RMAN Command List
562(1)
RMAN Specifier and Operands Lists
563(1)
RMAN Command List Syntax Details
563(1)
@ Command
563(1)
@@ Command
564(1)
advise failure Command
564(1)
allocate channel Command
564(1)
allocate channel for maintenace Command
565(1)
alter database Command
566(1)
backup Command
566(6)
catalog Command
572(1)
change Command
573(1)
configure Command
574(4)
connect Command
578(1)
convert Command
578(2)
create catalog Command
580(1)
create script Command
580(1)
crosscheck Command
580(1)
delete Command
581(1)
delete script Command
582(1)
drop catalog Command
582(1)
drop database Command
583(1)
duplicate Command
583(3)
execute script Command
586(1)
exit Command
586(1)
flashback database Command
587(1)
grant Command
587(1)
host Command
588(1)
import catalog Command
588(1)
list Command
589(1)
print script Command
590(1)
quit Command
591(1)
recover Command
591(3)
register database Command
594(1)
release channel Command
594(1)
repair failure Command
594(1)
replace script Command
595(1)
report Command
595(1)
reset database Command
596(1)
restore Command
597(2)
resync catalog Command
599(1)
revoke Command
599(1)
run Command
600(1)
send Command
601(1)
set Command
602(2)
show Command
604(2)
shutdown Command
606(1)
spool Command
606(1)
SQL Command
606(1)
startup Command
607(1)
switch Command
607(1)
transport tablespace Command
608(1)
unregister database Command
609(1)
upgrade catalog Command
610(1)
validate Command
610(2)
RMAN Subclauses Syntax Details
612(1)
allocOperandList
612(1)
archivelogRecordSpecifier
613(1)
completedTimeSpec
614(1)
connectStringSpec
614(1)
datafileSpec
614(1)
deviceSpecifier
615(1)
fileNameConversionSpec
615(1)
forDbUniqueNameOption
615(1)
foreignlogRecordSpecifier
615(1)
formatSpec
616(1)
keepOption
616(1)
listObjList
616(1)
maintQualifier
617(1)
maintSpec
617(1)
obsOperandList
617(1)
recordSpec
618(1)
tempfileSpec
618(1)
toDestSpec
619(1)
untilClause
619(2)
B RMAN Scripting Examples
621(4)
RMAN Scripts for Windows
622(1)
Creating a Windows Script to Schedule Backups
622(1)
Scheduling the Backup
623(1)
RMAN Scripts for Unix
623(2)
C Setting Up an RMAN Test Environment
625(8)
The Test Box
627(1)
Match Your Production Environment
627(1)
Go Cheap
627(1)
The Oracle Configuration
628(1)
Multiple Homes
628(1)
Creating Databases
628(1)
Using Oracle ASM
629(1)
Oracle Enterprise Manager
629(1)
Media Management Considerations
629(1)
The RMAN Configuration
630(3)
Index 633
Robert G. Freeman is an Oracle Database 10g Oracle Certified Professional that has been working with Oracle databases for well over 15 years. He is a Principle Datababase Engineer for the Church of Jesus Christ of Latter-day Saints in Salt Lake City, Ut. He resides near Salt Lake with his wife, three of his five kids and cats, dogs and an airplane. Robert is the author or co-author of several Oracle Press titles including Oracle9i New Features, Oracle Database 10g New Features, Oracle9i RMAN Backup and Recovery and Portable DBA: Oracle.





Matthew Hart (Colorado Springs, CO) has worked exclusively with the Windows Operating System for more than 5 years, the last 3 of which have been with Oracle Corporation, assisting Oracle customer implement the RDBMS on Windows NT and 2000. From 1999 onward, his role has increasingly become focused on Oracles high availability solutions, specifically Oracle Recovery Manager and Oracle Advanced Replication. For the past 6 months he has been involved in the beta testing of Oracle9i, and he currently supports beta customers who are rolling out 9i into the enterprise. Matthew became an Oracle Certified Professional in May 1999.