
	Home About Us Services Site Map White Papers Web Briefings Careers Contact Us

	Training/Mentoring

	Oracle Applications
	Enterprise Performance Management
	Business Intelligence
	Custom Development
	Identity Management (Security)
	Managed Services
	Database Services
	Training/Mentoring
		The Service
		The Value
		Contact Us / Registration
		Oracle Certification Prep
		Course Schedule
		Directions, Travel & Accommodations
		Register Online
	Oracle Licensing
	Project Management
	Rolta Solutions

Oracle Backup and Recovery

Click here to contact us

Course Overview

This course teaches students how to develop and implement backup and recovery strategies to protect enterprise Oracle databases. Students learn how to perform backups using RMAN and Oracle Secure Backup, as well as how to recover from unplanned outages.

Throughout the course, discussions focus on addressing "real-world" scenarios and how to setup and maintain an Oracle database environment that is fully recoverable. These topics are reinforced through the student's participation in structured hands-on lab exercises.

Course Goals

To gain a solid understanding of Oracle backup and recovery products and features: RMAN, Oracle Secure Backup and Flashback Technologies.
To be able to develop a reliable backup and recovery strategy to fully protect an Oracle database environment.
To configure and manage Oracle databases using methods designed to protect it from unnecessary data loss.

Prerequisites

Knowledge of Oracle database administration

Who Should Attend?

Database administrators
Data Warehouse Administrators

Course Materials

Backup & Recovery Notes
Backup & Recovery Reference Book

Duration

Three (3) days

Course Outline

Introduction
- Oracle Recovery Manager
- Oracle Security Backup
- Oracle Backup Methods
- Data Recovery
- Crash Recovery
- Backukp and Recovery Strategy
- Oracle HA Solutions
Database Configuration
- ARCHIVELOG Mode
- Flash Recovery Area
RMAN Backups
- Backup Destinations
- Backup Optimization
- Backup Sets
- Image Copies
- Whole Database Backup
- RMAN Backup Types
- Control File Autobackups
- Using a Media Manager
- Managing Backups
RMAN Recovery
- RESTORE and RECOVER Commands
- Complete and Incomplete Recovery
- Recovery with Backup Control File
- Restore Parameter File
- Restore Control File
- Perform Disaster Recovery
Flashback Technologies
- Flashback Drop
- Flashback Query
- Flashback Versions Query
- Flashback Transaction Query
- Flashback Table
- Flashback Database
RMAN Duplicate Database
- Create Duplicate Database
- Creating Parameter File
- Ensuring Resources Are Available
- The RMAN DUPLICATE Command
Tablespace Point-in-Time Recovery
- TSPITR Concepts
- Preparing for TSPITR
- Fully Automated TSPITR
- Performing TSPITR
- Troubleshooting TSPITR
Recovery Catalog
- RMAN Data Storage
- Recovery Catalog Owner
- Target Database
- Resync Recovery Catalog
- RMAN Stored Scripts
- Backup/Recovering Recovery Catalog
- Recreating Recovery Catalog
- Exporti/Import Recovery Catalog
- Upgrade Recovery Catalog
- Drop Recovery Catalog
Monitoring and Tuning
- Monitor Sessions
- Monitor Jobs
- Monitor Performance
- Tuning RMAN
- Synchronous and Asynchronous I/O
- Channel Tuning
- Tuning Tape Streaming
Oracle Secure Backup
- Interface Options
- Media Concepts
- Backup Pieces and Images
- Media Family
- Tape Drives and Libraries
- Virtual Tape Libraries
- Scheduled Jobs
OSB Installation
- Preinstallation Tasks
- Installation Tasks
- OSB Interfaces
- Configuring Users
- Preauthorizing Access
RMAN and OSB
- RMAN Backup to Tape
- Backup Storage Selector
- Media Families and RMAN
- Disk and Tape Backup Solutions
- RMAN and OSB Jobs
- Tape Backups
- Database Recovery
- RMAN Automatic Failover
File-System Backups
- Media Families
- Backup Windows
- Backup Schedules
- Backup Triggers
- On-Demand Backups
- Backup Requests
- Backup Jobs
File-System Restores
- Locating Backups
- Restoring Backups
OSB Security
- User Access
- Predefined Classes and User Rights
- Defining an Oracle Secure Backup User
- Oracle Secure Backup User: OS Permissions
- Preauthorization
- Authentication
- Leveraging Oracle Security Technology
- Administrative Server Certificate Authority (CA)
- Oracle Wallets
- Encrypted Backups
The Administrative Domain
- OSB Daemons
- OSB Policies and Defaults
- NAS Devices
- Tape Library Properties
- Tape Drive Properties
- Managing Volumes
- OSB Jobs

Disclaimer