PART IV RMAN in a Highly Available Architecture
by Matthew Hart, Robert Freeman
Oracle Database 12c Oracle RMAN Backup & Recovery
- Cover
- Title Page
- Copyright Page
- Dedication
- About the Authors
- Contents at a Glance
- Contents
- Acknowledgments
- Introduction
- PART I Getting Started with RMAN in Oracle Database 12c
- 1 Quick-Start Guide for RMAN and Oracle Database 12c
- 2 Oracle Database 12c Backup and Recovery Architecture Tour
- What This Book Is About
- I’m Already an RMAN Expert—Why Do I Need This Book or This Chapter?
- Let’s Kick Off the Tour
- Backup and Recovery Essentials
- A Few Oracle Terms to Know
- Oracle Database Architecture in the Pre-Multitenant Age
- The Combined Picture
- More Oracle Database Internals
- Controlling the Database Software
- Oracle Backup and Recovery Primer
- Summary
- 3 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 Fast Recovery Area
- Summary
- 4 Oracle Database 12c Multitenant
- PART II RMAN Configuration, Backup, and Recovery Essentials
- 5 RMAN Setup and Configuration
- Configuring Your Database to Run in ARCHIVELOG Mode
- The Oracle Database 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
- 6 The RMAN Recovery Catalog
- What Is the Recovery Catalog?
- Creating the Recovery Catalog Owning Schema in a Nonmultitenant Database
- RMAN Workshop: Create the Recovery Catalog User Account
- Creating the Recovery Catalog–Owning Schema in a Multitenant Database
- Creating the Recovery Catalog Schema Objects
- RMAN Workshop: Create the Recovery Catalog
- RMAN Workshop: Register Your Database in the Recovery Catalog
- Utilizing an RMAN Virtual Private Catalog
- RMAN Workshop: Create a Virtual Private Catalog for Oracle 12.1.0.1 and Earlier Databases
- Merging Multiple Recovery Catalogs
- RMAN Stored Scripts
- Recovery Catalog Maintenance
- Backing Up the Recovery Catalog
- Recovery Catalog Views
- Summary
- What Is the Recovery Catalog?
- 7 RMAN Backups
- Using the RMAN Backup Command
- RMAN Backup Command Options
- Backing Up to a Specific Device Type
- Controlling Attributes of Backup Sets and Backup Set Pieces
- Multisection Backups
- RMAN Compression
- Tags
- Restore Points
- The duration Command: Putting Limits on Backups
- Archival Backups
- Overriding the Configure Exclude Command
- Skipping Offline, Inaccessible, or Read-Only Datafiles
- Override Backup Optimization
- Backing Up Datafiles Based on Their Last Backup Time
- Checking for Logical Corruption during a Backup
- Making Copies of Backups on Your RMAN Copier
- Capturing the Elusive Control File
- Using the RMAN Set Command
- Offline RMAN Database Backups
- Online RMAN Database Backups
- Variations on a Theme: Other Types of RMAN Online Backups
- Copies
- Incremental RMAN Backups
- Incrementally Updated Backups
- Getting Started
- RMAN Best Practices Introduced in This Chapter
- Summary
- 8 RMAN Restore and Recovery
- RMAN Restore and Recovery Basics
- Types of Oracle Database Recoveries
- About Restoring Multitenant Databases
- Preparing for an RMAN Restore
- Staging RMAN Backup Set Pieces for Restores
- Restore and Recover the Database in NOARCHIVELOG Mode
- Database Recoveries in ARCHIVELOG Mode
- Recovering from Online Redo Log Loss
- The Data Recovery Advisor
- Summary
- 9 Advanced RMAN Recovery Topics
- Recovery of Pluggable Databases
- Incomplete Database Recoveries on Non-CDB and Entire CDB Databases
- Performing Incomplete Recoveries of Pluggable Databases (PDB)
- Other RMAN Recovery Topics
- Table and Partition Point-in-Time Recovery
- Prerequisites for Restoring and Recovering Database Tables and Partitions
- Restrictions on Restoring and Recovering Database Tables and Partitions
- Options to Consider when Restoring Tables and Partitions
- How RMAN Implements the Restore and Recovery of Tables and Partitions
- Restoring Tables and Partitions from PDBs
- Using RMAN to Restore and Recover a Database Table: An Example
- Tablespace Point-in-Time Recovery
- Summary
- 10 Duplication: Cloning the Target Database
- 5 RMAN Setup and Configuration
- PART III RMAN Maintenance and Administration
- 11 Maintaining RMAN
- RMAN Maintenance
- Verifying Your Backups
- The Restore…Preview Command
- Using the Restore…Validate and Check Logical Commands
- Using the validate Command
- Backup Retention Policies
- Archive Log Retention Policies
- The Change Command
- RMAN Workshop: Using the Change Command
- The Delete Command
- RMAN Workshop: Using the Delete Command
- Cataloging Other Backups in RMAN
- RMAN Stored Scripts
- When You Just Can’t Take It Anymore
- Summary
- 12 Monitoring and Reporting in RMAN
- 13 Performance Tuning RMAN Backup and Recovery Operations
- 14 Using Oracle Cloud Control for Backup and Recovery
- 11 Maintaining RMAN
- PART IV RMAN in a Highly Available Architecture
- 15 RMAN Best Practices
- 16 Surviving User Errors: Flashback Technologies
- 17 RMAN and Data Guard
- 18 RMAN and Real Application Clusters
- 19 Zero Data Loss Recovery Appliance: Evolution of RMAN to Enterprise-wide Database Protection Solution
- 20 RMAN in the Workplace: Case Studies
- Before the Recovery
- Recovery Case Studies
- Case #1: Recovering from Complete Database Loss (NOARCHIVELOG Mode) with a Recovery Catalog
- Case #2: Recovering from Complete Database Loss (NOARCHIVELOG Mode) Without a Recovery Catalog
- Case #3: Recovering from Complete Database Loss (ARCHIVELOG Mode) Without a Recovery Catalog
- Case #4: Recovering from Complete Database Loss (ARCHIVELOG Mode) with a Recovery Catalog
- Case #5: Recovering from the Loss of the SYSTEM Tablespace
- Case #6: Recovering Online from the Loss of a Datafile or Tablespace
- Case #7: Recovering from Loss of an Unarchived Online Redo Log
- Case #8: Recovering Through resetlogs
- Case #9: Completing a Failed Duplication Manually
- Case #10: Using RMAN Duplication to Create a Historical Subset of the Target Database
- Case #11: Recovering from a Lost Datafile (ARCHIVELOG Mode) Using an Image Copy in the Fast Recovery Area
- Case #12: Recovering from Running the Production Datafile Out of the Fast Recovery Area
- Case #13: Using Flashback Database and Media Recovery to Pinpoint the Exact Moment to Open the Database with resetlogs
- Summary
- PART V RMAN Media Management
- 21 Media Management Considerations
- 22 Oracle Secure Backup
- 23 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
- Listing RMAN Backups and Backup Sets Stored on S3
- Licensing Considerations
- Summary
- 24 Enhancing RMAN with Veritas NetBackup for Oracle
- 25 Configuring HP Data Protector for Oracle
- 26 RMAN and Tivoli Storage Manager
- 27 RMAN and CommVault Simpana
- PART VI Appendixes
- Index
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.