|
Oracle 8i Certification Exam 3 |
|
Oracle 8i: Backup and Recovery - Exam 3, 1Z0-025
Back to Oracle 8i Certification Training Admin
|
Oracle® 8 Certified Database Administrator CBT Exams 1Z0-001, 013, 014, 015, 016.
|
n61314D
|
$1375.00
|
|
|
Oracle 8i Certified Database Administrator Curriculum CBT Exams 1zo-001, 023, 024, 025, 026.
|
n63312D
|
$1375.00
|
|
|
Oracle Certified Application Developer CBT
|
n61222D
|
$1750.00
|
|
Oracle 8i Certification Training Database Administrator Curriculum CBT CD-ROM Details
63321 - Oracle 8i Backup and Recovery: Strategies and Backups
 This course introduces the learners to the
backup and recovery goals and functions of the various structures and processes in the Oracle architecture. In addition, participants learn to manage archive processing and
maintain a recovery catalog. This course also identifies the concepts associated with performing physical backups with or without Recovery Manager (RMAN).
Learn To Identify the features of the Oracle backup and recovery architecture. Manage database archiving. Maintain a recovery
catalog using Recovery Manager (RMAN). Display the database archive modes and identify the effects of running a database in a given archive mode. Identify different methods to perform physical database backups.
63321 - Oracle8i Backup and Recovery: Strategies and Backups
Unit 1: Oracle Backup and Recovery Architecture
• Select the backup and recovery goals of a database administrator.
• Identify the factors to be considered when defining a backup and recovery strategy.
• 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.
• Match the key Oracle server file structures with their uses.
Unit 2: Database Archiving
• Identify the implications of operating an Oracle database in NOARCHIVELOG mode.
• Identify the implications of operating an Oracle database in ARCHIVELOG mode.
• Sequence the steps to change the archive mode of an Oracle database.
• Manage the database archive process.
• Configure the database for archiving the online redo log files by setting parameters in the
init.ora file.
• Identify the data dictionary views used to obtain the archive log information.
Unit 3: Oracle Recovery Manager
• Select the features of Recovery Manager (RMAN).
• Start Recovery Manager by using the RMAN command.
• Identify the events that occur during the connection process after the RMAN command is executed.
• Select the situations in which a recovery catalog is used.
• Identify the guidelines for creating a recovery catalog.
• Sequence the steps to create a recovery catalog.
• Select the control file characteristics that help in backup and recovery.
• Register a database in the recovery catalog by using RMAN.
• Reset the recovery catalog information to reflect the current state of the target database by using RMAN.
• Select the situations in which the recovery catalog must be resynchronized.
• Record information in the recovery catalog by using the CATALOG command.
• Maintain a recovery catalog by using the CHANGE command.
• Perform the operations to manage channel allocations.
• Identify the options for re-creating a recovery catalog.
• Write the commands to display information from the recovery catalog by using data dictionary views.
• Generate a report with the given requirements by using the REPORT command.
• Generate a report with the given requirements by using the LIST command.
Unit 4: Oracle Backup Methods
• Sequence the steps to perform a closed database backup.
• Perform an open database backup.
• Write the command to create a backup of a control file.
• Identify the issues associated with backing up a read-only tablespace.
• Differentiate between the Logging and Nologging options available for Direct-Load insert operations.
• Select the characteristics of an image copy.
• Select the tasks that RMAN performs in an image copy process.
• Identify the characteristics of a backup set.
• Select the tasks that RMAN performs to create a data file backup set.
• Identify the characteristics of the archive log backup process.
• Identify the constraints in performing a backup when using RMAN.
• Perform a backup by using a stored script.
• Identify the characteristics of an incremental backup.
• Identify the characteristics of a cumulative incremental backup.
• Select the memory utilization characteristics of RMAN.
• Identify the data dictionary views used for backups based on the activity and status information they display.
• Select the methods for troubleshooting RMAN.
Back to Oracle 8i Certification Training Admin
63322 Oracle8i Backup and Recovery: Troubleshooting and Recovery
This course will identify ways of handling different types of failures, diagnosing errors and detecting corruption. Additionally, users will be introduced to the different types of Oracle
recovery methods and how to recover from the loss of a Recovery Catalog and Control File. Finally, this course will present the features and usage guidelines of a standby database and how to manage one.
Learn To Identify the ways of handling different types of errors. Identify and diagnose errors and detect corruption by using different tools. Identify and understand the recovery process
for a database running in noarchive mode and recover a failed database. Identify and understand the complete recovery process for a database in archivelog mode and perform
complete recovery in various situations. Identify and understand the incomplete recovery process for a database in archive mode and perform incomplete recovery in various situations.
Identify the uses, modes, levels and compatibility issues of Export utility, and use the Export utility to create an export file. Identify the uses, modes and NLS considerations of the Import
utility, and the steps in which a table is imported. Identify and import objects into a schema. Identify and sequence steps to start an Oracle database with a missing data file. Identify the
methods to enable parallel recovery, recover from lost control file, Recovery Catalog, data file corruptions. Identify the features and usage guidelines of standby database. Identify and
manage standby database Identify the characteristics of the offline data files in a standby database.
63322 Oracle8i Backup and Recovery: Troubleshooting and Recovery
Objectives
Unit 1: Oracle Recovery Methods
• Identify the ways of resolving statement failure.
• Identify the causes of statement failure.
• Identify the ways of resolving user process failures.
• Identify the causes of user process failures.
• Identify the ways of resolving user error failures.
• Identify the causes of user error failures.
• Identify the recovery process in an instance failure.
• Identify the causes of instance failure.
• Identify the ways of resolving a media failure.
• Identify the causes of media failure.
• Identify a database failure error condition by diagnosing an alert file.
• Identify the features of an alert file.
• Identify a database failure error condition by diagnosing a trace
• Identify the features of a trace file.
• Identify the use of the checksum parameters.
• Verify the integrity of a data file by using the DBVERIFY utility.
• Identify the features of the DBVERIFY utility.
Unit 2: Additional Backup and Recovery Methods
• 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 failed database in the noarchivelog mode by using the ServerManager.
• Restore a database in noarchivelog mode by using RMAN.
• Identify the syntax of the RESTORE command.
• Sequence the recovery steps for archivelog mode database failure.
• Identify the recovery structures for an archive mode database.
• Identify the implications of archive mode recovery.
• Restore the archived logs to a new location by using the alter system command.
• Recover from a closed database failure.
• Identify the syntax of the recover data file command.
• Locate the data files needing recovery by using the dynamic performance views.
• Recover from an open database failure.
• Recover tablespace syntax.
• Identify the use of the v$datafile view.
• Recover a database from loss of data file that does not have a backup.
• Recover a failed database that had a file in hot backup mode.
• Identify the use of the v$backup view
• Recover from the loss of an online redo log file.
• Perform a complete recovery on an initially open database by using RMAN.
• Identify the use of the Set Newname command.
• Identify the implications of incomplete recovery.
• Identify the reasons for incomplete recovery.
• Identify the different types of incomplete recovery.
• Sequence the steps to perform an incomplete recovery.
• Perform a time-based recovery operation.
• Identify the syntax of the recover command.
• Perform a cancel-based recovery operation.
• Recover using a backup control file.
• Recover from loss of current redo logs in an open database.
• Recover from loss of current redo logs in a closed database.
• Perform an incomplete recovery on an initially open database by using RMAN.
Unit 3: Failures and Troubleshooting 2 hours
• Identify the uses of the Export and Import utilities.
• Match the levels of full database export with their purposes.
• Identify the three levels of full database export.
• Create an export file by using the command line interface.
• Identify the compatibility issues associated with the Export utility.
• Identify the characteristics of Direct-Path export and invoke Direct-Path export.
• Identify the characteristics of Direct Path Export.
• Invoke direct path export by using the command line interface.
• Identify the uses of the Import utility for recovery.
• Identify the functions of the modes available in the Import utility.
• Identify the modes available in the Import utility.
• Import objects into a schema by using the command line interface.
• Sequence the steps in which a table is imported.
• Identify the NLS considerations for the Export and Import utilities.
• Sequence the steps to start an Oracle database with a missing data file.
• Identify the situations when you can start the database with missing data files.
• Identify the methods to enable parallel recovery activities.
• Identify the internal activities involved in the parallel recovery operations.
• Identify the situations when considerations must be taken for Read-Only tablespace recovery.
• Identify the methods to recover from loss of controlfile.
• Identify the situations in which a DBA is confronted with recovering or recreating control files.
• Identify the recovery methods for a corrupted data file.
• Identify the methods to recreate a lost recovery catalog.
Unit 4: Oracle Standby Database
• Identify the features of a standby database.
• Identify the need of a standby database.
• Identify the guidelines for using a standby database.
• Create a standby database by using Server Manager.
• Identify the steps of synchronizing the standby and primary databases.
• Activate the standby database by using Server Manager.
• Refresh the standby database control file by using Server Manager.
• Identify the implications on the standby database when the physical structure of the primary database is altered.
• Identify the characteristics of the offline data files in the standby database.
Back to Oracle 8i Certification Training Admin
|
