Contents -- Introduction -- Chapter 1: Performing Oracle User-Managed Backups -- Oracle Database Data Protection Options -- What Kind of Failures Can Happen to a Database -- Physical and Logical Backups -- Tools for Backup and Recovery -- Oracle MAA Recommendations -- Understanding the Oracle Database as It Relates to Backup and Recovery -- Oracle Processes Related to Backup and Recovery -- Oracle Memory Structures Related to Backup and Recovery -- The Oracle Data Dictionary -- Oracle Data Files and Tablespaces -- Redo Logs -- Control File -- Parameter Files -- NOARCHIVELOG and ARCHIVELOG Modes -- The Oracle Instance and the Oracle Database -- Configuring the Database for Backup and Recovery -- Configuring for ARCHIVELOG Mode -- Putting the Database in ARCHIVELOG Mode -- Using ARCHIVELOG Mode Data Dictionary Views -- Performing Oracle Offline Backups -- Performing Oracle Online Backups -- The Mechanics of Online Backups -- Backing Up the Control File -- Creating a Backup Control File -- Creating a Trace File with the Create CONTROLFILE Command in It -- Summary -- Exam Essentials -- Review Questions -- Chapter 2: Performing Oracle User-Managed Database Recoveries -- Performing a Recovery in NOARCHIVELOG Mode -- Performing a Full Database Recovery in ARCHIVELOG Mode -- Preparing for the Recovery -- Recovering the Database -- Performing User-Based Incomplete Recoveries -- Requirements for and Mechanics of an Incomplete Recovery -- Preparing for an Incomplete Recovery -- Performing an Incomplete Recovery -- Performing Other Types of Recoveries -- Recovering from the Loss of a Tempfile -- Recovering from the Loss of an Online Redo Log Group -- Recovering from the Loss of a Control File -- Recovering from the Loss of the Password File -- Recovering from the Loss of Everything -- Summary -- Exam Essentials -- Review Questions.

Chapter 3: Configuring and Backing Up Oracle Databases Using RMAN -- Why Use RMAN? -- Exploring the RMAN Architecture -- Getting Started with RMAN -- Starting the RMAN Interface -- The SYSBACKUP Privilege -- The RMAN Command Line -- The RMAN Command Prompt -- Calling SQL from the RMAN Command Prompt -- Configuring RMAN -- The Fast Recovery Area -- RMAN Persistent Configuration Settings -- Unique RMAN Configuration Settings -- Preparing RMAN for Use -- Backing Up Your Database with RMAN -- Using the RMAN Command Line -- Types of RMAN Backups -- RMAN Offline Backups -- RMAN Online Backups -- RMAN Incremental Backups -- RMAN Incrementally Updated Backups -- RMAN Multisection Backups -- RMAN Backup of Archived Redo Logs -- RMAN Backup of the Spfile and Control Files -- Backing Up RMAN Backup Sets -- Backing Up the RMAN FRA -- Creating Archival Backups -- Summary -- Exam Essentials -- Review Questions -- Chapter 4: Using the RMAN Recovery Catalog -- Introducing the Recovery Catalog -- Creating the Recovery Catalog User and Schema Objects -- Using a Recovery Catalog -- Connecting to the Recovery Catalog from RMAN -- Registering the Target Database with the Recovery Catalog -- Unregistering a Database -- Using Scripts in the RMAN Recovery Catalog -- Executing External Scripts -- Creating Stored Scripts -- Using Script Substitution Variables -- Maintaining the Recovery Catalog -- Dropping the Recovery Catalog -- Upgrading the Recovery Catalog -- Synchronizing the Recovery Catalog -- Export and Import the Recovery Catalog -- Backing Up the Recovery Catalog -- Recreating an Unrecoverable Recovery Catalog -- Using the RMAN Virtual Private Catalog -- Creating the RMAN Virtual Private Catalog -- Administering the RMAN Virtual Private Catalog -- Summary -- Exam Essentials -- Review Questions -- Chapter 5: Recovering Databases with RMAN.

RMAN Database-Recovery Basics -- Recovering a Database in NOARCHIVELOG Mode -- Recovering a Database in ARCHIVELOG Mode -- Complete Database Recovery in ARCHIVELOG Mode -- Data File or Tablespace Recovery in ARCHIVELOG Mode -- Recovering a Database Using Incomplete Recovery -- Types of Point-in-Time Recovery -- Point-in-Time Recovery Mechanics -- Using Image Copies to Recover Your Database -- Other Basic Recovery Topics -- Block Media Recovery -- Recovering the Control File -- Recovering the Spfile -- Recovering the Database Password File -- Clearing Redo Logs -- Summary -- Exam Essentials -- Review Questions -- Chapter 6: Tuning and Monitoring RMAN and the Automatic Diagnostic Workflow -- Overview of the RMAN Report and List Commands -- Using the RMAN REPORT Command -- Using the RMAN LIST Command -- Monitoring, Administering, and Tuning RMAN -- Monitoring RMAN Operations -- Administering RMAN Operations -- Tuning RMAN Operations -- The Oracle Database Fault Diagnostic Framework -- Overview of the Oracle Database Fault Diagnostic Framework -- The Oracle ADR -- Problems and Incidents -- The Automatic Diagnostic Workflow-Managing Problems and Incidents -- Components Related to the Fault Diagnosability Framework -- Enterprise Manager Support Workbench -- The ADRCI Command-Line Utility -- Summary -- Exam Essentials -- Review Questions -- Chapter 7: Performing Oracle Advanced Recovery -- Switching between RMAN Incarnations -- Overview of RMAN Database Duplication -- RMAN Database Duplication Basics -- Performing an RMAN Database Duplication -- Performing an RMAN Tablespace Point-in-Time Recovery -- TSPITR Overview -- Checking the Transport Set -- Lost Objects -- Rules, Rules, and More Rules -- TSPITR Aftereffects -- Restoring a Database to a New Host -- Using RMAN to Move a Database -- Oracle Data Pump, Oracle GoldenGate and Oracle Data Guard.

