Book description
It's sometimes said that the true job of an Oracle database administrator can be summed up in one, essential skill: to be able to recover your database.
There's much wisdom in that statement. Of all the things you are responsible for as a database administrator, nothing is more important than the data itself. Like it or not, the fearsome responsibility of protecting your organization's most critical data falls squarely upon your shoulders:
Lose that data and your company could fail.
Lose that data and you could be out of a job.
Scared? You should be. But there's help. You are not alone. Oracle experts Darl Kuhn, Sam Alapati, and Arup Nanda have come together in this book to show you the power of Recovery Manager, or RMAN, which is Oracle's backup and recovery tool of choice. RMAN Recipes for Oracle Database 11g helps you take advantage of all that RMAN has to offer by providing easy-to-understand solutions to business-critical backup and recovery operations. This handy guide:
Demystifies the steps required to protect your business data
Provides ready-made and step-by-step solutions to simple and complex backup, restore, and recovery operations
Is task-oriented, making it easy for you to find the solution to pressing backup and recovery problems
Respects your time by providing example-based solutions, not endless reading material
When the pressure's on, you don't have time for long discussions of theory. This book gets right to the point with quick and easy-to-read, step-by-step solutions that can help you backup and recover your data with confidence.
What you'll learn
Oracle Database experts Darl Kuhn, Sam Alapati, and Arup Nanda show you how to
Reliably back up and recover your database using Oracle's Recovery Manager
Utilize new Oracle Database 11g features such as the Data Recovery Advisor
Let Oracle Database manage your backup files via the Flash Recovery Area
Automate backup and recovery tasks by writing scripts
Troubleshoot RMAN problems and optimize RMAN performance
Interface with a Media Management Layer to manage your backup tape library
Recover from the loss of a control file, loss of an online redo log, and other (hopefully!) unusual situations
Who this book is for
Oracle database administrators responsible for database backup and recovery operations.
Table of contents
- Title Page
- Dedication
- Contents at a Glance
- Contents
- Foreword
- About the Authors
- About the Technical Reviewer
- Acknowledgments
- Introduction
- CHAPTER 1: Backup and Recovery 101
- CHAPTER 2: Jump-Starting RMAN
-
CHAPTER 3: Using the Flash Recovery Area
- 3-1. Creating the Flash Recovery Area
- 3-2. Writing Regular RMAN Backups to the FRA
- 3-3. Freeing FRA Space in an Emergency
- 3-4. Checking Space Usage in the FRA
- 3-5. Expanding or Shrinking the FRA
- 3-6. Configuring Archived Redo Logs to Go to FRA
- 3-7. Using the Same FRA for Two Databases with the Same Name
- 3-8. Placing a Control File in the FRA
- 3-9. Placing Online Redo Log Files in FRA
- 3-10. Sending Image Copies to the FRA
- 3-11. Deleting Backup Sets from the FRA
- 3-12. Deleting Archived Redo Logs from the FRA
- 3-13. Reinstating a Damaged Datafile from an Image Copy
- 3-14. Switching Back from an Image Copy
- 3-15. Backing Up the FRA to Tape
- 3-16. Sizing the Flash Recovery Area
-
CHAPTER 4: Using RMAN
- 4-1. Starting the RMAN Client
- 4-2. Issuing RMAN Commands
- 4-3. Saving RMAN Output to a Text File
- 4-4. Logging Command-Line RMAN Output
- 4-5. Connecting to a Target Database from the RMAN Prompt
- 4-6. Connecting to a Target Database from the Operating System Command Line
- 4-7. Executing Operating System Commands from Within RMAN
- 4-8. Scripting RMAN
- 4-9. Executing RMAN Command Files
- 4-10. Creating Dynamic Command Files
- 4-11. Connecting to an Auxiliary Database
- 4-12. Executing Multiple RMAN Commands As a Single Unit
- 4-13. Issuing SQL Statements from the RMAN Client
- 4-14. Starting and Shutting Down a Database with RMAN
- 4-15. Checking the Syntax of RMAN Commands
- 4-16. Hiding Passwords When Connecting to RMAN
- 4-17. Identifying RMAN Server Sessions
- 4-18. Dropping a Database using the RMAN Client
-
CHAPTER 5: Configuring the RMAN Environment
- 5-1. Showing RMAN Configuration Settings
- 5-2. Configuring RMAN
- 5-3. Restoring Default Parameter Settings
- 5-4. Enabling and Disabling Automatic Control File Backups
- 5-5. Specifying the Autobackup Control File Directory and Filename
- 5-6. Specifying the Snapshot Control Filename and Location
- 5-7. Specifying the Retention Period for RMAN History
- 5-8. Configuring the Default Device Type
- 5-9. Configuring the Default Backup Type
- 5-10. Making Compressed Backup Sets the Default
- 5-11. Configuring Multiple Backup Copies
- 5-12. Skipping Previously Backed Up Files
- 5-13. Specifying Backup Piece Filenames
- 5-14. Generating Filenames for Image Copies
- 5-15. Tagging RMAN Backups
- 5-16. Configuring Automatic Channels
- 5-17. Manually Allocating RMAN Channels
- 5-18. Allocating an RMAN Maintenance Channel
- 5-19. Creating a Backup Retention Policy
- 5-20. Configuring an Archived Redo Log Deletion Policy
- 5-21. Limiting the Size of Individual Backup Pieces
- 5-22. Configuring the Maximum Size of Backup Sets
-
CHAPTER 6: Using the Recovery Catalog
- 6-1. Creating the Recovery Catalog
- 6-2. Granting Restricted Access
- 6-3. Connecting to the Catalog from the Command Line
- 6-4. Connecting to the Catalog from the RMAN Prompt
- 6-5. Registering Target Databases
- 6-6. Unregistering a Database
- 6-7. Cataloging Older Files
- 6-8. Updating the Recovery Catalog
- 6-9. Dropping the Recovery Catalog
- 6-10. Merging Recovery Catalogs
- 6-11. Moving the Recovery Catalog to Another Database
- 6-12. Creating a High-Availability Recovery Catalog
- 6-13. Viewing Backup Information
- 6-14. Uncataloging RMAN Records
- 6-15. Using a Release 11.x Client with Older Catalogs
-
CHAPTER 7: Making Backups with RMAN
- Backup Sets and Image Copies
- RMAN Backup Modes
- Types of Files That RMAN Can Back Up
- RMAN Backup Destinations
- 7-1. Specifying Backup Options
- 7-2. Backing Up the Control File
- 7-3. Backing Up the Server Parameter File
- 7-4. Backing Up Datafiles
- 7-5. Backing Up Tablespaces
- 7-6. Making a Whole-Database Backup
- 7-7. Backing Up Archived Redo Logs
- 7-8. Backing Up Everything
- 7-9. Backing Up Flash Recovery Files
- 7-10. Performing Incremental Backups
- 7-11. Reducing Incremental Backup Time
- 7-12. Creating Multiple Backup Sets
- 7-13. Making Copies of Backup Sets
- 7-14. Making Copies of Image Copy Backups
- 7-15. Making Tape Copies of Disk-Based Image Copies
- 7-16. Excluding a Tablespace from a Backup
- 7-17. Skipping Read-Only, Offline, or Inaccessible Files
- 7-18. Encrypting RMAN Backups
- 7-19. Making a Compressed Backup
- 7-20. Parallelizing Backups
- 7-21. Making Faster Backups of Large Files
- 7-22. Specifying Backup Windows
- 7-23. Reusing RMAN Backup Files
- 7-24. Retaining Backups for a Long Time
- 7-25. Backing Up Only Those Files Previously Not Backed Up
- 7-26. Restarting Backups After a Crash
- 7-27. Updating Image Copies
-
CHAPTER 8: Maintaining RMAN Backups and the Repository
- 8-1. Adding User-Made Backups to the Repository
- 8-2. Finding Datafiles and Archivelogs That Need a Backup
- 8-3. Finding Datafiles Affected by Unrecoverable Operations
- 8-4. Identifying Obsolete Backups
- 8-5. Displaying Information About Database Files
- 8-6. Listing RMAN Backups
- 8-7. Listing Expired Backups
- 8-8. Listing Only Recoverable Backups and Copies
- 8-9. Listing Restore Points
- 8-10. Listing Database Incarnations
- 8-11. Updating the RMAN Repository After Manually Deleting Backups
- 8-12. Synchronizing the Repository with the Actual Backups
- 8-13. Deleting Backups
- 8-14. Deleting Archived Redo Logs
- 8-15. Deleting Obsolete RMAN Backups
- 8-16. Changing the Status of an RMAN Backup Record
- 8-17. Changing the Status of Archival Backups
- 8-18. Testing the Integrity of an RMAN Backup
- 8-19. Validating Datafiles, Backup Sets, and Data Blocks
-
CHAPTER 9: Scripting RMAN
- Approaches to Scripting
- 9-1. Developing a Unix Shell Script for RMAN
- 9-2. Scheduling a Unix Shell File
- 9-3. Developing a Windows Batch File to Run RMAN
- 9-4. Scheduling a Script in Windows via the GUI
- 9-5. Changing the Schedule of a Batch Job in the Task Scheduler
- 9-6. Scheduling in Windows from the Command Line
- 9-7. Creating Local-Stored Scripts
- 9-8. Creating a Global-Stored Script
- 9-9. Updating Stored Scripts
- 9-10. Commenting on Stored Scripts
- 9-11. Displaying Stored Scripts
- 9-12. Listing Stored Scripts
- 9-13. Dropping Stored Scripts
- 9-14. Executing a Global Script When a Local Script of the Same Name Exists
- 9-15. Converting Stored Scripts to Files
- 9-16. Creating or Replacing a Stored Script from a File
- 9-17. Passing Parameters to Stored Scripts
- 9-18. Creating a Parameterized Command File Script
-
CHAPTER 10: Restoring the Control File
- 10-1. Restoring Control File Using Flash Recovery Area
- 10-2. Restoring Control File Using Recovery Catalog
- 10-3. Determining the Database Identifier
- 10-4. Restoring Control File with No Flash Recovery Area or Recovery Catalog
- 10-5. Restoring Control File to Nondefault Location
- 10-6. Restoring Lost Copy of Multiplexed Control File
- 10-7. Re-creating the Control File
-
CHAPTER 11: Performing Complete Recovery
- Background
- If You're Still Awake...
- 11-1. Determining How to Restore and Recover
- 11-2. Previewing Backups Needed for Restore
- 11-3. Verifying Integrity of Backups
- 11-4. Testing Media Recovery
- 11-5. Performing Database-Level Recovery
- 11-6. Performing Tablespace-Level Recovery
- 11-7. Performing Datafile-Level Recovery
- 11-8. Restoring Datafiles to Nondefault Locations
- 11-9. Performing Block-Level Recovery
- 11-10. Recovering Read-Only Tablespaces
- 11-11. Restoring Temporary Tablespaces
- 11-12. Forcing RMAN to Restore a File
- 11-13. Restoring from an Older Backup
- 11-14. Recovering Through Resetlogs
- 11-15. Restoring the Spfile
- 11-16. Restoring Archived Redo Log Files
- 11-17. Recovering Datafiles Not Backed Up
- 11-18. Deleting Archived Redo Log Files During Recovery
- 11-19. Restoring from Uncataloged Backup Pieces in Oracle Database 10g and Newer
- 11-20. Restoring from Uncataloged Backup Pieces in Oracle9i Database and Older
-
CHAPTER 12: Performing Incomplete Recovery
- Background
- 12-1. Determining Type of Incomplete Recovery
- 12-2. Performing Time-Based Recovery
- 12-3. Performing Log Sequence–Based Recovery
- 12-4. Performing Cancel-Based Recovery
- 12-5. Using LogMiner to Find an SCN
- 12-6. Performing Change/SCN-Based Recovery
- 12-7. Recovering to a Restore Point
- 12-8. Restoring a Noarchivelog Mode Database
- 12-9. Recovering to a Previous Incarnation
- 12-10. Performing Tablespace Point-in-Time Recovery
- 12-11. Recovering a Subset of Datafiles
- 12-12. Troubleshooting Incomplete Recovery
-
CHAPTER 13: Performing Flashback Recovery
- Introducing Flashback
- 13-1. Checking the Flashback Status of a Database
- 13-2. Enabling Flashback on a Database
- 13-3. Disabling Flashback on a Database
- 13-4. Flashing Back a Database from RMAN
- 13-5. Flashing Back a Database from SQL
- 13-6. Finding Out How Far Back into the Past You Can Flash Back
- 13-7. Estimating the Amount of Flashback Logs Generated at Various Times
- 13-8. Estimating the Space Occupied by Flashback Logs in the Flash Recovery Area
- 13-9. Creating Normal Restore Points
- 13-10. Creating Guaranteed Restore Points
- 13-11. Listing Restore Points
- 13-12. Dropping Restore Points
- 13-13. Recovering a Dropped Table
- 13-14. Undropping a Table When Another Exists with the Same Name
- 13-15. Undropping a Specific Table from Two Dropped Tables with the Same Name
- 13-16. Checking the Contents of the Recycle Bin
- 13-17. Restoring Dependent Objects of an Undropped Table
- 13-18. Turning Off the Recycle Bin
- 13-19. Clearing the Recycle Bin
- 13-20. Querying the History of a Table Row (Flashback Query)
- 13-21. Flashing Back a Specific Table
-
CHAPTER 14: Handling Online Redo Log Failures
- How Redo Logs Work
- 14-1. Determining How to Restore
- 14-2. Restoring After Losing One Member of the Multiplexed Group
- 14-3. Recovering After Loss of All Members of the INACTIVE Redo Log Group
- 14-4. Recovering After Loss of All Members of the ACTIVE Redo Log Group
- 14-5. Recovering After Loss of All Members of the CURRENT Redo Log Group
-
CHAPTER 15: Duplicating Databases and Transporting Data
- 15-1. Renaming Files in a Duplicate Database
- 15-2. Creating a Duplicate Database on the Same Host
- 15-3. Duplicating a Database Without Any RMAN Backups
- 15-4. Creating a Duplicate Database on a Remote Host with the Same File Structure
- 15-5. Duplicating a Database with Several Directories
- 15-6. Creating a Standby Database on a New Host
- 15-7. Duplicating a Database to a Past Point in Time
- 15-8. Skipping Tablespaces During Database Duplication
- 15-9. Duplicating a Database with a Specific Backup Tag
- 15-10. Resynchronizing a Duplicate Database
- 15-11. Transporting Tablespaces on the Same OS Platform
- 15-12. Transporting Tablespaces Across Different Operating System Platforms
- 15-13. Transporting an Entire Database to a Different Platform
- 15-14. Transporting a Database by Converting Datafiles on the Target Platform
-
CHAPTER 16: Tuning RMAN
- 16-1. Identifying RMAN Processes
- 16-2. Measuring Backup Performance
- 16-3. Monitoring RMAN Job Progress
- 16-4. Identifying I/O Bottlenecks
- 16-5. Improving Tape I/O Performance
- 16-6. Maximizing Throughput to Backup Device
- 16-7. Setting Large Pool Memory Size
- 16-8. Tuning Media Recovery
- 16-9. Tuning Crash Recovery
- 16-10. Slowing RMAN Down
- 16-11. Improving Performance Through Parallelism
- 16-12. Improving Performance Using Incremental Features
-
CHAPTER 17: Troubleshooting RMAN
- 17-1. Determining Where to Start
- 17-2. Resolving Connection Permission Issues
- 17-3. Handling Disk Space Issues
- 17-4. Dealing with the RMAN-06059 Error
- 17-5. Terminating RMAN Processes
- 17-6. Diagnosing NLS Character Set Issues
- 17-7. Logging RMAN Output
- 17-8. Viewing RMAN Command History
- 17-9. Enabling RMAN's Debug Output
- 17-10. Enabling Granular Time Reporting
- 17-11. Working with Oracle Support
- 17-12. Resolving RMAN Compatibility Issues
- 17-13. Dealing with an ORA-19511 Error
- 17-14. Dealing with an ORA-27211 Error
- 17-15. Dealing with an ORA-04031 Error
- 17-16. Managing Files in an ASM Environment
-
CHAPTER 18: Using a Media Management Layer
- Using Oracle Secure Backup
- 18-1. Configuring RMAN Access to the Oracle Secure Backup sbt Library
- 18-2. Managing Authorized OSB Accounts
- 18-3. Creating OSB Media Families for RMAN Backups
- 18-4. Creating an OSB Database Backup Storage Selector
- 18-5. Configuring OSB Parameters in RMAN
- 18-6. Backing Up Using Oracle Secure Backup
- 18-7. Restoring Using Oracle Secure Backup
- 18-8. Accessing RMAN Backup Data in Oracle Secure Backup
- Using Veritas NetBackup
- 18-9. Installing the NetBackup Agent for Oracle
- 18-10. Maintaining Policies for the RMAN Backups
- 18-11. Scheduling NetBackup RMAN Jobs
- 18-12. Defining Client Databases in NetBackup
- 18-13. Checking for NetBackup Files on Tape
- 18-14. Configuring NetBackup Parameters in RMAN
- 18-15. Backing Up Using NetBackup
- 18-16. Restoring Using NetBackup
- Using EMC NetWorker
- 18-17. Configuring EMC NetWorker
- 18-18. Installing EMC NetWorker Module for Oracle
- 18-19. Backing Up Using the EMC NetWorker Module for Oracle
- 18-20. Restoring Using the EMC NetWorker Module for Oracle
- 18-21. Uninstalling the EMC NetWorker Module for Oracle
- 18-22. Verifying the MML Installation
-
CHAPTER 19: Performing Backup and Recovery with Enterprise Manager
- 19-1. Getting Started with RMAN and Enterprise Manager
- 19-2. Setting Up a Credentialed OS User
- 19-3. Creating a Backup
- 19-4. Restoring and Recovering
- 19-5. Viewing Backup Reports
- 19-6. Performing Routine RMAN Maintenance Tasks
- 19-7. Configuring a Recovery Catalog
- 19-8. Configuring Instance Recovery
- 19-9. Configuring the Flash Recovery Area
- 19-10. Configuring Restore Points
- 19-11. Running Custom RMAN Scripts
- 19-12. Configuring Backup Settings
- 19-13. Configuring Backup Policies
- CHAPTER 20: Using the Data Recovery Advisor
-
CHAPTER 21: Using RMAN on Windows
- Oracle on Windows
- Oracle Architecture on Windows
- Services
- Threads, Not Processes
- Oracle Home and SID
- Oracle Groups
- Location of Oracle Binaries
- Managing Oracle Through the Management Console
- Killing the Threads
- Copying Files
- RMAN Recipes for Windows
- 21-1. Connecting As sysdba Using OS Authentication
- 21-2. Simulating a Failure
- 21-3. Creating a Flash Recovery Area
- 21-4. Placing Datafiles, Control Files, and Online and Archived Redo Log Files in the FRA
- 21-5. Switching Back from Image Copies
- 21-6. Using the Flash Recovery Area
- 21-7. Developing a Windows Batch File
- 21-8. Scheduling Windows Jobs
- 21-9. Transporting Tablespaces to/from Windows
- 21-10. Transporting an Entire Database to/from Windows
- Index
Product information
- Title: RMAN Recipes for Oracle Database 11g: A Problem-Solution Approach
- Author(s):
- Release date: August 2007
- Publisher(s): Apress
- ISBN: 9781590598511
You might also like
book
Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach
Performance problems are rarely "problems" per se. They are more often "crises" during which you're pressured …
book
Oracle Database 10g Performance Tuning Tips & Techniques
"Offers hundreds of hints, tips, and tricks of the trade that can be useful to any …
book
Oracle Database 10g RMAN Backup & Recovery
The Most Complete Guide to Maximizing Oracle Recovery Manager Deploy a rock-solid data backup and disaster …
book
Oracle Database 11g New Features
FOREWORD by Tom Kyte Your Must-Have Guide to Everything New in Oracle Database 11 g Realize …