Book description
A comprehensive guide for every DBA to learn recovery and backup solutions
- 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
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.
Table of contents
-
Oracle Database 12c Backup and Recovery Survival Guide
- Table of Contents
- Oracle Database 12c Backup and Recovery Survival Guide
- Credits
- About the Author
- Acknowledgement
- About the Author
- Acknowledgement
- About the Reviewers
- www.PacktPub.com
- Preface
-
1. Understanding the Basics of Backup and Recovery
- Purpose of backup and recovery
- Protecting data
- Types of 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
-
2. NOLOGGING Operations
- LOGGING versus NOLOGGING
- Disabling redo generation (NOLOGGING)
- Reducing redo generation
- Backups and NOLOGGING
- Redo-related wait events
- 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
- Some useful scripts
- Summary
- 3. What is New in 12c
- 4. User-managed Backup and Recovery
-
5. Understanding RMAN and Simple Backups
- Why RMAN?
- Getting started with RMAN
- RMAN architecture
- Introducing RMAN backup formats
- 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
- Summary
-
6. Configuring and Recovering with RMAN
- RMAN configuration – an introduction
- Configuring the backup retention policy
- Using backup optimization
- Configuring the device types for the backup
- Configuring auto backup for the control file and SPFILE
- Configuring RMAN channels
- Creating duplexed backups
- Configuring encrypted backups
- Configuring compression for backups
- Configuring the snapshot control file
- Configuring the archived log deletion policy
- Configuring the FRA
- Configuring authentication for RMAN
- 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
- Performing control file recovery
- Performing Block Media Recovery (BMR)
- Performing point-in-time recovery
- Table and table partition-level recovery from RMAN backups
- Data recovery advisor
- Summary
-
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
-
Creating the recovery catalog
- Reporting in RMAN
- Summary
-
8. RMAN Troubleshooting and Tuning
- Getting started with RMAN troubleshooting
- RMAN tuning – an introduction
- Monitoring RMAN sessions and operations
- Stopping RMAN from being uncontrollable
- Using incremental, multi-section, multiplexing, and parallelism
- Troubleshooting RMAN performance using tracing
- Summary
-
9. Understanding Data Pump
- What is Data Pump?
- The Data Pump architecture
- New concepts with Data Pump
- Methods to move the data
- Data Pump files
-
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
-
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
- 11. OEM12c and SQL Developer
-
A. Scenarios and Examples – A Hands-on Lab
- Configuring the database
-
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
- Creating 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
- Magic with Data Pump
- Backup and recovery scenarios
- Index
Product information
- Title: Oracle Database 12c Backup and Recovery Survival Guide
- Author(s):
- Release date: September 2013
- Publisher(s): Packt Publishing
- ISBN: 9781782171201
You might also like
book
Oracle RMAN 11g Backup and Recovery
Master Oracle Recovery Master Protect your databases from hardware, software, and operator failures using the detailed …
book
Oracle Database 12c Release 2 Multitenant
Master the Powerful Multitenant Features of Oracle Database 12c Govern a scalable, extensible, and highly available …
book
Oracle Data Guard 11g Handbook
Master Oracle Data Guard 11 g Provide superior data protection, availability, and disaster recovery using the …
book
Oracle Database 12c Security
Best Practices for Comprehensive Oracle Database Security Written by renowned experts from Oracle's National Security Group, …