Oracle RMAN 11g Backup and Recovery (195 page)

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

• 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
  
  • A
    
  • B
    
  • C
    
  • D
    
  • E
    
  • F
    
  • G
    
  • H
    
  • I
    
  • J
    
  • K
    
  • L
    
  • M
    
  • N
    
  • O
    
  • P
    
  • Q
    
  • R
    
  • S
    
  • T
    
  • U
    
  • V
    
  • W