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) |
30H
Hire
