Oracle9i Database Fundamentals II Curriculum CBT Training CDs

Rating:
Summary: Oracle9i Database Fundamentals II Curriculum CBT
Review: Course Overview
The Oracle9i Database Fundamentals II Curriculum introduces students to backup methods for Oracle9i database administration. The backup concepts covered include backup strategies and requirements, Oracle Architecture, archiving data, backup methods, and working with a standby database. This curriculum also covers the Oracle9i database recovery concepts, to include recovery with and without archiving, recovery of offline and online databases, recovery with missing data files, and incomplete recovery with and without archiving. Participants will learn about the architecture and configuration of Oracle Net Services. It details client-server and web implementations, in addition to additional features such as Dynamic Service Registration and the use of the Oracle Names Server as an LDAP Proxy. This curriculum also discusses the configuration of the Oracle Shared Server and Oracle Names Server.

# This curriculum consists of three courses: Course 64321 Oracle9i Database Administration: Perform Database Backups
# Course 64322 Oracle9i Database Administration: Recover Databases
# Course 64326 Oracle9i Database Administration: Set Up Oracle Net Services

Certification: This curriculum will help candidates prepare for the Oracle9i OCP DBA Certification and is mapped to Exam 1Z1-032.

Learn To
See individual course descriptions for specific course objectives and scope.


Audience
The intended audience for this curriculum include Database administrators, IT managers, and technical professionals.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits Per Course

Language Options
US English

Total Learning Time
18 to 24 hours

Oracle 9i Database Administration: Perform Database Backups Training CD
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.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits

Language Options
Brazilian Portuguese, German, US English

Total Learning Time
Learning time not available

Oracle 9i Database Administration: Recover Databases Training CD
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.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits

Language Options
German, Brazilian Portuguese, Spanish, US English

Total Learning Time
6 to 8 hours

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.
# Identify the implications of an incomplete recovery.
# Sequence the steps to perform an incomplete recovery.
# Perform a time-based recovery operation by using SQL*Plus.
# Perform a cancel-based recovery operation by using SQL*Plus.
# Recover from a backup control file by using SQL*Plus.
# Recover a database that has failed due to the loss of current redo logs in an online database by using SQL*Plus.
# Recover a offline database that has failed due to the loss of current redo logs, by using SQL*Plus.
# Identify the key features of RMAN.
# Match the Recovery Manager command to its corresponding description.
# Identify the naming structure used by RMAN when automatic channels are created.
# Identify Oracle compliant media management software.
# Match the recovery manager database with its corresponding description.
# Identify the difference between the RMAN batch mode and interactive mode.
# Identify the packages RMAN uses to maintain and query information in the recovery catalog and control file.
# Enter the appropriate stand-alone command at the RMAN prompt.
# Recover a specific data file using the UNTIL TIME method.
# Perform a cancel-based recovery using the UNTIL TIME method.


Unit 2: Additional Backup and Recovery Methods 2 - 3 hours
# Identify the uses of the Export and Import utilities.
# Identify the functions of the modes available in the Export utility.
# Match the full database export levels with their purposes.
# Create an export file by using the command line interface.
# Identify the compatibility issues associated with the Export utility when used with other versions.
# Perform a tablespace point in time recovery (TSPITR) using a transportable tablespace.
# Match the recovery command with its description.
# Identify the characteristics of the Direct-Path export.
# Invoke the Direct-Path export by using the command line interface.
# Identify the uses of the Import utility for recovering data.
# Identify the functions of the Import utility modes.
# Import objects into a schema by using the command line interface function.
# Sequence the steps in which a table is imported.
# Identify National Language Set considerations for the Import utility.
# Set the fast-start rollback parameter to HIGH using the Enterprise Manager Console.
# Sequence the steps to start an Oracle database with a missing data file.
# Identify the methods to begin parallel recovery operations.
# Identify the considerations to be taken when performing a read-only tablespace recovery.
# Identify the methods used to recover the control file.
# Identify the recovery methods used to recover a corrupted data file.
# Identify the methods used to re-create a lost recovery catalog.
# Generate a report with the given requirements by using the REPORT command.
# Generate a report with the given requirements by using the LIST command.
# 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.


Unit 3: Failures and Troubleshooting 2 - 3 hours
# Identify the methods for resolving statement failure.
# Identify the manner in which a user process failure is resolved.
# Identify the methods for resolving user error failures.
# Identify the recovery process for an instance failure.
# Set the FAST_START_MTTR_TIME and query the results.
# Identify the tasks to be performed to ensure easy and quick recovery from media failure.
# Identify a database failure error condition.
# Diagnose a trace file to identify a database failure error condition.
# Identify the characteristics of the DB_BLOCK_CHECKSUM parameter.
# Verify the integrity of a data file by using the DBVERIFY utility.
# Match the DBMS_REPAIR utility procedures to their role in the recovery of a table with block corruption.
# Analyze a log file by using the LOGMINER utility.


