RMAN process from start to
V$ACTIVE_SESSION_HISTORY
NetBackup for Oracle
finish, 55
view
, 457
V$FLASHBACK_DATABASE_LOG
tracking SYS.DBMS_BACKUP_
validate backupset command,
view
, 395
REST
ORE package, 44
370–371
V$FLASHBACK_DATABASE_STAT
viewing RMAN channel
validate command
view
, 395–396
processes, 42
check logical option, 404
V$FLASH_RECOVERY_AREA_USAGE
viewing RMAN server
syntax details, 610–612
view
, 69
processes, 42
validating RMAN backups,
views
VSS (Volume Shadow Copy Service)
404–405
DRA data dictionary
, 302
for W
indows, 237
validate parameter, backup command,
Flashback Database, 395–396
V$TABLESPACE view
, 222
243, 369
managing FRA, 67–69
V$TEMPFILE view
, 222
validateObject parameter syntax
recovery catalog, 217–222
V$THREAD view
, 221
diagram, validate command, 611
RMAN performance tuning,
V$TRANSPORTABLE_PLATFORM
validateOperand parameter syntax
454–460
view
, 372–373
diagram, validate command, 612
V$, for reporting, 441–442
V$UNDOSTAT view
, 379
validation, of RMAN backups,
V$IR_FAILURE view, Data Recovery
404–405
Advisor
, 302
W
V$ARCHIVED_LOG view
, 217,
V$IR_FAILURE_SET view, Data
499–500
Recovery Advisor
, 302
W
eb tool, OSB, 117, 126–127
V$BACKUP_ASYNC_IO view,
V$IR_MANUAL_CHECKLIST view,
Whole Database Recovery, OEM
457–460
Data Recovery Advisor
, 302
defined, 339
V$BACKUP_CORRUPTION view,
V$IR_REPAIR view, Data Recovery
performing, 340–341
218, 351–352
Advisor
, 302
recover to current or previous
V$BACKUP_DATAFILE view
, 218
V$LOG view
point in time, 339
V$BACKUP_FILES view
, 218–219
log sequence number of online
recovery from previously restored
V$BACKUP_PIECE view
, 219
redo logs, 9
datafiles, 340
V$BACKUP_REDOLOG view
, 219
recovery catalog, 221
recovery scope less than entire
V$BACKUP_SET view
, 219
status of online redo log group,
database, 342
V$BACKUP_SPFILE view
, 219
17–18
restore all datafiles, 339–340
V$BACKUP_SYNC_IO view
, 457–460
V$LOGFILE view
, 221
Windows OS
V$BLOCK_CHANGE_TRACKING
V$LOG_HISTORY view
, 221
RMAN scripts for
, 621–622
view
, 256
V$OFFLINE_RANGE view
, 221
scheduled backups on, 623
V$COPY_CORRUPTION view,
VPC (virtual private catalog),
Volume Shadow Copy Service
219, 352
creating, 213
for
, 237
VCTF (block change tracking file),
V$RECOVERY_FILE_DEST view,
write operations, performance issues,
255–256, 320
68, 405
455–456
Document Outline
- Contents
- Acknowledgments
- Introduction
- Part I: Getting Started with RMAN in Oracle Database 11g
- 1 Oracle Database 11g Backup and Recovery Architecture Tour
- Backup and Recovery Essentials
- A Few Oracle Terms to Know
- Controlling the Database Software
- Oracle Architecture
- Oracle Memory and RMAN
- More About the Oracle Redo Logs
- The Combined Picture
- Oracle Backup and Recovery Primer
- Summary
- 2 Introduction to the RMAN Architecture
- Server-Managed Recovery
- The RMAN Utility
- The Network Topology of RMAN Backups
- The Database Control File
- The RMAN Server Processes
- The SYS Packages Used by RMAN
- Backing Up the Data Block
- RMAN in Memory
- The Recovery Catalog
- The Auxiliary Database
- Compatibility Issues
- The RMAN Process: From Start to Finish
- The Flash Recovery Area
- Summary
- Part II: Setup Principles and Practices
- 3 RMAN Setup and Configuration
- Configuring Your Database to Run in ARCHIVELOG Mode
- The Oracle Database 11g Fault Diagnosability Infrastructure
- The RMAN Command Line
- Configuring the Database for RMAN Operations
- Configuring RMAN Default Settings
- Summary of RMAN Configuration Tasks
- Other Backup and Recovery Setup and Configuration Considerations
- Summary
- 4 Media Management Considerations
- Tape Backups in a Disk Backup World
- RMAN and the Media Manager: An Overview
- The SBT API
- Back Up to Tape: From Start to Finish
- Restore from Tape: From Start to Finish
- Using sbttest and loadsbt.exe
- Media Management Errors
- Summary
- 5 Oracle Secure Backup
- Features of Oracle Secure Backup
- Oracle Secure Backup Interfaces
- Oracle Secure Backup Components
- Installing and Configuring Oracle Secure Backup
- Oracle Database and File System Data Backup Using Oracle Secure Backup
- Oracle Database Backup Using Oracle Secure Backup Cloud Module
- Summary
- 6 Backing Up to Amazon Web Services Using the Oracle Secure Backup Cloud Module
- Conventional Backups: Assumptions and Limitations
- The Oracle Secure Backup Cloud Module
- What Is Cloud Computing?
- Oracle and the Amazon Cloud
- Oracle Cloud Backup Advantages
- Performing Backups by Using the OSB Cloud Module
- Licensing Considerations
- Summary
- 7 Enhancing RMAN with VERITAS NetBackup� for Oracle
- Key Features
- Necessary Components
- Storage/Media Device Configuration
- NetBackup Installation
- How to Link Oracle to NetBackup Media Manager
- Architecture
- Configuring NetBackup Policies
- Managing Expired Backup Images
- RMAN Sample Scripts
- Troubleshooting
- Security Best Practices
- Cost Justification
- Summary
- 8 Configuring HP Data Protector for Oracle
- Integration of Oracle and Data Protector
- RMAN Backup Configuration on Data Protector
- RMAN Backup
- Restoring Oracle Using the Data Protector GUI
- Oracle RMAN Metadata and Data Protector Media Management Database Synchronization
- Summary
- 9 RMAN and Tivoli Storage Manager
- Overview of Tivoli Storage Manager
- Performing an RMAN Backup Using TDPO
- Deleting Database Backups
- Troubleshooting Common Backup Scenarios
- Additional Troubleshooting
- Summary
- 10 Using the Recovery Catalog
- What Is the Recovery Catalog?
- Merging Multiple Recovery Catalogs
- Recovery Catalog Maintenance
- Backing Up the Recovery Catalog
- Recovery Catalog Views
- 11 RMAN Backups
- Benefits of RMAN Backups vs. Scripted Backups
- RMAN Compatibility Issues
- Monitoring RMAN Backup Status
- Offline RMAN Database Backups
- Backup Command Options
- Introducing the set Command
- Online RMAN Database Backups
- Copies
- Incremental RMAN Backups
- Getting Started
- Summary
- 12 RMAN Restore and Recovery
- RMAN Restore and Recovery Basics
- Before You Can Restore the Database
- Before RMAN Can Get Going
- The restore and recover Commands
- Restore and Recover the Database in NOARCHIVELOG Mode
- Database Recoveries in ARCHIVELOG Mode
- Recovering from Online Redo Log Loss
- The Data Recovery Advisor
- Summary
- Part III: Using RMAN Effectively
- 13 Using Oracle Enterprise Manager for Backup and Recovery
- Oracle Enterprise Manager: The New Paradigm
- Grid Control
- Database Control
- Configuring Backup Settings in Enterprise Manager
- Configuring Recovery Settings
- Configuring Recovery Catalogs in OEM
- Database Backups from Enterprise Manager
- Performing Recovery in Enterprise Manager
- Backup Management and Reporting
- Database Cloning from Enterprise Manager
- Summary
- 14 RMAN Advanced Recovery Topics
- Incomplete Recoveries
- Other RMAN Recovery Topics
- Tablespace Point-In-Time Recovery
- Verifying Your Backups Are Recoverable
- Call the Movers! Cross-Platform Database Movement and RMAN
- We Like to Move It! Move It!
- Sometimes Things Just Go Wrong
- Summary
- 15 Surviving User Errors: Flashback Technologies
- Prepared for the Inevitable: Flashback Technology
- Flashback Query
- Flashback Table
- Flashback Transaction
- Flashback Drop
- Flashback Database
- Flashback Data Archive (Total Recall)
- Summary
- 16 Maintaining RMAN
- RMAN Maintenance
- RMAN Stored Scripts
- When You Just Can�t Take It Anymore
- Summary
- 17 Monitoring and Reporting on RMAN
- The RMAN list Command
- The RMAN report Command
- Data Dictionary Views for Reporting
- Summary
- 18 Performance Tuning RMAN Backup and Recovery Operations
- Before You Tune RMAN
- Tuning RMAN
- Tracing RMAN Sessions
- Summary
- Part IV: RMAN in the Oracle Ecosystem
- 19 Duplication: Cloning the Target Database
- RMAN Duplication: A Primer
- Duplication: Location Considerations
- Duplication to the Same Server
- Duplication to a Remote Server
- Target-Less Duplication in 11g
- Summary
- 20 RMAN and Data Guard
- RMAN and the Standby Database
- Taking Backups from the Standby Database
- Summary
- 21 RMAN and Real Application Clusters
- Real Application Clusters: Unique Backup Challenges
- RAC Recovery Challenges
- Advanced RMAN/RAC Topics
- Summary
- 22 RMAN in Sync and Split Technology
- Sync and Split: Broken Mirror Backups
- Oracle Databases on Sync and Split Volumes
- Benefits of the Split Mirror Backup
- RMAN and Sync and Split
- Oracle-Integrated Shadow Copy Services for Windows
- Summary
- 23 RMAN in the Workplace: Case Studies
- Before the Recovery
- Recovery Case Studies
- Summary
- Part V: Appendixes
- A: RMAN Syntax Reference Guide
- RMAN Reserved Words
- RMAN Command List
- RMAN Specifier and Operands Lists
- RMAN Command List Syntax Details
- RMAN Subclauses Syntax Details
- B: RMAN Scripting Examples
- RMAN Scripts for Windows
- RMAN Scripts for Unix
- C: Setting Up an RMAN Test Environment
- The Test Box
- The Oracle Configuration
- The RMAN Configuration
- Index