Oracle Database 12c Backup and Recovery Survival Guide

Oracle Database 12c Backup and Recovery Survival Guide

Overview of this book

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.

Oracle Database 12c Backup and Recovery Survival Guide

Credits

About the Author

Acknowledgement

About the Author

Acknowledgement

About the Reviewers

www.PacktPub.com

Preface

Free Chapter

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

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

Configuring the database

Configuring RMAN

Playing with RMAN, FRA, and catalog views

Advanced RMAN

Magic with Data Pump

Backup and recovery scenarios

Index

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Finding sessions that generate lots of redo

To find sessions generating lots of redo, you can use either of the following methods. Both methods examine the amount of undo generated. When a transaction generates undo, it will automatically generate redo as well.

Query v$sess_io: This view contains the column block_changes, which indicates how many blocks have been changed by the session. High values indicate a session generating lots of redo.

The query you can use is:

SQL> SELECT s.sid, s.serial#, s.username, s.program,
i.block_changes
 2   FROM v$session s, v$sess_io i
 3   WHERE s.sid = i.sid
 4   ORDER BY 5 desc, 1, 2, 3, 4;

Run the query multiple times and examine the delta between each occurrence of block_changes. Large deltas indicate high redo generation by the session.
Query v$transaction: This view contains information about the amount of undo blocks and undo records accessed by the transaction (as found in the used_ublk and used_urec columns).
The query you can use is:
```
SQL> SELECT...
```

Oracle Database 12c Backup and Recovery Survival Guide

Oracle Database 12c Backup and Recovery Survival Guide

Overview of this book

Related Content you might be interested in

Current Title:

Oracle Database 12c Backup and Recovery Survival Guide

Finding sessions that generate lots of redo