Oracle Database 12c Backup and Recovery Survival Guide. A comprehensive guide for every DBA to learn recovery and backup solutions

Oracle Database 12c Backup and Recovery Survival Guide. A comprehensive guide for every DBA to learn recovery and backup solutions - Opis

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, (...) więcej 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. Spis treści:
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
Support files, eBooks, discount offers and more
Why Subscribe?
Free Access for Packt account holders
Instant Updates on New Packt Books
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Downloading the example code
Errata
Piracy
Questions
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
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
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
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
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
Differential incremental backup
Cumulative incremental backup
Power of one
Getting introduced to RMAN commands
Taking your first RMAN backup
File sections for backups of large data files
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
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 RMAN 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
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
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
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
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
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
A. 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
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
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
Index mniej