Chapter
1:
Backup and
Recovery Overview
Introduction to Backup and Recovery
DBA Duties
Errors and Failures Requiring Recovery
Oracle Backup and Recovery Techniques
and Solutions
Datafiles
Control Files
Redo Log Files
RMAN Backup Concepts
Backup Set
Backup Piece
Channel Allocation
Autobackups
Summary
Chapter
2:
Configuring
RMAN and Connecting to the Database
Using the Recovery Catalog
Setting Persistent RMAN Configurations
Retention Policy
Backup Optimization
Determining the Device Type
Setting up Automatic Backups of the Control File
Configuring Parallelism
Configuring the Backup Set Size
Setting Up Encryption and Encryption Algorithm for the
Backup
Configuring Archivelog Deletion Policy
Configuring the Snapshot Control File
Configuring and Using the Flashback Recovery Area
Connecting to RMAN
Connecting to RMAN Without Using Recovery Catalog
Connecting to RMAN using a Recovery Catalog
Switching to Archivelog Mode
Setting Up the Archivelog Mode
Taking the First Backup and Performing
the First Recovery
Checking RMAN
Syntax Using
CheckSyntax
Conclusion
Chapter
3:
Backing Up
the Database Using RMAN
Introduction
Backing up the Whole Database
Backing up a Database Running in
Noarchivelog Mode
Backing Up the Control File
Multiplexing Control Files
Backing up the Server Parameter File
Backing Up Datafiles
Taking Multisection Backups
Backing Up Archived Redolog Files
Delete Input
Back Up Tablespaces
Creating Archival Backups
Creating Compressed Backups
Creating Encrypted Backups
Validating Backups
Backing Up Backup Sets
Making Incremental Backups
Block Change Tracking Overview
Enabling Block Change Tracking
Renaming and Disabling Block Change Tracking
Missing Tracking File
RMAN Reporting on Backups
Using the list Command
Skipping a Tablespace from the Output of the list Command
Listing Information about Backup of Archived Redo Log
Files
Listing Image Copies of Database Files
Reporting information about RMAN Backups
Summary
Chapter
4:
Restoring
and Recovering the Database Using RMAN
Introduction
Doing a Recovery Operation?
Instance Crash Recovery
User Created Mistake Recovery
User Process Failure Recovery
Media Crash/Failure Recovery
Disaster Recovery
What is Recovery All About?
What Does Recovery Mean?
When is a Recovery Needed?
How is a Recovery Accomplished?
Media Recovery
Restoring and Recovering Control Files
Recovering from the Loss of a Control File When a Mirrored
Copy is Available
Restoring Control File with Redo Logs Intact
Recovery When Control Files and Data Files are Lost but
the Redo Logs are Intact
Recovery when Control Files, Datafiles, and Redo Logs are
Lost
Recovery from the Loss of Control Files when No Backup
Files are Available but Redo Logs are Intact
Restoring the Spfile
A Dirty Workaround
Restoring and Recovering Datafiles
Restoration and Recovery of a System Datafile
Recovering a Datafile That is Not Backed Up
Restoring Tablespaces
Restoration of the Archivelogs
Using
set newname
to Change the Restored File Location
Performing Block Media Recovery
Performing Block Recovery Without RMAN
Backups
Performing Disaster Recovery
Performing an Incomplete Recovery
Scn-based Incomplete Recovery
Time-based Incomplete Recovery
Change-based Incomplete Recovery
Recovering to Restore Point
Recovering a Database to a Previous Incarnation
Tablespace Point-in-Time Recovery
Using Data Recovery Advisor
Conclusion
Chapter
5:
Cloning
Database with RMAN
Cloning Database with RMAN Overview
Creating a Duplicate Database on Remote
Host with the Same Directory Structure
Creating a Duplicate Database on a
Remote Host
Duplicating Database to the Remote Host with Different
Directory Structure
Creating Duplicate Database with Different Directory
Structure
Creating a Duplicate Database on a Local Host
Resynchronize a Duplicate Database
Configure AUXNAME configuration of RMAN
Duplicate on Windows Host
Duplicate Database Without Any Backup
(g New Feature)
Duplicate database Without Connecting to the Target
Database
Cloning Database Using Enterprise
Manager
Creating Standby Database Using RMAN
Recovering Standby Database Using
Incremental Backups
Resolving Archived Redo Log Gaps Using
Incremental Backups
Conclusion
Chapter
6:
Transportable Tablespaces and Databases
Transportable Tablespace (TTS) Feature
Transporting Tablespace Using RMAN
Backups
Transporting Tablespace Manually
Without RMAN Backups
Transporting the Tablespace across Different Platforms
which have a different endian format
Using the convert tablespace command on the source host to
transport the whole tablespace (with all its datafiles)
from Solaris OS to the Linux OS
Using the convert datafile Command on the Destination Host
to Convert the Datafile from the Linux Platform to the
Windows OS
Cross-Platform Database Migration
Copying Datafiles from ASM Storage
Conclusion
|
Chapter
7:
Managing the
Recovery Catalog
Introduction
Creating the Recovery Catalog
Registering a Database in the Recovery Catalog
Unregistering the Database From the Catalog
Dropping the Recovery Catalog
Synching a Catalog
Saving RMAN Scripts in the Recovery
Catalog
Creation of RMAN Scripts
Create Script from a File
Delete the Stored Script
Cataloging the Copies of the Files
Backing Up and Recovering the Recovery Catalog
Creating Virtual Private Catalogs
Merging and Moving the Recovery Catalog
Querying the Recovery Catalog
Conclusion
Chapter
8:
Troubleshooting, Monitoring and Tuning RMAN
RMAN Troubleshooting Overview
Interpreting RMAN Error Stack
RMAN in Debug Mode
Using the sbttest Utility
Monitoring RMAN
RMAN Tuning Introduction
It is All About I/O
Be In Synch With Asynchronous I/O
Conclusion
Chapter
9:
User-managed
Backup and Recovery Scenarios
Modes of the Backup
Backing Up Database Running in
Noarchivelog Mode
Back Up the Database Running in Archivelog Mode
Diving Deep into the Backup Mode
Restore/recover the Database Running in
Noarchivelog Mode
User-managed Backup of Controlfile
Backing Up Controlfile in Binary Format
Text Backup of Controlfile
Backing Up Archive Files
Backing Up Spfile, Password File and Network Files
Backing Up Offline and Read Only Datafiles
Verifying User-managed Backups
User-managed Recovery Scenarios
Recovering from the Loss of Controlfiles
Recovering from Loss of all
Controlfiles Using Backup Controlfile
Recovering From Loss of a Member of Multiplexed
Controlfile
Recovering Read Only Tablespace From Loss of Controlfiles
Recovery of Datafiles and Tablespaces
Recovering Offline and Read Only Datafiles
Recovering a Datafile Which Has No Backup
Recovering Undo Datafile
Performing User-Managed Recovery from Loss of Redo Log
Files
Performing Incomplete Recovery
Time-based Incomplete Recovery
Conclusion
Chapter
10:
Using the
Media Management Layer
Introduction
The sbttest Utility
Simulating SBT Channel
Introduction to Oracle Secure Backup
A
Closer Look at Oracle Secure Backup (OSB)
Oracle Application Servers
Daemons Related to OSB
Installing OSB on Linux
Configuring OSB
RMAN Configuration with OSB
Database Backup and Recovery Using OSB
Doing File System Backup and Restore Using OSB
Oracle Secure Backup Cloud Module
Conclusion
Chapter
11:
Performing
Flashback Recovery
Introduction
Oracle Flashback Query
Viewing/Retrieving the Dropped PL/SQL Object codes using
Flashback Query
Using Flashback Query on Dropped Table
Oracle Flashback Versions Query
Oracle Flashback Transaction Query
Flashback Transaction Backout
Oracle Flashback Table
Oracle Flashback Drop
Managing the Recycle Bin
Purging Objects From the Recycle Bin
Oracle Flashback Database
Excluding Tablespace from Flashback
Performing Flashback Database When There is Tablespace
Excluded From Flashback
Recover Dropped Schema with Flashback Database
Restoring Dropped Tablespace Using Flashback Database
Monitoring Changes in Flashback Database
Oracle Flashback Data Archive (Total
Recall)
Modify the Flashback Data Archive
Using Default Flashback Data Archive for the System
Query Flashback Data Archive
Using Flashback Versions Query and Flashback Table with
Enterprise Manager
Using Flashback Drop from OEM
Conclusion
Chapter
12:
Backing Up
Database Using Data Pump Utility
Introduction
Data Pump Overview
Data Pump Architecture
Data Pump Dump File
Data Pump Modes
Using Data Pump Export Utility (expdp)
Data and Metadata Filtering Using Data
Pump
Exporting Remote Database Schema
Objects
Exporting Objects Consistent with Specified scn or time
Estimating the Size of the Dump File
Parallelizing Export Process
Compressing the Data While Exporting
Exporting a Tablespace
Export of the Whole Database
Encrypted Export
Using Data Pump to Export/Import Tables
Using Data Pump
Import Utility (impdp)
Remapping Through Data Pump
Using
dbms_data
pump Package to Move Data
Interactive Command Line Mode of Data Pump
Attaching to a Job
Getting the Best Out of the Data Pump
Main Differences Between Data Pump and Original
Export/Import Tools
Conclusion
Book Conclusion
|