|
Chapter 1 -
Backup and Recovery Overview
Introduction to Backup and Recovery
Errors and Failures Requiring
Recovery
Oracle
Backup and Recovery techniques and solutions
Type of
Backups and Recoveries made by RMAN
RMAN
Backup Concepts
RMAN
Recovery Concepts
Chapter 2 -
Configuring RMAN, connecting to
database with RMAN and taking first backup
Using the Recovery Catalog
RMAN
Retention Policy
Setting persistent RMAN configurations
Configuring Flashback Recovery Area
Connecting
to RMAN
Switch to ARCHIVELOG mode
Your first
backup and recovery process using RMAN
Checking
command syntax using CHECKSYNTAX
Chapter 3 -
Backing up Database
Using RMAN
Backing up Database
Files
Backing up Whole Database
Backing up database that running in NOARCHIVELOG mode
Backing up Control Files
Backing up Server Parameter files
Backing up Datafiles
Backing up Archived Redo Log files
Backing up
Tablespaces
Taking Archival
Backups
Creating Compressed
Backups
Creating Encrypted
Backups
Validating Backups
Backing up Backup
Sets
Taking Incremental
Backups
Block Change Tracking
Overview
RMAN Reporting on
Backups
Using List
command
Using REPORT command
Chapter 4 - Restoring and Recovering
Database Using RMAN
Oracle
Restore/Recovery overview
Restoring
Control File
Restoring
SPFILE
Restoring
and Recovering Datafiles
Recovering datafile that is not backed up
Restoring
and Recovering Tablespaces
Restoring
Archive Redo Log files
Performing Block Media Recovery
Performing Block Recovery without having RMAN backups
Restore
and Recovery the NOARCHIVELOG Database
Performing Disaster Recovery
Performing Incomplete Recovery
Performing SCN Based Incomplete Recovery
Performing Time-Based Incomplete Recovery
Performing Log Sequence Based Incomplete Recovery
Recovering to the Restore Point
Performing Tablespace Point in Time Recovery (TSPITR)
Using
Data Recovery Advisor
Chapter 5 -
Cloning Database with RMAN
Cloning
Database with RMAN Overview
Creating
a Duplicate Database
Resynchronize a Clone database
Creating
a clone database on Windows OS
Network-enabled database duplication without backups
Using
Enterprise Manager to create a Duplicate Database
Creating
Standby database using RMAN
Recovering Standby database using Incremental Backups
Resolving
archived redo log gaps using incremental backups
Chapter 6
RMAN Cross Platform Transportable
databases and tablespaces
Transporting tablespace using RMAN backups
Transporting tablespace manually using live datafiles
Transporting the tablespace across different platform to
the different endian format
Transporting the database across different platform
Copying
datafiles from ASM storage and vice verse
Oracle Flashback Database
Oracle Flashback Data Archive
|
Chapter 7 - Managing Recovery
Catalog
Creating
recovery catalog
Registering a database in the Recovery Catalog
Managing
the Recovery Catalog
Synching
a catalog
Upgrading
a catalog
Saving
RMAN Scripts in the Recovery Catalog
Backing
Up and Recovering the Recovery Catalog
Creating
Virtual Private Catalogs
Merging and Moving Recovery Catalog
Querying the Recovery Catalog
Chapter 8 – Tuning and
Troubleshooting RMAN
Tuning
RMAN Overview
Fast-Start Fault Recovery
RMAN Performance Improving
Techniques
Interpreting RMAN Messages
Main RMAN errors and solutions
Chapter 9 - User Managed Backup and
Recovery scenarios
User
Managed Backup Scenarios Overview
Backing up Whole Database
Backing up Control
Files Backing up
Datafiles Backing up
Server Parameter files
Backing up Archived Redo Log files
Verifying Backups
User
Managed Recovery Scenarios Overview
Restoring and Recovering Control
Files Restoring and
Recovering Datafiles and Tablespaces
Restoring Archived Redo Log files
Performing User-Managed recovery
from loss of Redo log files
Recovering from loss of Multiplexed Redo Log file
Recovering
from the loss of all members of the İNACTİVE, CURRENT and
ACTIVE groups
Performing
Complete Recovery
Performing Time-Based Incomplete
Recovery Performing
Change-Based Incomplete Recovery
Performing Cancel Based Incomplete
Recovery Recovering a
Database in NOARCHIVELOG Mode
Chapter 10 – Performing Flashback
Recovery
Oracle
Flashback Technology Overview
Oracle
Flashback Query
Oracle Flashback Versions Query
Oracle Flashback Transaction Query
Oracle Flashback Transaction Backout
Oracle Flashback Table
Oracle Flashback Drop
Managing Recycle Bin
Oracle Flashback Database
Oracle Flashback Data Archive
Chapter 11 - Backing up Database
using Data Pump Utility
Oracle
Data Pump Overview
Using Data Pump Export utility (expdp)
Data and
Metadata filtering using Data Pump
Exporting
objects that are consistent as of the specified SCN or
TIME
Compressing the data while exporting
Encrypted
Export
Using Data
Pump Import utility (IMPDP)
Remapping
through Data Pump
Using
DBMS_DATAPUMP package to move data
Interactive Command Line mode of Data Pump
|