|
Oracle Backup and Recovery Workshop
This workshop gives an introduction to the backup and
recovery of an ORACLE Relational Database and is based on ORACLE 8 or 8i,
although the underlying principles may be applied to Version 7.
Select here for related
courses |
Select here for
a list of all courses |
OBJECTIVES OF THE COURSE
To take students with minimal or no backup experience to a level
which will allow them to understand the functions of a database backup mechanism and
allow effective and reliable backups to be made.
| COURSE CODE |
OV1 |
TUTORS |
Ken Marr email
|
| DURATION |
2 days |
VENUE |
Harwell Training
Centre ** |
| PRICE |
£500 plus VAT * |
BOOKING CONTACT |
Mick Hosegood email |
| EXPERIENCE LEVEL |
Experienced SQL User |
TECHNICAL CONTACT |
Mick Hosegood email |
*see note
at bottom for special savings! for pricing for a course run especially for your
organisation, please use our worksheet
**Also available on your site
for groups of four to ten.COURSE
DATES:
|
Scheduled on demand and on-site
|
|
Call for dates
|
INTENSITY: About 40% of the course is practicals, and 60%
lectures.
RESOURCE: Each student will have exclusive use of a computer
workstation for the duration of the course. Each student will be provided with
a full set of training notes relating to the course.
PREREQUISITES: The workshop is only suitable for those
who have attended the Introduction to ORACLE SQL course. It is also recommended
that the delegate has several months hands on experience of the use of both
SQL and SQL*Plus and some knowledge of PL/SQL.
If this is not the case then an optional module of this workshop,
SQL and PL/SQL Revision is recommended. .
FOLLOW UPS: First Alternative offer a variety of Oracle courses:
Oracle PL/SQL - Oracle SQL*PLUS, PL/SQL course - Oracle PL/SQL Oracle Database Administration - Oracle Database Administration
PRACTICALS / TAKEAWAYS: Each student leaves the course with
his own set of training notes for the material covered.
SOFTWARE VERSIONS: This course is based on Oracle 8.
TOPICS COVERED ON THE COURSE
Introduction
Objectives. Prerequisites. Bibliography .
System Architecture
Database Versus Instance. The Database Instance. System Global Area.
Process Structures. The Database Files. Physical files. Logical files. How Oracle Works.
Server Management
What Tools are Available? SQL*Plus. Server Manager. Start up and Shutdown.
Database Modes, Nomount, Mount and Open, Restrict.
Simple Backup and Recovery
What is a Backup? Recovery? Rollback Segment? Redo Log?
Backup Without Archiving. The Files to Backup. Advantages and Disadvantages.
Full Recovery. Types of Failure.
Complex Backup and Recovery
Backup With Archiving. The Files to Backup. Advantages and Disadvantages.
Archive Mode. Partial Recovery. Types of Failure.
Recovery Manager
Using Recovery Manager to Backup and Recover. Planning a Backup Strategy.
|
Home 