Online Redo eLearning Training
From Serebra Learning Corporation
Backup and Recovery Overview and Configuration in Oracle9i
To describe backup and recovery operations, the backup components, and how to configure these components in an Oracle9i database Oracle database administrators and database operators
more...
User-Managed and RMAN Backup and Recovery in Oracle9i
To describe how to perform user-managed and Recovery Manager backup and recovery in an Oracle9i database Oracle database administrators and database operators
more...
Database Structures in Oracle9i
To describe how to use an Oracle9i database data dictionary, the control files, and the redo log files Anyone wanting to learn about Oracle9i database administration
more...
Manageability Enhancements in Oracle9i
To describe the manageability enhancements of an Oracle9i database Oracle database administrators; developers interested in the technical aspects of Oracle9i database
more...
Availability Features in Oracle9i
To explain how the new features of an Oracle9i database support the maximum availability of a database Database operators, administrators, and developers interested in the new technical features and benefits of an Oracle9i database
more...
Tuning Memory Structures in Oracle9i
To describe how to tune Oracle9i memory structures Anyone wishing to learn about Oracle9i database performance tuning
more...
Oracle Database 10g Managing Backup and Recovery Release 2
To discuss how to manage backup and recovery in an Oracle 10g database Anyone wanting to learn about Oracle Database 10g database administration
more...
Oracle Database 10g Performance Tuning Memory Management
This course covers key concepts related to I/O, Redundant Array of Inexpensive Disks (RAID), and Automatic Storage Management (ASM). The course also covers key concepts related to checkpoint and redo. Lastly, the course covers key concepts related to performing space management. This course is designed for DBAs, database architects, support engineers, and technical consultants.
more...
Working with text and paragraphs in Word 2003
To demonstrate how to format text and organize paragraphs in Word Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent
more...
ECDL ICDL 4 Module 3 Word Processing - Word 2003 Text and Paragraphs
To demonstrate how to format text and organize paragraphs using Word 2003. Note: the exercise items included with this ECDL-approved training are not ECDL certification tests. See www.ecdl.com for further details. End users wanting to attain competency in using a word-processing application; end users wanting to attain competency in using Microsoft Word 2003; end users wanting to attain an ECDL or
more...
Oracle 8i DBA - Data Dictionary and Database Files
...om control files. The planning use and troubleshooting of redo log files will also be explained. The course also provides a list of Data Dictionary views that help in performing these administrative tasks. The course initiates the student learner into hands-on learning by helping them to type in the commands to perform administrative tasks. You will learn to administer stored procedures and
more...
Oracle9i Database Administration: Create a Database


The Oracle9i Database Administration: Create a Database course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle9i. Participants learn about the concepts associated with storage structure components, management of rollback segments, temporary segments, and indexes. In addition, this course discusses how to create and maintain
more...
Oracle9i Database Administration: 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,
more...
Oracle8i Performance Tuning: Managing Memory and Disk I/O
This course is the second in a three-part Oracle8i Performance Tuning series. This course introduces the learner to the application tuning issues that will impact database performance. In addition participants will be introduced to tuning components and functions of the shared pool and the buffer cache. Students will learn how to monitor the contents and usage of the Redo Log buffer. Finally
more...
Oracle8 Performance Tuning: Managing Memory and Disk I/O
This course is the second in a three-part Oracle8 Performance Tuning series. This course introduces the learner to the application tuning issues that will impact database performance. In addition participants will be introduced to tuning components and functions of the shared pool and the buffer cache. Students will learn how to monitor the contents and usage of the Redo Log buffer. Finally
more...
From 123-CBT Computer Based Training
Oracle9i Peformance Tuning Managing Memory and Disk I O

...uning the Library Cache. o Identify the descriptions of redo entries. o Match the statistics used to diagnose disk I/O contention with their descriptions. o Identify the two parameters that allow the DBA to limit the amount of memory used for each Java session. o Identify the performance guidelines to reduce the activity on an overloaded disk. o Identify the methods of striping. o
more...
Oracle9i Database Admin Recover Databases

...ver 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
more...
Oracle9i Database Admin Create a Database

...ed Files and manage data files, control files, and online redo log files using OMF. Describe the data dictionary structure, identify the data dictionary categories, and retrieve data dictionary information. Execute catproc.sql and identify the uses of administrative scripts categories. Identify the properties of stored procedures and packages, the benefits of using
more...
Oracle8i Backup and Recovery Strategies Backups

...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 Duration: 2 Hour(s) Select the features of Recovery Manager (RMAN). Start Recovery Manager by using the RMAN command. Identify the events that occur during
more...
Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention

Course Overview This course is the third in a three-part Oracle8i Performance Tuning series. This interactive course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately.
more...
Oracle8i Performance Tuning Managing Memory Disk I O

...s will learn how to monitor the contents and usage of the Redo Log buffer. Finally, participants will identify database configuration and I/O issues, including tablespace usage and guidelines. L earn To: Identify application tuning issues that will impact database performance. Identify the contents and functions of the shared pool. Identify how the Buffer Cache is managed and
more...
Oracle8i Database Admin Create Databases

