|
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 |
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 