Home    |    Instructor-led Training    |    Online Training     
         
 
Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Unisys Mainframe
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Oracle9i Database Backup & Recovery - DBA II
Oracle Training Overview

One of the most challenging tasks ever presented to database administrators is that of recovery from failure, especially if the recovery must not result in a loss of any data. This course presents all the standard failure scenarios and the best recovery strategies for each. Backup strategies for cold backups, on-line backups, complete and partial backups are discussed. Extensive exercises allow students to simulate failures and perform actual recovery within the workshop.

Oracle Training Prerequisites

The course Introduction To Oracle9i SQL

  • The course Introduction To Oracle9i PL/SQL Language
  • The course Introduction To Oracle9i Advanced SQL
  • The course Oracle9i Database Administration - DBA I
Oracle Training Audience

Target audience for this course is Oracle database administrators.

Oracle Training At Course Completion

The objective of this course is to equip database administrators with the skills necessary to backup a production Oracle database and to recover as much information as possible in the event of a major failure. Significant subjects to be considered are:

  • Consider the various archive modes that the database may operate in and the effect on recovery capabilities of each mode.
  • Consider advanced database configuration options that assist recovery of lost data.
  • Build a backup and recovery strategy with user-managed techniques.
  • Build a backup and recovery strategy with server-managed techniques and the RMAN tool.
  • Configure standby databases as part of disaster recovery using Oracle Data Guard.
  • Learn about advanced techniques that not only recover lost data but endeavor to do so efficiently and rapidly, allowing a quick return to normal operations
Oracle Training Course duration

5 Days

Oracle Training Course outline

Database Recovery Structures
  • The Mechanisms For Recovery
  • Sql Statement Execution
  • Examining The Recovery Components
Identifying The Data Structures
  • Data Structures Within The Database
  • Identifying The Tablespaces
  • Identifying The Control Files
  • Identifying The Alert & Trace Files
  • Identifying The Redo Log Files
Archiving
  • Development Of Backup & Recovery Strategies
  • Managing The Archive Options
User-Managed Physical Backups
  • Backup Characteristics
  • Performing A Full Backup
  • Performing An Offline Tablespace Backup
  • Performing An Online Tablespace Backup
  • Performing Suspend Mode Backups
  • Performing A Control File Backup
An Overview To Database Recovery
  • The Recovery
  • Identifying The Type Of Failure
Instance Recovery & Fast-Start

User-Managed Complete Media Recovery
  • Media Failure Concepts
  • Complete Closed Recovery
  • Complete Open Recovery
  • Handling Special Situations
User-Managed Incomplete Media Recovery
  • About Incomplete Recovery
  • Point-In-Time Based Recovery
  • Handling Special Situations
User-Managed Incomplete Media Recovery
  • About Incomplete Recovery
  • Point-In-Time Based Recovery
Handling & Anticipating Stuck Recoveries
  • About Stuck Recoveries
  • Handling Corruption Of Data
  • Performing Trial Recovery
User-Managed Recovery Troubleshooting
  • Move Data File Location
  • Recovery With No Data File Backup
  • Handling Read Only Tablespaces
  • Handling The Loss Of Control Files
Using The Recovery Manager (Rman)
  • Using The Recovery Catalog
  • Confirming Registration & Other Operations
  • Using Run Blocks & Scripts
  • Allocating Channels
  • Accessing Rman Via Oem
Server-Managed Backups With Rman
  • Performing Full Backups
  • Performing Incremental Backups
Exploring Enhanced Rman Capabilities
  • Resume Failed Backup Operations
  • Establishing A Backup Retention Policy
  • Show All Configuration Settings
  • Generate Catalog Reports
  • Report Schema
  • List Incarnation
Server-Managed Recovery With Rman
  • Recovery Manager Recovery
  • Performing Restoration & File Media Recovery
  • Performing Block Media Recovery
Standby Databases With Oracle Data Guard
  • About The Data Guard Architecture
  • Data Guard Interfaces
Data Guard Configuration & Operation
  • Configuring Log Transport
  • Configuring Log Apply
  • Database Switchover Operations
  • Database Failover Operation
  • Monitoring The Standby Database

Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved