更新时间:2021-04-02 10:20:34
coverpage
Oracle Database 12c Backup and Recovery Survival Guide
Credits
About the Author
Acknowledgement
About the Reviewers
www.PacktPub.com
Support files eBooks discount offers and more
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 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
Summary
Chapter 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
Chapter 3. What is New in 12c
Pluggable database
RMAN new features and enhancements
Data Pump's new features and enhancements
Chapter 4. User-managed Backup and Recovery
Cold backup
Offline backup
Hot backups
Control file backup
Flashback database
Recovering from a user-managed backup
Chapter 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
Chapter 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
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
Reporting in RMAN
Chapter 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
Chapter 9. Understanding Data Pump
What is Data Pump?
The Data Pump architecture