• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

IT Vendor Courses   Oracle DBA Training Courses

DBA Part II - Backup & Recovery and Networking

View course dates

Course Duration: 5 days

Course Code: OBRN

Course Description:

This course is for Database Administrators, Systems Administrators and Network Managers who need to plan and implement database backup and recovery strategies for an Oracle9i database and who are also required to configure Oracle databases in a network environment. By the end of this course, the delegate will have been given practical experience in using the various Oracle backup and recovery commands. He/she will gain experience of different failure and restore situations. The delegate will also have had practical experience in configuring Net Architecture, the Oracle Shared Server and the Listener. Experience of troubleshooting simple network problems will also have been gained. This course covers the main backup and recovery and networking topics for the Oracle9i Database: Fundamentals II examination (IZ0-032).

Prerequisites:

A working knowledge of SQL*Plus and an understanding of Oracle database administration is required. This can be obtained by attendance on the Pre-Requisite courses. A good working knowledge of operating system commands is also required. Pre-Requisites Courses: SQL*Plus (OSP) and DBA Part I - Architecture & Administration (ODA). Note: Before taking any exam, ensure you have the recommended experience.

Prerequisite courses:

SQL*Plus

DBA Part I - Architecture & Administration

Relevant Certifications:

Oracle9i Database Administrator

This course includes the following modules:

Topics Covered

• Backup and Recovery Strategies
• Disaster Recovery Plan
• Failure Scenarios
• Oracle Recovery Structures and Processes
• Using ARCHIVELOG and NOARCHIVELOG Modes
• Physical Backups
• Complete Database Recovery
• Incomplete Recovery with Archiving
• Additional Recovery Issues
• The Export and Import Utilities
• Loading Data with SQL*Loader
• Troubleshooting Utilities
• Recovery Manager Overview
• Creating and Maintaining a Recovery Catalog
• Backing up and Restoring with RMAN
• Data Guard
• Oracle Networking Overview
• Configuring the Oracle Network
• Oracle Net Architecture
• Net Configuration
• Oracle Net Manager
• Oracle Net Configuration Assistant
• Net Server Side Configuration
• Net Client Side Configuration
• Listener Configuration using Oracle Net Manager
• Configuration of Net Service Names
• Configuration of the Oracle Shared Server
• Overview of Oracle Internet Directory
• Troubleshooting the Network Environment
• Network Environment Security

 

To make an enquiry for this course to be run ONSITE at your location, click here or call Sales on +44 (0) 20 7620 0033.

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course