
Explore failure types in Oracle databases with hands-on demos of simple statement failure, unique constraint violations, and deadlocks, including locks, transactions, and basic admin responses.
Demonstrates media failure concepts by taking a disk offline and showing how the data file and dictionary responses affect reads, guiding backup recovery to reassemble the database.
Watch an Oracle instance fail and recover, as crash recovery applies redo, undoes inflight transactions, and uses the alert log to verify the recovery process.
Understand how instance recovery automatically replays log data after a clean shutdown, guided by checkpoint change numbers, log switches, and the roll forward and rollback phases.
Explore archive logging, which copies log files before overwrites to preserve the log stream between backups and enables restoring files by replaying relevant log entries.
Learn cold and hot backups for Oracle 11g, including operating system level copies, when to use alter database begin backup, and how to copy data, log files, and control files.
Complete recovery returns the database to exact point of failure, in lag mode or when running in York, by applying logs during media recovery on data files from last backup.
Demonstrates incomplete recovery by converting a timestamp to a system change number, applying media recovery up to before the change, then restoring data files and performing reset logs to open.
Understand how backup sets and pieces organize Oracle backups, separating database information from archive logs, including control files and parameter files, with tagging and piece sizing for efficient storage.
Learn how image copies work with RMAN: create online data file copies without begin/end backup, stored in the control file, and parallelize using multiple channels for efficient backups.
Perform a cold backup in no-archivelog mode with RMAN by starting and mounting the database, backing up data files and the control file into backup sets.
Demonstrates a cold backup in archive log mode using RMAN in catalog mode, highlighting identical backup syntax and no difference from cold backups.
Enable the block change tracking file, place it in the data directory, and let the system grow it automatically; note it stores eight backups and speeds up incremental backups.
Learn how to enable compression for Oracle database backups, compare uncompressed and compressed backup sets, and assess how data type and encryption affect backup size and time.
Plan backups before recovery, use restore commands to restore from backup sets to a known good point, and safeguard the control file while evaluating the use of a recovery catalog.
Learn how to recover a lost control file with RMAN, using recovery catalog, auto backup, and known good copies, from no mount stage, while managing multi-disk configurations and resetlogs.
Simulate incomplete recovery by rolling back to log sequence 10, move hot backups aside, and use preview and validate to ensure the required backups are in the correct directory.
Demonstrate block level recovery in Oracle 11g by corrupting a block, backing up a table space, and performing RMN block recovery to restore data.
Create a recovery catalog and its tablespace, set up the catalog owner, and register the target database to enable backups with a report schema.
This course series provides the student with all the skills needed to pass Oracle Certified Professional 11g DBA Exam. Join over 50,000 I.T. professionals who are certified against the world's most popular relational database platform. Use the knowledge and skills you gain from this course to advance your career in the I.T. field.
The process of becoming certified broadens your understanding of the database and gives you the skills and understanding required to manage critical systems for some of the largest companies in the world. Certification helps you become a better specialist and hones your skills to the highest levels.