Oracle Database 12c Backup and Recovery Survival Guide

Oracle Database 12c Backup and Recovery Survival Guide
eBook: $35.99
Formats: PDF, PacktLib, ePub and Mobi formats
save 15%!
Print + free eBook + free PacktLib access to the book: $95.98    Print cover: $59.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Table of Contents
Sample Chapters
  • A practical reference to all Oracle backup and recovery options available, making it essential to any DBA in the world
  • A valuable guide for readers on the most frequent backup and recovery scenarios they can find in real life
  • Provides hands-on examples and a full hands-on lab to practise everything learned in this book

Book Details

Language : English
Paperback : 440 pages [ 235mm x 191mm ]
Release Date : September 2013
ISBN : 1782171207
ISBN 13 : 9781782171201
Author(s) : Francisco Munoz Alvarez, Aman Sharma
Topics and Technologies : All Books, Enterprise Products and Platforms, Enterprise

Table of Contents

Chapter 1: Understanding the Basics of Backup and Recovery
Chapter 2: NOLOGGING Operations
Chapter 3: What is New in 12c
Chapter 4: User-managed Backup and Recovery
Chapter 5: Understanding RMAN and Simple Backups
Chapter 6: Configuring and Recovering with RMAN
Chapter 7: RMAN Reporting and Catalog Management
Chapter 8: RMAN Troubleshooting and Tuning
Chapter 9: Understanding Data Pump
Chapter 10: Advanced Data Pump
Chapter 11: OEM12c and SQL Developer
Appendix: Scenarios and Examples – A Hands-on Lab
  • Chapter 1: Understanding the Basics of Backup and Recovery
    • Purpose of backup and recovery
      • Testing backups
    • Protecting data
      • Media failure
      • Hardware failure
      • Human error
      • Application error
    • Types of backup
      • A physical backup
      • A logical backup
    • Backup strategies
    • Restore versus recovery
    • What is redo?
    • Redo generation and recoverability
    • The NOARCHIVELOG mode
    • The ARCHIVELOG mode
      • Understanding the ARCHIVELOG mode
      • Preparing for the ARCHIVELOG mode
      • Checking the status of the ARCHIVELOG mode
      • Specifying parameters
      • Viewing the status of archival destinations
      • Placing a database into the ARCHIVELOG mode
      • Differences between redo and undo
      • Facing excessive redo generation during an online backup?
    • Summary
    • Chapter 2: NOLOGGING Operations
      • LOGGING versus NOLOGGING
      • Disabling redo generation (NOLOGGING)
        • NOLOGGING operations
        • Indexed organized tables – an exception
      • Reducing redo generation
        • Tips when LOGGING is in effect (not using NOLOGGING)
          • Backups
          • Bulk inserts
          • Bulk deletes
          • Bulk updates
          • Partitioning
          • Tips for developers
        • Tips when NOLOGGING is in effect
          • Partitioning
          • Direct path inserts
          • Bulk inserts
          • Bulk deletes
          • Bulk updates
      • Backups and NOLOGGING
      • Redo-related wait events
        • The 'log file parallel write' event
        • The 'log file sync' event
        • The 'redo log space request' event
          • The 'log buffer space' event
      • Block corruption due to NOLOGGING
      • Repairing NOLOGGING changes on physical and logical standby databases
      • Finding sessions that generate lots of redo
      • Some other important facts
        • Redo and undo for DML
        • Redo and temporary tables
        • Redo generation and materialized views
        • Flashback and NOLOGGING
        • Performance and recovery considerations
        • Direct path load using SQL*Loader
      • Some useful scripts
        • Redo generated since instance startup
        • Redo generated since session startup
        • Redo generated by current user sessions
        • Current status for redo logs
        • Redo log group and log switch information
        • NOLOGGING objects in the database
      • Summary
      • Chapter 3: What is New in 12c
        • Pluggable database
        • RMAN new features and enhancements
          • Container and pluggable database backup and restore
          • Enterprise Manager Database Express
          • Backup privileges
          • SQL and DESCRIBE
          • Multi-section backups for incremental backups
          • Network-based recovery
          • Active Duplicate
          • Support for the third-party snapshot
          • Cross-platform data transport
          • Table recovery
        • Data Pump's new features and enhancements
          • Disabling LOGGING on Data Pump Import
          • Full transportable Export/Import
          • Exporting views as tables
          • Extended character data types
          • Encryption password
          • Compressing tables on Import
          • Exporting data from the data vault
          • Creating SecureFile LOBs on Import
          • Auditing Data Pump commands
        • Summary
        • Chapter 4: User-managed Backup and Recovery
          • Cold backup
          • Offline backup
          • Hot backups
            • Hot backup of a whole database
            • Hot backup of tablespaces
            • Hot backup of a container database
              • Whole container database
              • Root only or individual pluggable database
              • Check datafile status
          • Control file backup
            • Binary backup
            • Text file backup
          • Flashback database
          • Recovering from a user-managed backup
            • Other recovery scenarios
              • Losing all copies of the current control file
              • Losing one copy of a multiplexed control file
              • Loss of archived redo logs or online redo logs
              • Loss of SPFILE
          • Summary
          • Chapter 5: Understanding RMAN and Simple Backups
            • Why RMAN?
            • Getting started with RMAN
            • RMAN architecture
              • Target database
              • Target Control File
              • RMAN channels
              • Auxiliary database
              • Recovery Catalog
              • RMAN client
              • Oracle Enterprise Manager (EM) Cloud Control 12c
              • Media Management Library (MML)
              • Oracle secure backup
              • Memory requirements for RMAN
              • Configuring ARCHIVELOG mode and FRA
            • Introducing RMAN backup formats
              • Backup sets
              • Image copy
                • Full backup
                • Incremental backups
                • Power of one
                • Getting introduced to RMAN commands
            • Using RMAN for performing incremental backups
            • Fast incremental backups using the block change tracking (BCT) file
            • Multi-section incremental backups
            • Incrementally updated backups
            • Performing backups of the control file, the SPFILE, and archived redo logs
            • Using RMAN compression for backups
            • RMAN for multitenant container databases
              • Performing a full backup of a multitenant CDB
              • Partial backup of a multitenant CDB
              • Performing backup of a pluggable database and root
              • Performing backups of backups
              • Restarting RMAN backups
              • Useful RMAN views related to backups
            • Summary
            • Chapter 6: Configuring and Recovering with RMAN
              • RMAN configuration – an introduction
                • Using the V$RMAN_CONFIGURATION view
                • Using the SHOW ALL command
              • Configuring the backup retention policy
                • Redundancy retention policy
                • Recovery window retention policy
              • Using backup optimization
              • Configuring the device types for the backup
              • Configuring auto backup for the control file and SPFILE
              • Configuring channels
              • Creating duplexed backups
              • Configuring encrypted backups
                • Transparent encryption of backups
                • Creating and using Oracle Software Keystore
                • Password encryption
                • Dual-mode encryption
              • Configuring compression for backups
              • Configuring the snapshot control file
              • Configuring the archived log deletion policy
              • Configuring the FRA
              • Configuring authentication for RMAN
                • Operating system authentication
                • Authenticating the password file
              • Crash and media recovery
              • Key terms related to recovery
                • Overview of stages in the database startup
                • Steps involved in the crash/instance recovery
                • Instance recovery in container and pluggable databases
                • Performing media recovery
                • Recovery in the NOARCHIVELOG mode
                • Loss of a temporary file
                • Loss of non-system data files
                • Loss of system data files
                • Recovering whole CDBs, PDBs, and root container databases
                  • Complete recovery of a container database
                  • Complete recovery of a pluggable database
                  • Complete recovery of the root container
                • Performing control file recovery
                • Performing Block Media Recovery (BMR)
                • Performing point-in-time recovery
                  • Database Point-in-time Recovery (DBPITR)
                  • Tablespace Point-in-time Recovery (TSPITR)
                • Table and table partition-level recovery from RMAN backups
                • Data recovery advisor
              • Summary
              • Chapter 7: RMAN Reporting and Catalog Management
                • Using the control file for RMAN metadata
                • Using the CONTROLFILE_RECORD_KEEP_TIME parameter
                • What is a recovery catalog
                  • Creating the recovery catalog
                    • Sizing and creating a database for the recovery catalog
                    • Creating the default tablespace for the catalog owner
                    • Creating the catalog owner schema
                    • Granting privileges to the catalog owner
                    • Creating the recovery catalog
                    • Using the recovery catalog
                    • Resynchronizing the recovery catalog with the control file
                    • Merging multiple recovery catalogs into one
                  • Using virtual private catalogs
                  • Creating and managing stored scripts
                  • Making a recovery catalog highly available
                  • Upgrading the recovery catalog
                  • Unregistering databases from the recovery catalog
                  • Dropping a recovery catalog
                  • Views related to the recovery catalog
                • Reporting in RMAN
                  • Using the LIST command
                  • Using the REPORT command
                • Summary
                • Chapter 8: RMAN Troubleshooting and Tuning
                  • Getting started with RMAN troubleshooting
                    • Using CHECKSYNTAX
                    • Reading the RMAN error stack
                    • Debugging RMAN using the DEBUG clause
                    • Using the alert log and operating system trace files
                  • RMAN tuning – an introduction
                    • I/O and RMAN – two sides of one coin
                    • Number and size of the input and output buffers
                    • Synchronous and asynchronous I/O modes
                    • Setting the Large Pool memory
                    • Monitoring RMAN I/O performance using dictionary views
                      • V$BACKUP_ASYNC_IO (for asynchronous I/O)
                      • V$BACKUP_SYNC_IO (for synchronous I/O)
                    • Tuning SBT (tape) performance
                  • Monitoring RMAN sessions and operations
                  • Stopping RMAN from being uncontrollable
                  • Using incremental, multi-section, multiplexing, and parallelism
                  • Troubleshooting RMAN performance using tracing
                  • Summary
                  • Chapter 9: Understanding Data Pump
                    • What is Data Pump?
                    • The Data Pump architecture
                    • New concepts with Data Pump
                    • Methods to move the data
                      • Datafile copy
                      • Direct path
                      • External tables
                      • Conventional path
                      • Network link
                    • Data Pump files
                      • Roles for Data Pump export and import
                      • Directory objects
                        • Creating directory objects
                    • Data Pump scenarios
                      • Schema export and import
                      • Exporting and importing tables
                      • Exporting and importing a whole database/pluggable database
                      • Using Export to estimate space
                      • Parallel full database export and interactive-command mode
                      • Importing tables with only metadata
                      • Exporting views as tables
                      • Importing data via a network link
                    • Summary
                    • Chapter 10: Advanced Data Pump
                      • Data masking
                      • Metadata repository and version control
                      • Using SOURCE_EDITION and TARGET_EDITIONS
                      • Cloning a user
                      • Creating smaller copies of production
                      • Creating your database in a different file structure
                      • Moving all objects from one tablespace to another
                      • Moving an object to a different schema
                      • Migrating data for upgrade
                      • Downgrading an Oracle Database
                      • Transporting a tablespace
                      • Data Pump flashback
                      • Monitoring Data Pump job status
                      • Some performance tuning tips
                      • Summary
                      • Chapter 11: OEM12c and SQL Developer
                        • Configuring backup, recovery, and catalog settings
                          • Backup settings
                          • Recovery settings
                          • Catalog settings
                        • Scheduling an RMAN backup
                          • Using the Oracle-Suggested Backup strategy option
                          • Using the Customized Backup option
                        • Restore points
                        • Export/Import with OEM12c
                          • Executing an export operation
                        • Monitoring the job
                        • SQL developer 3.2
                          • RMAN operations
                          • Data Pump operations
                        • Summary
                        • Appendix: Scenarios and Examples – A Hands-on Lab
                          • Configuring the database
                            • Making sure an spfile is used to start the database
                            • Placing the database in the archivelog mode and activating Flashback
                            • Creating a new redo log group and associated files
                          • Configuring RMAN
                            • Creating the target DB RMAN backup account
                            • Configure RMAN using the configure command
                            • Backup database
                            • Checking and deleting obsolete backups
                            • Creating RMAN catalog user
                            • Creating recovery catalog
                            • Register your DB in the recovery catalog
                            • Create a virtual private catalog
                            • Enabling Block Change tracking
                          • Playing with RMAN, FRA, and catalog views
                            • Monitoring a backup
                            • Incremental backups
                            • Multisection backups
                            • FRA – checking number of redo switches
                            • Check for alerts
                            • Check FRA usage
                            • See the archived log generated by the DB target
                            • See the control file backups
                            • See the corrupted list that exists in datafile backups
                            • See block corruption in the DB, populated when backup or backup validate
                            • See all RMAN configurations (equivalent to show all)
                            • Monitor backup outputs (RMAN)
                            • Offline backups with RMAN
                            • Offline backup without using configured defaults
                            • Using backup limits (duration)
                            • Modifying the retention policy for a backup set (archival backups)
                            • Archive deletion policy
                            • Using RMAN to scan DB for physical and logical errors
                            • Configuring tablespaces for exclusion from whole database backups
                            • Skipping offline, inaccessible, or read-only datafiles
                            • Forcing backups of read-only datafiles
                            • Backup of newly added datafiles
                            • Backup files not backed up during a specific period
                            • General backup examples
                            • Backup copies
                          • Advanced RMAN
                            • Information about fully-completed backups
                            • Summary of the active session history
                            • How long does it take?
                            • V$BACKUP_ASYNC_IO
                            • Tablespace Point-in-Time Recovery (TSPITR)
                            • Reporting from a catalog
                            • Duplex backup
                            • Check if the database is recoverable
                            • Recover advisor
                          • Magic with Data Pump
                            • Preparing Data Pump
                            • Data masking
                            • Metadata repository
                            • Cloning a user
                            • Creating smaller copies of production
                            • Creating your database in a different structure
                            • Time-based flashback
                          • Backup and recovery scenarios
                            • Active duplication of a database to a different server with the same structure (non-OMF and non-ASM)
                            • Duplicating a PDB
                            • ASM backup and restore
                            • Recovering from the loss of the SYSTEM tablespace
                            • Recovering a lost datafile using an image from an FRA

                          Francisco Munoz Alvarez

                          Francisco Munoz Alvarez has over two decades of experience in consulting, analysis, support, implementation, and migration of Oracle products. He is also an expert in most phases of a database life cycle, for example, development, stabilization, security, backup and recovery, tuning, installations, and data warehouse (ETL) with excellent implementation and support methodologies. He is a popular speaker at many Oracle conferences around the world. He is also the President of CLOUG (Chilean Oracle Users Group), LAOUC (Latin American Oracle Users Group Community, which is the umbrella organization for all of Latin America), and NZOUG (New Zealand Oracle Users Group). He worked as an Associate Technologist for Oracle in Brazil and Chile. He was an Oracle instructor for the New Horizons Centre (Chile) and for Oracle Education (Brazil and Chile). He also worked in the first team to introduce Oracle to South America (Oracle 6 and the beta version of Oracle 7). He was also the first Master Oracle 7 Database Administrator in South America, as well as the first Latin American Oracle professional to be awarded a double ACE (ACE in 2008 and ACE Director in 2009) by Oracle HQ. In 2010, he had the privilege to receive a prestigious Oracle Magazine Editor's Choice Award as the Oracle Evangelist of the Year—a huge recognition for his outstanding achievements in the Oracle world that includes the creation and organization of the already famous OTN Tours that are the biggest Oracle evangelist events in the world. Currently, Francisco works for Revera Limited, which is a leading provider of utility computing infrastructure and enterprise data management in New Zealand, as the Oracle Professional Services Manager since June 2011. He also maintains an Oracle blog ( and you can always contact him through this or Twitter (@fcomunoz) regarding any questions about this book.

                          Aman Sharma

                          Aman Sharma is an Oracle Database consultant and instructor. He holds a Master's degree in Computer Applications and has been working with Oracle Database for over a decade. His main focus is to understand how Oracle Database works internally. Besides the core database, he has a very strong knowledge of Linux, Solaris, Oracle RAC, Data Guard, RMAN, Oracle Exadata and Oracle Enterprise Manager. He is an Oracle Certified Professional and also an Oracle Certified Expert in Oracle RAC, SQL and Linux. He is also an Oracle Certified Implementation Specialist and a certified Solaris System Administrator. He loves to share his learning with the Oracle community, so when he is not delivering an Oracle= related session, he spends a lot of his time participating in OTN (Oracle Technology Network) discussion forums. He also maintains an Oracle blog (, is also on Twitter (@amansharma81), you can reach to him using either ways. He is a strong supporter of user groups and is a member of India Oracle Users Group ( and has been a speaker at various Oracle conferences organized by AIOUG. He is also an associate member of IOUG ( In 2010, he was awarded the prestigious Oracle ACE award from Oracle Corporation.
                          Sorry, we don't have any reviews for this title yet.

                          Code Downloads

                          Download the code and support files for this book.

                          Submit Errata

                          Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

                          Sample chapters

                          You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                          Frequently bought together

                          Oracle Database 12c Backup and Recovery Survival Guide +    Implementing SugarCRM =
                          50% Off
                          the second eBook
                          Price for both: £23.00

                          Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                          What you will learn from this book

                          • Understand all the options available for the backup and recovery of a database to be used in case of a disaster and how to survive it
                          • Learn how to use RMAN and take advantage of its advanced functionalities
                          • Use Data Pump for more than just backups, learning how powerful this utility is
                          • Take advantage of Nologging operations in a safe and proper way
                          • Perform backups and recovery properly in Multitenant and non-CDB environments
                          • Take advantage of OEM12c and SQL Developer to fulfil your backup requirements and reduce risk in your organization
                          • Understand the new features in 12c offered for backup and recovery and how to perform backup and recovery operations on it
                          • Get familiar with the available range of Oracle products for backup and recovery, not only RMAN

                          In Detail

                          The three main responsibilities of a successful DBA are to ensure the availability, recoverability, and performance of any database. To ensure the recoverability of any database, a DBA needs to have a strong backup and recovery skills set. Every DBA is always looking for a reference book that will help them to solve any possible backup and recovery situation that they can come across in their professional life.

                          Oracle Database 12c Backup and Recovery Survival Guide has the unique advantage to be a reference to all Oracle backup and recovery options available, making it essential for any DBA in the world. If you are new to Oracle Database, this book will introduce you to the fantastic world of backup and recovery that is vital to your success. If you are an experienced DBA, this book will become a reference guide and will also help you to learn some possible new skills, or give you some new ideas you were never aware about. It will also help you to easily find the solution to some of the most well known problems you could find during your career as a DBA. This book contains useful screenshots, scripts, and examples that you will find more than useful.

                          Most of the books currently available in the market concentrate only on the RMAN utility to backup and recovery. This book will be an exception to the rule and will become a must-have reference, allowing you to design a real and complete backup and recovery strategy. It covers the most important topics on Oracle database such as backup strategies, Nologging operations, new features in 12c, user managed backups and recoveries, RMAN (including reporting, catalog management, troubleshooting, and performance tuning), advanced data pump, Oracle Enterprise Manager 12c and SQL Developer.

                          "Oracle Database 12c Backup and Recovery Survival Guide" contains everything a DBA needs to know to keep data safe and recoverable, using real-life scenarios.


                          The book follows a tutorial-based approach, covering all the best practices for backup and recovery. The book starts by introducing readers to the world of backup and recovery, then moves on to teach them the new features offered by Oracle 12c. The book is full of useful tips and best practices that are essential for any DBA to perform backup and recovery operations in an organization.

                          Who this book is for

                          This book is designed for Oracle DBAs and system administrators. The reader will have a basic working experience of administering Oracle databases. This book is designed for Oracle DBAs and system administrators.This book will become a reference guide and will also help you to learn some new skills, and give you some new ideas you never knew about, helping you to easily find the solution to some of the most well-known problems you could encounter as DBAs.

                          Code Download and Errata
                          Packt Anytime, Anywhere
                          Register Books
                          Print Upgrades
                          eBook Downloads
                          Video Support
                          Contact Us
                          Awards Voting Nominations Previous Winners
                          Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                          Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software