|
|
Overview: Oracle Training Course
This Oracle course is designed for a technical person who is new to database
administration and will enable the delegate to create and maintain backups of Oracle
databases and to identify and action appropriate recovery. Available as a public or closed
course at our London training centre, or can be tailored to your team's requirements and
delivered onsite as a bespoke, customised training course.
Course Content
Course content has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus, or if you have a technical query email .
Duration
2 Days
Who Should Attend
The course is suitable for new database administrators, system administrators and support
staff.
Pre Requisite Skills
Delegates should have a good knowledge of their operating system, SQL*PLUS and PL/SQL.
Course Objectives
At the end of the course the delegate should be able to :
Understand the Oracle architecture.
Design a back-up strategy.
Produce appropriate Backups.
Identify different database failures and take corrective action.
Restore and recover Damaged or destroyed databases with minimal data loss.
Associated Course(s)
Oracle Database Applications Development
Oracle Database Administration
Physical & Logical Backups
Whole, Complete & Incomplete Backups
Implementing Archive Log Mode
Specifying Multiple Local or Remote Log Destinations
24 hour Operations
Mirroring & multiplexing
Designing a Backup Schedule
Testing and Verifying Backups
Offline & Online Backups
Backing up Datafiles
Backing up Controlfiles
Backing up Redo & Archive Logs
Complete Recovery
Incomplete Recovery
Database, Tablespace & Datafile Recoveries
Recovery from Instance Failure
Recovery from Media Failure
Recovery from User Error
Using Export & Import Utilities
Backup using Export
Transportable Tablespaces
Point in Time Tablespace Recovery Using Export & Import
The components of Recovey Manager
The Facilities and Capabilitiues of Recovery Manager
Added Benefits of Using a Repository Database
Backup Using RMAN without a Repository Database
Recovery Using RMAN without a Repository Database
Backup Using RMAN with a Repository Database
Recovery Using RMAN with a Repository Database
Physical Image Backups
Using Backup Sets
Paralell Backup & Recovery (Tape Streaming)
Reporting & Querying the Repository Database
Disaster Recovery Planning
Creating a Standby Database
Maintaining a Standby Database