The Leader In Oracle, SAP Applications training & Consulting

   Company       Services       Education       News & Events       Jobs & Careers       Site Map       Home   
   
Education
Training
Courses
Orientation
 Schedule
Boot Camps


Training >> Courses >> Oracle DBA 9i/10g

Backup and Recovery

Course Description

This course gives the oracle database administrator (DBA) a firm foundation in day-to-day database administrative tasks.  This course helps the database administrator to configure a network environment for a client-server system and develop network configuration and recovery techniques for databases.

Course Objectives:

· Learn about backup and recovery procedures using RMAN to resolve database
· Learn about oracle network architecture
· Learn about export and import utilities to transport data between databases.

Course Contents:

· Backup concepts
· Hot Backup / Online Backup
· Cold Backup / Offline Backup
· Data pump and Export Import
· RMAN Setups and Backup using RMAN
· Creating RMAN respository
· Taking different kinds of Backup using RMAN (Incremental level 0, level 1, cumulative
· Flash Back options of database
· Dataguard setup strategy
· Recovery concepts
· Recovery of non-system datafile
· Recovery from loss of system datafile
· Recovery of UNDO tablespace
· Oracle Recovery from TEMP files
· Recovery from loss of online redologs
· Recovery from loss of single controlfile
· Recovery noarchieve log database
· Complete and Incomplete recovery (Both Manual and using RMAN will be covered)
· Recovery of whole database
· Recovery of database: Time Based
· Recovery of database: Change based
· Recovery of database: Cancel based
· Recovery of read only tablespace
· Partial Recovery of daabase
· Recovery from Hot Backup
· Recovery from Cold Backup
· Recovery while database crushed during Hot Backup
· Handling No-logging operations (Both Manual and using RMAN)

Find out more about Amfasoft's education offerings


Amfasoft Corporation �2004 | Privacy | Legal Terms of Use