PacktLib: Oracle Database 12c Backup and Recovery Survival Guide

Oracle Database 12c Backup and Recovery Survival Guide

Credits

About the Author

Acknowledgement

About the Author

Acknowledgement

About the Reviewers

www.PacktPub.com

Preface

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

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

What is New in 12c

Pluggable database

RMAN new features and enhancements

Data Pump's new features and enhancements

Summary

User-managed Backup and Recovery

Cold backup

Offline backup

Hot backups

Control file backup

Flashback database

Recovering from a user-managed backup

Summary

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

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

Summary

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

Summary

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

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

Summary

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

OEM12c and SQL Developer

Configuring backup, recovery, and catalog settings

Scheduling an RMAN backup

Restore points

Export/Import with OEM12c

Monitoring the job

SQL developer 3.2

Summary

Scenarios and Examples – A Hands-on Lab

Scenarios and Examples – A Hands-on Lab

Scenarios and Examples – A Hands-on Lab

Scenarios and Examples – A Hands-on Lab

Scenarios and Examples – A Hands-on Lab

Scenarios and Examples – A Hands-on Lab

Scenarios and Examples – A Hands-on Lab

Index