Backup and recovery is the single most important DBA activity and it crucial that you master the RMAN and Data Pump Import utilities to protect against catastrophic data loss. Written by practicing Oracle DBA's with years of RMAN experience, this is a pragmatic approach to RMAN, short on theory and long on real-world practical RMAN tools, tips and techniques. This RMAN book is unique because it provides real-world examples on how to use RMAN to protect your mission critical data. Even with reliable mirrored disks, your Oracle database is still at-risk from important data from software corruption, user error and hardware failures.  This book details Oracle RMAN best practices and shows the best ways to minimize backup time and recovery time, critical for maximizing system availability This is the definitive RMAN reference that guides you, step-by-step, through all of the techniques for Oracle Backup and Recovery, from simple cold backups to complex incremental backups. The experienced RMAN experts guide you through the installation, setup and configuration for a complete RMAN backup and recovery infrastructure, using proven techniques and Oracle best practices. Best of all, you learn from video tutorials and working examples how to recover from every possible data scenario, and this book has step-by-step checklists that you can follow to guide you through a complex recovery with minimal unplanned system outages. This is an indispensible RMAN reference for every professional DBA who needs to ensure that they understand every possible backup and recovery strategy.  It also contains a download of working RMAN scripts to help you easily automate and monitor your RMAN backups, expert scripts available nowhere else.

Includes                Video            Tutorials  * Understand Oracle best practices for using RMAN. * Get expert secrets for minimizing downtime during an RMAN recovery. * See working examples of complex RMAN recovery scenarios. * Learn how to test your RMAN recovery methods. * See how to implement incremental backups. * Understand how to create the RMAN catalog. * See how to to logical backups with Data Pump export. * Learn how to automate your backup jobs. * See how to migrate between platforms using RMAN.

About the Authors:

 

Kamran Agayev Agamehdi	Kamran Agayev Agamehdi  is an Oracle ACE and an Oracle Certified Professional DBA with many years of experience managing complex UNIX-based Oracle Databases. As a working IT professional, Kamran has experience in a wide range of mission critical technologies, specializing in database administration best practices for backup and recovery. Kamran has hands-on experience with real-world Production environments and he has risen in the ranks from a developer to a managing DBA.  Kamran possesses the rare combination of technical and managerial skills and his outstanding communication skills enhance his duties as liaison between  functional business management and the technical DBA and SA professionals Currently Kamran is pursuing a PhD in Computer Science at the Azerbaijan Oil Academy and he serves as an adjunct professor teaching Oracle Database Administration in a Qafqaz University. Kamran also publishes a popular blog at http://kamranagayev.wordpress.com.
Aman Sharma	Aman Sharma is an Oracle database specialist, an Oracle Certified Professional(9i,10g,11g), an Oracle Certified Expert for Linux and SQL and  Sun Certified System Admin with over 6 years of experience. Mr. Sharma works as an instructor training professionals around Asia Pacific in Oracle related technologies. Prior to his work as an instructor, he worked as a DBA for a large software development company.  In his spare time, when he is not teaching or not traveling, he likes to spend his free time in various Oracle forums over the web.  Mr. Sharma also writes about Oracle database over his blog at http://blog.aristadba.com.

Table of Contents:

Kamran Agayev Agamehdi
Aman Sharma
Kamran Agayev Agamehdi & Aman Sharma

