|
(703)246-9100 Northern Virginia (804)285-5830 Central Virginia (757)420-3810 Tidewater Area (800)294-7497 Toll Free (804)285-3722 Fax |
ORACLE9i BACKUP and RECOVERY for DBA's
Duration: 4 days
Instance Recovery
NOARCHIVELOG Physical Backups
ARCHIVELOG Physical Backups
Complete Recovery
Incomplete recovery
Logical Backup and Recovery
Oracle Utilities
Data Loading
Backup Using RMAN
Recovery Using RMAN
Backup and Recovery Workshop
Course Content:
Why back up?
Types of Failures
Oracle Recovery Features
Developing a backup strategy
The backup plan – defining the MTTR specification
Instance Recovery, Resumable and Online Operations
Instance Failure Recovery
Establishing a Recovery Time Target
Fast Start Time-based Recovery
Online and Resumable Operations
Flashback Query
Oracle Database Backups
Writing to the database
DBWR and LGWR
Automatic Recovery Architecture
NOARCHIVELOG and ARCHIVELOG Mode
Physical Backups
Closed Backups in NOARCHIVELOG Mode
Configuring Archivelog Mode
Physical ARCHIVELOG Mode Backups
Configuration of the database for archiving
Setting the ARCHIVELOG mode
Establishing multiple archiving destinations
Tuning the archive process
Closed backups in ARCHIVELOG mode
Open backups in ARCHIVELOG mode
Controlfile Backup
Types of Failures and Recovery
Recovery Structures and Processes
Recovery in NOARCHIVELOG Mode and in ARCHIVELOG Mode
Datafile Verification
What is incomplete recovery?
Reasons for needing incomplete recovery
Types of Incomplete Recovery
Recovering From Loss Of Current Redo Log Files
TSPITR & Standby Databases
Standby Database –Data Guard
Switchover and Failover
Real Application Clusters / Cache Fusion
Replication
Logical Backup and Recovery
Logical backups using EXPORT and IMPORT
Exports, Direct Path Export, Imports
Using Export/Import in Oracle Enterprise Manager
Methods for Detecting Block Corruption
DBVerify
DBMS_REPAIR, DBMS_LOGMNR
The LogMiner Utility – new enhancements including DDL mining
Direct load inserts
SQL*Loader
What is Recovery Manager?
RMAN Tools
RMAN Features
Recovery Catalog
Backup, Restore and Recover Package
Media Management Layer interface
RMAN Maintenance Commands
Supported Backup Types
Recovery Catalog Commands
Steps to set up a Recovery Database
Catalog Maintenance Activities and Commands
The CONFIGURE command
The CROSSCHECK command
Creating and running backup scripts
Reports and the Recovery Catalog
Lists and the Recovery Catalog
Backups using RMAN
Cataloging non-RMAN Backups
Restore Operations using RMAN
Block Media Recovery Operations (BMR)
Trial Recovery
The RESTORE command
Performing a recovery
Unique Training Solutions for Unique Clients