...e PL/SQL environment. Identify control files Identify redo log files Identify tablespaces and data files. C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, Technical Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data
more...
Oracle8i Database Admin Manage an Instance

...of a rollback segment. Identify the characteristics of a redo log buffer. Identify the events that cause the Database Writer (DBWR) to write to data files. Identify the events that cause the Log Writer (LGWR) to write to the redo log file. Identify the uses of System Change Numbers. Sequence the steps that occur during COMMIT processing. Identify the advantages of the fast COMMIT process
more...
Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention

...ify different the characteristics of latch types.
Select redo latch tuning goals.
Identify latch contention situations.
Identify courses of action that minimize redo latch contention.
Identify LRU attributes.
Identify goals associated with LRU tuning.
Query V$LATCH and V$LATCHNAME to display information regarding latches.
Calculate the number of hits on LRU latches and increase the
more...
Oracle8 Performance Tuning Managing Memory and Disk I O

...s will learn how to monitor the contents and usage of the Redo Log buffer. Finally, participants will identify database configuration and I/O issues, including tablespace usage and guidelines.
L earn To:
Identify application tuning issues that will impact database performance.
Identify the contents and functions of the shared pool.
Identify how the Buffer Cache is managed and
more...
Oracle8 Backup and Recovery - Troubleshooting and Recovery

... 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
more...
Oracle8 Backup and Recovery - Strategies and Backups

...meters to configure the database for archiving the online redo log files.
Manage the database archive processing.
Identify the v$ views used for obtaining archive log information.
Unit 3: Oracle Recovery Manager
Duration: 2 Hour(s)
Identify the features of Recovery Manager (RMAN).
Identify the Recovery Manager components.
Identify the features of Backup Manager.
Identify the
more...
Oracle8 Database Administration - Create Databases

...ored procedures and packages.
Plan for the creation of redo log files.
Plan for the maintenance of redo log groups.
Redo log members.
Control files.
Identify the process of log switches and checkpoints.
Manage tablespaces and data files.
C ontent Emphasis
Skills-Based
A udience
Database Administrators, system administrators, network administrators, and technical
more...
Oracle8 Database Administration - Manage an Instance

...of a rollback segment.
Identify the characteristics of a redo log buffer.
Identify the events that cause the Database Writer (DBWR) to write to datafiles.
Identify the events that cause the Log Writer (LGWR) to write to the redo log file.
Identify the uses of System Change Numbers.
Sequence the steps that occur during COMMIT processing.
Identify the advantages of the fast COMMIT process
more...
Oracle Database 10g Administration Workshop II Part 2

... file autobackups.
Identify considerations for dropping redo log groups and members.
Sequence the steps involved in noncritical file recovery.
Identify commands that are used for server-managed and user-managed recovery.
Unit 3: Incomplete Recovery
Identify features of incomplete recovery.
Match incomplete recovery types with their features.
Identify guidelines for performing
more...
Oracle Database 10g Administration Workshop I Part 4

Learners will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Learners will also be taught about undo management, lock management, and backup and recovery techniques.
Learn To:
Identify benefits of undo data.
Identify features of undo segments.
Identify undo management tasks that a DBA should perform to
more...
Oracle Database 10g New Features for Administrators Part 4

Oracle Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers new features of Oracle Database 10g such as flash backup and recovery.
Learn To:
Identify features of the flash backup and recovery strategy.
Identify tasks that you perform when using the flash recovery
more...
Office XP New Features Part 2 Access Outlook FrontPage

...nd Internet software. Learn To Identify the undo and redo capabilities of Access 2002. Learn To: Identify the features of error logging in database conversions. Learn To: Convert a database from a previous version to Access 2002 format. Learn To: Identify the enhancements to the message header area in Outlook 2002. Learn To: Identify the capabilities of account selection in Outlook 2002.
more...
From Teach Me IT
Tuning Oracle8 Database Performance

The Tuning Oracle8 Database Performance WBT is the first course in the Oracle8 - Performance Tuning curriculum. This curriculum prepares the students for the Oracle8 Certified Database Administrator Track Exam # 1Z0-014. The course acquaints the users with the basic concept of performance tuning, and also discusses the various diagnostic tools used to diagnose problems in Oracle. It will also
more...
Managing Oracle8 Objects

Managing Oracle8 Objects WBT is designed to acquaint users with the concepts of managing various database objects, such as datafiles, tables, indexes, clusters, views, sequences, synonyms and schema objects. After completing this course, the user will be able to:
Monitor multiple databases
Manage rollback segments
Manage and alter tablespaces
Manage datafiles
Alter datafile availability
more...
Oracle8 Backup & Recovery - I

Oracle8 Backup and Recovery - I WBT is designed to acquaint users with the concepts of backup and recovery operations of the Oracle8 database. This course introduces the user to the basics of database backups, the backup strategies and their implementation, and the Recovery Manager. After completing this course, the user will be able to:
List the database backup methods
Describe the different
more...
