Oracle 11g Certified Professional Exam Prep II

Compare cold backups, hot backups, outline what to back up, and explain how operating system level copies and database coordination are handled in user-managed backups.

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.

Study cold backups, performed with the database off, and why they are called consistent backups. Learn what to copy, like data and control files, and when to include logs.

Demonstrates a basic cold backup by shutting down the database and copying data files, control files, and logs to a backup folder as a recovery starting point.

Explore hot backups in Oracle 11g: copy data files during archive log mode using begin backup, record checkpoint changes, and back up control files while avoiding log copies.

Demonstrates hot backup of a running database, starting with archival mode and a cold backup, then performing subsequent hot backups and creating a trace for recovery.

Learn to recover a database by planning recovery steps, backing up before recovery, and rolling forward from a known good point using archive logs, then understand complete versus incomplete recovery.

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.

Perform a complete recovery of the users tablespace in Oracle 11g by simulating a failure, deleting the file, and applying archived logs for media recovery.

Demonstrate complete recovery while the database remains open. Offline the users tablespace, delete the data file, and recover the tablespace using a hot backup and media recovery.

Demonstrate starting the database with a missing data file. Open the rest of the database and apply media recovery to restore the data file from backups.

Demonstrates recovering an Oracle database in no-archivelog mode by restoring damaged datafiles from the last known good backup, then opening the database after careful file replacement.

Learn how incomplete recovery in archival mode in Oracle 11g rolls the database back to a prior point using the backup and logs, with log miner and reset logs.

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.

Backups before a reset logs operation belong to the old database incarnation; perform a cold backup to establish a new starting point for archive logging and log sequence numbers.

The log miner demo teaches using log miner to read archived logs and identify when the job history table in the hr schema was deleted using a dictionary.

Watch the demo of losing a control file and recovering by relocating or recreating it, then starting up in mount, emphasizing the need for multiple control files.

Demonstrates recovering an Oracle 11g database using a backup control file, after performing archive logs and hot backups, and simulating control file loss.

Recover data using a backup control file by replacing current data files with backup copies and rolling forward with archive logs. Mount and reset logs to finalize recovery.

Learn recovery flowcharts for Oracle 11g, covering data file, log file, and control file recovery, archive log mode decisions, and complete or incomplete recovery.

Learn oracle's recovery manager to replace user-managed backups with smarter, on-the-fly backups that bypass temp storage, track backups, and enable incremental, compressed, and encrypted options for efficient restore.

Explore the RMAN architecture, including the target instance at the mount stage, control files, and the recovery catalog, and learn how channels create backup sets or image copies.

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.

Learn to run a hot RMAN backup of a running Oracle database on Windows, creating a backup set with a unique name and tag while observing channels and backup pieces.

Explore backups mechanics, from cold and hot backups to incremental backups, compare archive log mode with no archive logs, and cover control file backups, compression, encryption, and tape options.

Learn how to perform cold backups with RMAN, connecting to the target database, mounting it, ensuring control file access, and backing up the database.

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.

Learn how to perform hot backups on Armaan system, using the same commands as cold backups, by connecting to the target database and issuing a backup with an optional format.

Demonstrate a hot backup in no-archivelog mode while the database is open and not archiving. Hot backups are not possible in no-archivelog mode, regardless of backup method.

watch a hot backup demo for Oracle 11g, showing open database backups with the same syntax as cold backups. It covers creating backup folders and mentions table space backups.

Learn how to back up the control file with RMAN, including backups as backup sets and image copies, and understand the snapshot control file created during the process.

Learn to perform image copies of a user's tablespace with RMAN, instead of backup sets, while the database is open, and view data files with the report schema.

Discover how RMAN backs up archive logs as part of the database backup using log switching, and how to back up or delete archive logs after backup.

This demo shows how to back up a database including archive logs using hot backups, log switches, and archive log backups, then clean up archived logs to free space.

Explore how RMAN incremental backups track changed blocks and skip unused blocks, supporting cold or hot backups. Compare differential and cumulative backups, level zero backups, and block change tracking file.

Demonstrates RMAN incremental level zero backup creation, including a backup directory and cold backups, and notes that level one backups without a prior level zero create a level zero backup.

Perform an incremental level 1 backup after level zero backup, showing only changed data is backed up without block change tracking, with a compact size that includes the control file.

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.

Enable control file autobackup to automatically include the control file with backups. Use include current control files index to add the current control file with each backup.

Configure control file auto backup and its format to disk, create a dedicated auto backup folder, and verify the control file is backed up with each backup.

Explore Oracle backup compression options, including block and binary compression, with automatic unused-block skipping. High compression levels depend on edition, with cpu intensive modes offering better backups, not image copies.

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.

Master complete RMAN recovery in Oracle 11g by mounting the database, restoring from backup sets, recovering logs, and opening the database for both non-critical and system data files.

Learn how to perform a complete recovery of the users tablespace with RMAN, using backups to recover a deleted data file and bring the tablespace online.

See a complete recovery demo for a critical system data file using RMAN. A missing data dictionary is restored from the latest backup and the database opens automatically.

Explore incomplete recovery in RMAN, restoring entire database from mount and using set until to roll forward to a time, scn, or log sequence number; table spaces cannot be restored.

Prepare an incomplete recovery demo by creating multiple archive logs, simulating a user mistake that deletes rows, and performing backups with archive logs to enable restoration.

Perform incomplete recovery with rman to roll the database forward to log sequence 40, restore archive logs, and open reset logs to create a new incarnation.

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.

Shows how to recover a missing control file from autobackup, restore and mount the database, and recover the database to log sequence 15.

Explore RMAN's preview and validation features to verify on-disk backups, move files to new locations, and restore blocks or databases via the control file, incarnations, and the recovery catalog.

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.

Discover the RMAN repository concept and how the control file stores backup records and settings. Compare this with the recovery catalog, which provides redundancy and cross-database script storage.

Learn to create a recovery catalog in its own database, set up a catalog schema, grant privileges, and register target databases to track backups and incarnations.

Create a recovery catalog and its tablespace, set up the catalog owner, and register the target database to enable backups with a report schema.