About Training
DESCRIPTION
Duration: 30h
Target: Professionals who want to control and monitor database backup routines, and to make emergency or scheduled restoration.
Requirements: Database Concepts, Basic knowledge of SQL.
Course Objectives
• Review the physical and logical structure of the database
• Understand the differences physical backup and logical database
• Perform backups and restores physical
• Perform backups and restores logical
Shared Server Settings | Manipulating Objects |
Concepts Dispatchers Shared servers Virtual circuits |
Using the EXPORT tool Using the IMPORT Tool Using Tools from 10g Logical Backup Export Data Pump – expdp Import Data Pump – impdp |
Archive Mode | Traditional Physical Backup |
Concepts Checking Archive Mode Enabling Database Archive Mode |
Traditional method BEGIN BACKUP END BACKUP |
Recovery By Traditional Method (Using SQLPLUS) | Physical backup with RMAN |
Concepts RECOVER DATABASE command Database Recovery in SQLPLUS Data File Recovery in SQLPLUS |
Concepts Catalog mode Nocatalog mode Full Backup Database Backup Tablespace Backup Datafile Incremental Backup Database |
Total Recovery and Partial Using RMAN | Full recovery |
Recovery concepts Full Recovery Database Some Recovery Data Files Backup Strategies |
Concepts Recovery to the point of failure |
Incomplete recovery | Recovery Scenarios |
Concepts Based on Time Based on the SCN Based on the Log Sequence |
Loss of a Full Tablespace Loss of a Data File Loss of All Data Files Loss Log Inactive File Loss of a Control File |
Backup Tape Rotation Strategy | |
Concepts GFS model (Grandfather, Father, Son) |

Hire