Oracle 9i Database Administration: Set Up Oracle Net Services Training CD
Course Overview
This course covers the architecture and configuration of Oracle Net Services. It details client-server and web implementations, in addition to additional features such as Dynamic Service Registration and the use of the Oracle Names Server as an LDAP Proxy. This course also discusses the configuration of the Oracle Shared Server and Oracle Names Server.

Learn To
# Sequence the steps required for a client to establish a connection to an Oracle server.
# Match the client and server network components required to perform specific tasks on a Web application client implementation.
# Identify the features of automatic instance registration.
# Configure a local net service name by using the Oracle Net Configuration Assistant.
# Identify the tasks performed to implement an LDAP Proxy naming method.
# Identify the benefits of using the Oracle Shared Server configuration.


Audience
The intended audience for this course are Database administrators. Required prerequisites are Oracle SQL, Oracle PL/SQL. Suggested prerequisites include Oracle9i Database Administration: Manage an Instance (64311), and Oracle9i Database Administration: Create a Database (64312).

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits

Language Options
German, Spanish, Brazilian Portuguese, US English

Total Learning Time
6 to 8 hours

Objectives
Unit 1: Oracle Net Services Overview 1 - 2 hours
# Identify the features of a two-tier network.
# Identify the services provided by the middle tier in an n-tier network.
# Identify the connectivity issues that must be addressed in an enterprise network environment.
# Identify the connectivity features of Oracle Net Services.
# Identify the directory services features of Oracle Net Services.
# Identify the scalability features of Oracle Net Services.
# Identify the security features of Oracle Net Services.
# Identify the accessibility features of Oracle Net Services.
# Sequence the steps required for a client to establish a connection to an Oracle server.
# Match the client and server network components required to perform specific tasks on a Web application client implementation.


Unit 2: Oracle Net Services Configuration 1 - 2 hours
# Identify the characteristics of a listener.
# Sequence the events that occur in a Bequeath session.
# Sequence the events that occur in a Redirect session to a dispatcher.
# Sequence the steps performed in a direct hand-off of a connection request.
# Create a listener.
# Configure a listener for database services.
# Configure the listener logging and tracing options.
# Control a listener.
# Identify the features of automatic instance registration.
# Identify the benefits of the methods used for client-server connections.
# Identify the requirements for making a connection by using the host-naming method.
# Configure local naming.
# Match key parameters with the client-side files generated by Oracle Net Manager.
# Match the client-side connection errors with their probable solutions.
# Configure a local net service name.


Unit 3: Oracle Names Server 2 hours
# Match the service name resolution method with its definition.
# Match the Oracle Names directory object with the appropriate definition.
# Identify the features of two domain naming models.
# Sequence the steps involved in discovering a Names server on the network by an Oracle Names client.
# Sequence the events that occur when an Oracle Names client uses its cache to retrieve Names server information.
# Identify two approaches to configuring an Oracle Names server.
# Create a Names server by using the No Region Database option in Oracle Net Manager.
# Start a Names server by using Oracle Net Manager.
# Configure a region database for a Names server by using Oracle Net Manager.
# Add a service name to a Names server by using Oracle Net Manager.
# Delete a Names server by using Oracle Net Manager.
# Identify the functions of the primary NAMESCTL commands.
# Match the additional NAMESCTL commands with their functions.
# Match the NAMESCTL SET modifier commands with their functions.
# Configure the Oracle Names client profile by using Oracle Net Manager.
# Specify the preferred Names server on the Oracle Names client by using Oracle Net Manager.
# Test a Names server by using Oracle Net Manager.
# Identify the features of Oracle Names as an LDAP Proxy server.
# Identify the tasks performed to implement an LDAP Proxy naming method.
# Identify the advanced features of an LDAP Proxy implementation.


Unit 4: Oracle Shared Server 2 hours
# Match the server configuration method with its description.
# Identify the benefits of using a Multithreaded server configuration.
# Sequence the steps by which a user process communicates with a dispatcher in a Multithreaded server environment.
# Sequence the steps by which a dispatcher interacts with a shared server in a Multithreaded server environment.
# Match the OSS configuration parameter with the appropriate function.
# Match the data dictionary view used to verify OSS setup with the appropriate description.
# Sequence the steps involved in the connection pooling process.
# Identify the MTS_DISPATCHERS parameter that contains the correct attributes to enable connection pooling.