|
Provided by: 123-CBT Computer Based Training Oracle9i Database Admin Recover Databases |
 |
Course Overview
This course introduces students to Oracle9i database recovery concepts. The recovery concepts course includes recovery with and without archiving, recovery of offline and online databases, recovery with missing data files, and incomplete recovery with and without archiving. Additional concepts covered by this course include time-based recovery, cancel-based recovery, recovery manager components, recovery manager commands, export and import utilities, user managed recovery, fast-start on demand rollback, recovery manager report generations commands, maintaining the recovery manager catalog along with failure points, and troubleshooting recovery problems.
Learn To
• Identify the files to be restored for a database in the NOARCHIVELOG mode.
• Store the archived logs in a new location using the ALTER SYSTEM command.
• Perform a offline database recovery.
• Recover a database that failed due to the loss of a data file without a backup.
• Perform a time-based recovery operation.
• Recover a database that has failed due to the loss of current redo logs in an online database.
• Create an export file using the command line interface.
• Import objects into a schema by using the command line interface function.
Audience
The intended audience for this course include Database Administrators, IT managers, and technical professionals. There are no required prerequisites.
Content Emphasis
Conceptual
Deployment Options
Accreditation
NASBA credits: 4 CPE Credits
Language Options
American English
Total Learning Time
6 to 8 hours
64322 Objectives
Unit 1: Oracle Recovery Methods
2 hours
• Identify the files to be restored for a database in the NOARCHIVELOG mode.
• Identify the implications of recovering a database in the NOARCHIVELOG mode.
• Recover a database in the NOARCHIVELOG mode by using SQL*Plus.
• Restore a database in the NOARCHIVELOG mode by using RMAN.
• Sequence the steps to recover a failed database when it is in the ARCHIVELOG mode.
• Store the archived logs in a new location by using the ALTER SYSTEM command.
• Perform a offline database recovery by using SQL*Plus.
• Perform an online database recovery by using SQL*Plus.
• Recover a database that failed due to the loss of a data file that does not have a backup by using SQL*Plus.
• Recover a database that contained a file in the hot backup mode by using SQL*Plus.
• Recover a database that failed due to the loss of an online redo log file by using SQL*Plus.
• Perform a complete recovery on an online database by using RMAN.
• Identi
|
|
||||||||||
