ADM505 Oracle Database Administration I

Course version: 2005/Q2

Duration

• 3 day(s)

Course Goals

• Describing the structure of an Oracle database
• Administering Oracle databases using SAP tools (BR*tools)
• Putting effective data backup strategies into practice
• Saving and recovering databases

Target Audience

• Database administrators
• SAP system administrators
• Project team members
• Technology consultants

Prerequisites

Essential:

• SAPTEC Fundamentals of SAP Web AS
• Fundamental understanding of Oracle databases

Recommended:

• SAP system administrators should attend the course ADM100 SAP Web AS Administration I
• Basic knowledge of system administration of at least one operating system

Software Component(s) and Release(s)

• WEB AS 6.40
• ORACLE 9.20

Course Content

• Fundamentals of the Oracle database
• Data backups
  - Backup concepts
  - Backing up data
• Database restore and recovery of the database
• Database monitoring
  - Working with BR*tools
  - Working with CCMS tools
• Database storage management

Notes

• The course materials are in English. However, the course is held in the language of the country where it takes place.