|
Provided by: 123-CBT Computer Based Training Oracle9i Database Admin Perform Database Backups |
 |
Course Overview
This course introduces students to backup methods for Oracle9i database administration. The backup concepts covered by this course include backup strategies and requirements, Oracle Architecture, archiving data, backup methods, and working with a standby database. Students perform backup procedures using operating system utilities, Oracle9i utilities such as RMAN, standard SQL*Plus commands, and the Oracle Enterprise Manager Console. Students assess the status of critical database files using SQL*Plus commands. In addition, students create a standby database, identify the steps involved in synchronizing a standby database, and activate, refresh, and update a standby database.
Learn To
• Identify the factors to consider when defining a backup and recovery strategy.
• Multiplex control files by copying them with an operating system utility.
• Place a log member from two log groups in a specific directory.
• Identify the implications of operating an Oracle database in NOARCHIVELOG mode.
• Change the state of an archiving location using the Enterprise Manager Console.
• Sequence the steps to perform a closed database backup.
• Identify the parameter used to multiplex files with the backup command.
• Create a standby database by using SQL* Plus.
Audience
The intended audience for this course include Database administrators, IT managers, and technical professionals. There are no prerequisites for this course.
Content Emphasis
Conceptual
Deployment Options
Accreditation
NASBA credits: 4 CPE Credits
Language Options
American English
Total Learning Time
6 to 8 hours
64321 Objectives
Unit 1: Oracle Backup Architecture
1 - 2 hours
• Select the backup and recovery goals of a database administrator.
• Identify the factors to consider when defining a backup and recovery strategy.
• Match the DBA consideration to the backup and recovery results.
• Multiplex control files by copying them with an operating system utility.
• Match the key Oracle server file structures with their uses.
• Differentiate between the user and server processes for user interaction with a database.
• Match the key Oracle memory structures with their functions.
• Match the functions of the key background processes with their functions.
• Place a log member from two log groups in a specific directory.
Unit 2: Database Archiving
1 - 2 hours
• Identify the implications of operating an Oracle database in NOARCHIVELOG mode.
• Identify the implications of operating an Oracle database in ARCHIVELOG mode.
• Sequence the step
|
|
||||||||||
