NOARCHIVELOG Physical Backups

ARCHIVELOG Physical Backups

Complete Recovery

Incomplete recovery

Logical Backup and Recovery

Oracle Utilities

Data Loading

Backup Using RMAN

Recovery Using RMAN

Backup and Recovery Workshop

• Why back up?

• Types of Failures

• Oracle Recovery Features

• Developing a backup strategy

• The backup plan – defining the MTTR specification

• Instance Failure Recovery

• Establishing a Recovery Time Target

• Fast Start Time-based Recovery

• Online and Resumable Operations

• Flashback Query

• Oracle Database Backups

• Writing to the database

• DBWR and LGWR

• Automatic Recovery Architecture

• NOARCHIVELOG and ARCHIVELOG Mode

• Physical Backups

• Closed Backups in NOARCHIVELOG Mode

• Configuration of the database for archiving

• Setting the ARCHIVELOG mode

• Establishing multiple archiving destinations

• Tuning the archive process

• Closed backups in ARCHIVELOG mode

• Open backups in ARCHIVELOG mode

• Controlfile Backup

• Types of Failures and Recovery

• Recovery Structures and Processes

• Recovery in NOARCHIVELOG Mode and in ARCHIVELOG Mode

• Datafile Verification

• What is incomplete recovery?

• Reasons for needing incomplete recovery

• Types of Incomplete Recovery

• Recovering From Loss Of Current Redo Log Files

TSPITR & Standby Databases

TableSpace Point In Time Recovery (TSPITR)

• Standby Database –Data Guard

• Switchover and Failover

• Real Application Clusters / Cache Fusion

• Replication

• Logical backups using EXPORT and IMPORT

• Exports, Direct Path Export, Imports

• Using Export/Import in Oracle Enterprise Manager

• Methods for Detecting Block Corruption

• DBVerify

• DBMS_REPAIR, DBMS_LOGMNR

• The LogMiner Utility – new enhancements including DDL mining

• Direct load inserts

• SQL*Loader

• What is Recovery Manager?

• RMAN Tools

• RMAN Features

• Recovery Catalog

• Backup, Restore and Recover Package

• Media Management Layer interface

• RMAN Maintenance Commands

• Supported Backup Types

• Recovery Catalog Commands

• Steps to set up a Recovery Database

• Catalog Maintenance Activities and Commands

• The CONFIGURE command

• The CROSSCHECK command

• Creating and running backup scripts

• Reports and the Recovery Catalog

• Lists and the Recovery Catalog

• Backups using RMAN

• Cataloging non-RMAN Backups

• Restore Operations using RMAN

• Block Media Recovery Operations (BMR)

• Trial Recovery

• The RESTORE command

• Performing a recovery