Oracle9i Database Administration: Strategies and Backups

Audience

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

Objective

Upon completion of this course the student will understand:

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

Topics Include

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 steps required to change the archive mode of an Oracle database.
• Set the LOCATION parameter for the log archive destination in the Enterprise Manager Console.
• Set the log_archive_dest to optional at the command prompt.
• Change the state of an archiving location using the Enterprise Manager Console.
• Configure a secondary archive destination using the LOG_ARCHIVE_DUPLEX_DEST parameter.
• 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 that areused to obtain archive log information.

Unit 3: Oracle Backup Methods 2 hours

• Match the RMAN dynamic view with its corresponding description.
• Place the steps for monitoring RMAN in the order they occur.
• 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 that are available for direct-load insert operations.
• Shut down the database and backup up all critical datafiles using a operating system utility.
• Use the alter database command to backup a control file on an open database.
• Place each step required for backing up in noarchivelog mode in chronological order.
• Identify the constraints in performing a backup when using RMAN.
• Select the characteristics of an image copy.
• Select the tasks performed by RMAN in an image copy process.
• Identify the characteristics of a backup set.
• Select the tasks performed by RMAN to create a data file backup set.
• Identify the characteristics of the archive log backup process.
• Identify the parameter used to multiplex files with the backup command.
• Match the command to the corresponding description.
• Match the command to its corresponding description.
• Identify the data dictionary views used for backups based on the activity and status information they display.
• Select the methods for troubleshooting 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.
• Sequence the steps involved in the manual control file backup process.

Unit 4: Oracle Standby Database 2 hours

• Identify the features of a standby database.
• Identify the guidelines for using a standby database.
• Create a standby database by using SQL* Plus.
• Identify the steps for synchronizing the standby databases.
• Identify the steps to setup the standby database in read-only mode.
• Activate a standby database by using SQL* Plus.
• Refresh a standby database control file by using SQL*Plus.
• Identify the methods for updating a standby database when the physical structure of the primary database is altered.
• Identify the characteristics of the offline data files in a standby database.

Duration

6

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

CDROM
Web Based Training