|
(703)246-9100 Northern Virginia (804)285-5830 Central Virginia (757)420-3810 Tidewater Area (800)294-7497 Toll Free (804)285-3722 Fax |
ORACLE 8i Backup and Recovery
Duration: 3 days
|
(703)246-9100 Northern Virginia (804)285-5830 Central Virginia (757)420-3810 Tidewater Area (800)294-7497 Toll Free (804)285-3722 Fax |
ORACLE 8i Backup and Recovery
Duration: 3 days
Develop the advanced skills of backup and recovery to effectively administer an Oracle Server Database
Course Description:
This course provides students with the knowledge and hands-on experience to plan and execute Oracle database backup and recovery.
Participants will learn…
DBMS Backup and Restore
ARCHIVELOG
Export and Import
Recovery Manager
Who Needs to Attend:
Application Developers and Designers, Managers, Database Administrators, Systems Administrators, Network Managers and Technical Support Personnel
Prerequisites:
Oracle Foundation Classes, Oracle DBA I or equivalent experience
Course Content:
INTRODUCTION TO BACKUP and RECOVERY
Duties of the DBA
Developing a Backup Strategy
The Backup Plan
PHYSICAL NOARCHIVELOG BACKUPS
Oracle Database Backups
Writing to the Database
LGWR Write Process
Automatic Recovery Architecture
Noarchivelog Mode
Archivelog Mode
Physical Backups
PHYSCIAL ARCHIVELOG BACKUPS
Configuration of the Database for Archiving
Setting the Archivelog Mode
Cold Backups in Archivelog Mode
Hot Backups in Archivelog Mode
COMPLETE RECOVERY
Types of Failure
Recovery Structures and Processes
Recovery When in Noarchivelog Mode
Recovery When in Archivelog Mode
Case Studies in Complete Recovery
INCOMPLETE RECOVERY
What is Incomplete Recovery?
Reasons for Incomplete Recovery
Types of Incomplete Recovery
The RECOVER Command for Incomplete Recovery
Case Studies in Incomplete Recovery
Risk and problems with incomplete recovery
Incomplete recovery
Incomplete Tablespace
Incomplete Datafile
TSPITR AND STANDBY DATABASES
What is Tablespace Point in Time Recovery (TSPITR)?
TSPITR Using a Clone Database
TSPITR Using Transportable Tablespaces
Standby Database
High Availability Options
Standby Database Configuration Options
Creating a Standby Database
EXPORT & IMPORT
Logical Backups Using Export and Import
Exporting Data
Direct Path Exports
Importing Data
Other Uses of Export/Import
ORACLE UTILITIES AND PACKAGES
Methods for Detecting Block Corruption
DBVerify
DB_BLOCK_CHECKING
DB_BLOCK_CHECKSUM
DBMS_REPAIR Packages
LogMiner Utility
RECOVERY MANAGER OVERVIEW
What is Recovery Manager?
RMAN Tools and Features
Recovery Catalog
Backup, Restore and Recover Package
RMAN Maintenance Commands
Supported Backup Types
BACKUP USING RMAN
Recovery Catalog Commands
Steps to set up a Recovery Database
Reports and the Recovery Catalog
Lists and the Recovery Catalog
Backups Using RMAN
RECOVERY USING RMAN
Restore Operations Using RMAN
Recovery Using RMAN
Types of Recovery
Performing a Recovery
BACKUP AND RECOVERY WORKSHOP
Course Labs:
NOARCHIVELOG Physical Backups
ARCHIVELOG Physical Backups
ARCHIVELOG Complete Recovery
ARCHIVELOG Incomplete Recovery
Incomplete recovery
Logical Backup and Recovery
Oracle Utilities
Backup Using RMAN
Recovery Using RMAN
Backup and Recovery Workshop