By using Oracle’s RMAN and Data Pump Import utilities for example, a DBA can protect their database from crippling data loss.   This book provides real-world examples of how to use these tools to protect important data from corruption, user error, hardware failures, and is supplemented with relevant examples and scenarios. This book will guide you through the techniques of Oracle Backup and Recovery. You’ll learn how you should make your backup strategy to not lose any data or whole your database. At the same time, you’ll find the errors which you may face during your DBA career and solutions of these errors using Oracle Recovery techniques. You’ll find each chapter, each section with full of scenarios, step by step explanations and examples.

* See working examples of complex recovery scenarios * Learn how to test your recovery methods * Understand how to create an RMAN catalog * See how to to logical backups with Data Pump export

About the Authors:

 

Kamran Agayev Agamehdi	Kamran Agayev Agamehdi  is an Oracle Certified Professional DBA (9i, 10g) with over 5 years experience with UNIX Systems and with Oracle Databases. During his 5 years working in the IT industry, Kamran has been exposed to a wide range of technologies and developed a broad set of technical skills. He have developed a very strong background in Oracle Databases, UNIX and Windows systems. Kamran has worked in Production environments as an Oracle DBA and in Development environments as Oracle DBA/Developer, and adapt well to both. His background, communication and documentation skills help in bridging the gap between Business people, database administrators and UNIX system administrators. Now, he’s pursuing a PhD in Azerbaijan Oil Academy in Computer Science and teaching “Oracle Database Administration” in a Qafqaz University. At the same time, he’s an active member of OTN and has published a lot of “Step by Step” articles on his blog http://kamranagayev.wordpress.com covering main Oracle futures
Aman Sharma	Aman Sharma is an Oracle Certified Database Administrator with over 4 years of experience in various fields of Oracle Database, to include administration of mission critical databases, fine-tuning as per the requirement and needs of the end user and application. Mr. Sharma has worked as an external consultant training Database technologies.

Table of Contents:

Kamran Agayev Agamehdi
Aman Sharma
Kamran Agayev Agamehdi & Aman Sharma

Section I – Introduction to RMAN 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 channel allocation        RMAN Repository        About RMAN Backups and Options        Backup Retention Policies RMAN Recovery Concepts Chapter 2 - Configuring RMAN, connecting to database with RMAN and taking first backup Using the Recovery Catalog Main RMAN Configurations Configuring Flashback Recovery Area Connecting to database using RMAN Switch to ARCHIVELOG mode Your first backup and recovery process using RMAN Checking command syntax using CHECKSYNTAX Section II – Advanced RMAN Backup and Recovery techniques Chapter 3 - Backing up Database Using RMAN Configuring device, type and location of back up file Backing up Database Files     Backing up Whole Database     Backing up Control Files     Backing up Datafiles     Backing up Server Parameter files     Backing up Archived Redo Log files Backing up Tablespaces Backing up Backup Sets Incremental Backups Creating Encrypted Backups Creating Compressed Backups Validating Backups RMAN Reporting on Backups Using Enterprise Manager to Perform Backup of the Database Chapter 4 - Restoring and Recovering Database Using RMAN Restoring Control File Restoring SPFILE Restoring and Recovering Datafiles Restoring and Recovering Tablespaces Restoring Archive Redo Log files Restore and Recovery the Database to the new host Performing Block Media Recovery Restore and Recovery the NOARCHIVELOG Database Performing Incomplete Recovery Time-Based Recovery SCN Based Recovery Log Sequence – Based Recovery Performing Disaster Recovery Using Enterprise Manager to Perform Recovery of the Database Chapter 5 - Cloning Database with RMAN Cloning Database with RMAN Overview Creating a Duplicate Database Using Enterprise Manager to create a Duplicate Database Chapter 6 - RMAN Cross Platform Transportable databases and tablespaces Transporting Tablespace with RMAN Transporting Database with RMAN

Chapter 7 - RMAN Data Guard Futures Creating Data Guard using RMAN RMAN and Data Guard configuration settings Backup procedures for Standby Database Recovery scenarios for Standby Database Chapter 8 - RMAN 11g Futures Data Recovery Advisor Network-enabled database duplication without backups Multisection Backups Faster Backup Compression Improved Scripting with RMAN Section III – RMAN Backup Maintenance Chapter 9 - Managing Recovery Catalog Create a Recovery Catalog Registering Target Database in the Recovery Catalog Resynchronizing the Recovery Catalog Creating RMAN Sciprts in the Recovery Catalog Backing Up and Recovering the Recovery Catalog Chapter 10 - Tuning RMAN Tuning RMAN Overview Fast-Start Fault Recovery RMAN Performance Improving Techniques   Chapter 11 - Troubleshooting RMAN Interpreting RMAN Messages Main RMAN errors and solutions Section IV – Advanced User Managed Backup and Recovery techniques Chapter 12 - User Managed Backup and Recovery scenarios User Managed Backup Scenarios 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 Restoring Control Files Restoring Datafiles Restoring Archived Redo Log files Performing Complete Recovery Performing Cancel Based Incomplete Recovery Performing Time-Based Incomplete Recovery Performing Change-Based Incomplete Recovery Recovering a Database in NOARCHIVELOG Mode Chapter 13 - Performing Flashback Recovery Enabling Flashback future of the Database Flashback Database using RMAN and SQL Oracle Flashback Query Oracle Flashback Table Oracle Flashback Drop - Recovering a Dropped Table Oracle Flashback Database Recycle Bin futures Using Enterprise Manager to Perform Flashback Operations Chapter 14 - Backing up Database using Data Pump Utility Oracle Data Pump Overview Using Data Pump Export Using Data Pump Import Tuning Data Pump Data Pump API introduction

Index:

Reader Comments:

Errata: