Back To Oracle Training Courses

Oracle9i Database Fundamentals II Training CBT Suite

Price: $387.00

CBT Course Overview:

The Self Study Store Computer Based Training Introduction to Oracle9i Database Fundamentals II 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 will help candidates prepare for the Oracle9i OCP DBA Certification and is mapped to Exam 1Z1-032.

Total Training Duration:

24 hours

CBT Course Modules:

• Oracle9i Database Administration: Perform Database Backups Training
• Oracle9i Database Administration: Recover Databases Training
• Oracle9i Database Administration: Set Up Oracle Net Services Training

Training Course Topics:

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