Book description
This authoritative Oracle Press resource on RMAN has been thoroughly revised to cover every new feature, offering the most up-to-date information
This fully updated volume lays out the easiest, fastest, and most effective methods of deploying RMAN in Oracle Database environments of any size. Keeping with previous editions, this book teaches computing professionals at all skill levels how to fully leverage every powerful RMAN tool and protect mission-critical data.
Oracle Database 12c RMAN Backup and Recovery explains how to generate reliable archives and carry out successful system restores. You will learn to work from the command line or GUI, automate the database backup process, perform Oracle Flashback recoveries, and deploy third-party administration utilities. The book features full details on cloud computing, report generation, performance tuning, and security.
- Offers up-to-date coverage of Oracle Database 12c new features
- Examples and workshops throughout walk you through important RMAN operations
Table of contents
- 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
Product information
- Title: Oracle Database 12c Oracle RMAN Backup & Recovery
- Author(s):
- Release date: April 2016
- Publisher(s): McGraw Hill Computing
- ISBN: 9780071847445
You might also like
book
Oracle Database 12c Backup and Recovery Survival Guide
A comprehensive guide for every DBA to learn recovery and backup solutions A practical reference to …
book
Oracle Database 12c New Features
Maximize the New and Improved Features of Oracle Database 12 c Written by Master Principle Database …
book
Oracle Database 12c The Complete Reference
Master the Cutting-Edge Features of Oracle Database 12c Maintain a scalable, highly available enterprise platform and …
book
Oracle Database 12c Security
Best Practices for Comprehensive Oracle Database Security Written by renowned experts from Oracle's National Security Group, …