Chapter 1 - Backup and Recovery Overview Introduction to Backup and Recovery Errors and Failures Requiring Recovery Oracle Backup and Recovery techniques and solutions Type of Backups and Recoveries made by RMAN RMAN Backup Concepts RMAN Recovery Concepts Chapter 2 - Configuring RMAN, connecting to database with RMAN and taking first backup Using the Recovery Catalog RMAN Retention Policy Setting persistent RMAN configurations Configuring Flashback Recovery Area Connecting to RMAN Switch to ARCHIVELOG mode Your first backup and recovery process using RMAN Checking command syntax using CHECKSYNTAX   Chapter 3 - Backing up Database Using RMAN Backing up Database Files     Backing up Whole Database     Backing up database that running in NOARCHIVELOG mode     Backing up Control Files     Backing up Server Parameter files     Backing up Datafiles     Backing up Archived Redo Log files Backing up Tablespaces Taking Archival Backups Creating Compressed Backups Creating Encrypted Backups Validating Backups Backing up Backup Sets Taking Incremental Backups Block Change Tracking Overview RMAN Reporting on Backups             Using List command             Using REPORT command   Chapter 4 - Restoring and Recovering Database Using RMAN Oracle Restore/Recovery overview Restoring Control File Restoring SPFILE Restoring and Recovering Datafiles Recovering datafile that is not backed up Restoring and Recovering Tablespaces Restoring Archive Redo Log files Performing Block Media Recovery Performing Block Recovery without having RMAN backups Restore and Recovery the NOARCHIVELOG Database Performing Disaster Recovery Performing Incomplete Recovery Performing SCN Based Incomplete Recovery Performing Time-Based Incomplete Recovery Performing Log Sequence Based Incomplete Recovery Recovering to the Restore Point Performing Tablespace Point in Time Recovery (TSPITR) Using Data Recovery Advisor   Chapter 5 - Cloning Database with RMAN Cloning Database with RMAN Overview Creating a Duplicate Database Resynchronize a Clone database Creating a clone database on Windows OS Network-enabled database duplication without backups Using Enterprise Manager to create a Duplicate Database Creating Standby database using RMAN Recovering Standby database using Incremental Backups Resolving archived redo log gaps using incremental backups   Chapter 6  RMAN Cross Platform Transportable databases and tablespaces Transporting tablespace using RMAN backups Transporting tablespace manually using live datafiles Transporting the tablespace across different platform to the different endian format Transporting the database across different platform Copying datafiles from ASM storage and vice verse Oracle Flashback Database Oracle Flashback Data Archive

Chapter 7 - Managing Recovery Catalog Creating recovery catalog Registering a database in the Recovery Catalog Managing the Recovery Catalog Synching a catalog Upgrading a catalog Saving RMAN Scripts in the Recovery Catalog Backing Up and Recovering the Recovery Catalog Creating Virtual Private Catalogs Merging and Moving Recovery Catalog Querying the Recovery Catalog   Chapter 8 – Tuning and Troubleshooting RMAN Tuning RMAN Overview Fast-Start Fault Recovery RMAN Performance Improving Techniques Interpreting RMAN Messages Main RMAN errors and solutions   Chapter 9 - User Managed Backup and Recovery scenarios User Managed Backup Scenarios Overview Backing up Whole Database      Backing up Control Files Backing up Datafiles Backing up Server Parameter files Backing up Archived Redo Log files Verifying Backups  User Managed Recovery Scenarios Overview Restoring and Recovering Control Files Restoring and Recovering Datafiles and Tablespaces Restoring Archived Redo Log files Performing User-Managed recovery from loss of Redo log files Recovering from loss of Multiplexed Redo Log file Recovering from the loss of all members of the İNACTİVE, CURRENT and ACTIVE groups Performing Complete Recovery Performing Time-Based Incomplete Recovery Performing Change-Based Incomplete Recovery Performing Cancel Based Incomplete Recovery Recovering a Database in NOARCHIVELOG Mode   Chapter 10 – Performing Flashback Recovery Oracle Flashback Technology Overview  Oracle Flashback Query Oracle Flashback Versions Query Oracle Flashback Transaction Query Oracle Flashback Transaction Backout Oracle Flashback Table Oracle Flashback Drop Managing Recycle Bin Oracle Flashback Database Oracle Flashback Data Archive   Chapter 11 - Backing up Database using Data Pump Utility Oracle Data Pump Overview Using Data Pump Export utility (expdp) Data and Metadata filtering using Data Pump Exporting objects that are consistent as of the specified SCN or TIME   Compressing the data while exporting Encrypted Export Using Data Pump Import utility (IMPDP) Remapping through Data Pump Using DBMS_DATAPUMP package to move data Interactive Command Line mode of Data Pump

Index:

Reader Comments:

Errata: