- Introductions
- The 10 keys of a bulletproof backup strategy
- Designing effective backup and recovery strategies
- Archivelog vs. noarchivelog
- Disaster recovery
- Types of failures
- User
- Process
- Instance
- Statement
- Media
- Configure database archiving
- Prepare parameter file
- Put database into archivelog mode
- Test archiving
- Backup the Oracle Database
- Physical Oracle backups
- Steps to perform cold backup
- Steps to perform hot backup
- Logical Oracle backup
- Complete Oracle Database recovery
- Complete recovery concepts
- Types of complete recovery
- Database
- Datafile
- Tablespace
- Steps to perform complete database recoveries
- Incomplete Oracle Database recovery
- Incomplete recovery concepts
- Types of incomplete recovery
- Cancel-based
- Time-based
- Change-based
- Steps to perform incomplete database recoveries
- Introduction to RMAN
- Discuss RMAN architecture
- Comparison of RMAN backup methods
- Create a recovery catalog
- Maintenance of the recovery catalog
- Resync recovery catalog
- RMAN commands: backup and copy
- Create RMAN scripts
- Store and execute RMAN scripts
- Tools for troubleshooting problems
- Error log and Trace files
- Detection of corrupt blocks
- Repair corrupt blocks
- DBVERIFY utility
- DBMS_Repair
- LogMiner utility
- V$Views
- Flashback query
- Standby databases
- Benefits of a standby database
- Create standby database
- Case studies
- Missing/lost datafile
- Failure during hot backup
- Loss of a controlfile
- Loss of a rollback segment
- Loss of an online redo log
- Recovering from user errors
- New Oracle 10g backup and recovery features
- Flash recovery area
- Oracle flashback database
- Incrementally updated backups: rolling forward image
copies
- Disk topology and automatic performance tuning
- Automatic datafile creation
- Recovery through resetlogs
- Restore failover
- BACKUP command creates backup sets or image copies
- Fast incremental backups
- Channel failover
- Improved RMAN reporting through V$ views
- Cross-platform tablespace conversion
- Enhanced reporting: RESTORE PREVIEW
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
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
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
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
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
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
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
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
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
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
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
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
|
and include the URL for the page.