Complete Disaster -- Backup Best Practices for Data Warehouses -- The First Execution of the Command -- The Second Execution of the Command -- The Third Execution of the Command -- Restoring from Incrementally Updated Backups -- Performing Table and Partition Recovery from Backups -- Things to Check Before Trying to Restore and Recover Database Tables and Partitions -- Restrictions When Restoring and Recovering Database Tables and Partitions -- Options to Consider When Performing Table or Table Partition Restores -- An Example of Using RMAN to Restore and Recover a Database Table -- ASM-Related Backups -- Quick ASM Overview -- ASM Diskgroup Metadata Backups -- Restoring ASM Disk Groups -- Configuring and Using Oracle Secure Backup -- What Is OSB? -- How Does OSB Interface with RMAN? -- The OSB Architecture -- Installing and Configuring OSB -- Oracle Database 12c Multitenant Architecture and RMAN -- Architecture Overview -- Backing Up CDBs with RMAN -- Backing Up PDBs with RMAN -- Recovering CDBs and PDBs with RMAN -- Duplicating a PDB with RMAN -- Oracle Data Pump and Oracle Multitenant -- The Data Recovery Advisor -- Summary -- Exam Essentials -- Review Questions -- Chapter 8: Understanding Flashback Technology -- Describe the Flashback Technologies -- Managing Undo Automatically -- Uncovering Undo -- Working with Automatic Undo Management -- Preserving Data with Undo Retention -- Employing Flashback Technologies -- Recovering Tables and Objects with Flashback Drop and the Recycle Bin -- Use Flashback to Query Data -- Recovering Data with Flashback Version Query -- Detecting Changes with Flashback Transaction Query -- Perform Flashback Table Operations -- Describe and Use Flashback Data Archive -- Perform Flashback Database Operations -- Summary -- Exam Essentials -- Review Questions.

Chapter 9: Diagnosing the Database and Managing Performance -- Diagnosing Failures -- Setting Up the Automatic Diagnostic Repository -- Using the Support Workbench -- Performing Block Media Recovery -- Managing Database Performance -- Using the SQL Tuning Advisor -- Using the SQL Access Advisor to Tune a Workload -- Perform Database Replay -- Summary -- Exam Essentials -- Review Questions -- Chapter 10: Managing Database Resources -- Managing Storage -- Managing Resumable Space Allocation -- Managing Transportable Tablespaces -- Managing Transportable Databases -- Shrinking Segments -- Managing Storage in a CDB and PDBs -- Manage Permanent and Temporary Tablespaces in CDB and PDBs -- Summary -- Exam Essentials -- Review Questions -- Creating Oracle Multitenant Databases -- Multitenant Container and Pluggable Database Architecture -- Describing the Multitenant Architecture -- Explaining Pluggable Database Provisioning -- Creating Multitenant Container Databases and Pluggable Databases -- Creating and Configuring a CDB -- Creating a PDB Using Different Methods -- Unplugging and Dropping a PDB -- Migrating a Pre-12.1 Non-CDB Database to a CDB -- Summary -- Exam Essentials -- Review Questions -- Chapter 12: Managing Oracle Multitenant Databases -- Establishing Connections to CDB/PDB -- User Accounts in a CDB -- Establishing Connections to a CDB -- Establishing Connections to a PDB -- Start Up and Shut Down a CDB and Open and Close PDBs -- Starting Up the CDB Using SQL*Plus -- Shutting Down the CDB -- Opening a PDB -- Shutting Down or Closing a PDB -- Evaluate the Impact of Parameter Value Changes -- AUDIT_FILE_DEST -- AUDIT_SYS_OPERATIONS -- AUDIT_SYSLOG_LEVEL -- AUDIT_TRAIL -- ENABLE_PLUGGABLE_DATABASE -- LDAP_DIRECTORY_ACCESS -- MAX_STRING_SIZE -- NONCDB_COMPATIBLE -- PDB_FILE_NAME_CONVERT -- RESOURCE_MANAGER_PLAN -- SESSIONS -- Summary.

Exam Essentials.