Oracle9i Database Admin Recover Databases

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.

• 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.

The intended audience for this course include Database Administrators, IT managers, and technical professionals. There are no required prerequisites.

Conceptual

NASBA credits: 4 CPE Credits

American English

6 to 8 hours

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

This is primarily online training This is an online eLearning or CBT training program This program may be available on CD

Training Presented in: English