Home > Training > Backup & Recovery > Page 2

Oracle8i Database Backup & Recovery

Course Topics Contd... Page2

Physical Backup Without RMAN
Describing the recovery implications of Closed and Opened Database Backups
Performing backup of Closed Database
Performing backup of Opened Database in Archivelog Mode
Identifying the backup implications of Operations with
Performing backup of Control Files using Different Methods
Listing the Data Dictionary Views useful for Backup Operations

Complete Recovery of an Oracle Database
Noting implications of media failure with a database in Noarchivelog Mode
Recovering (Restoring) a database in Noarchivelog Mode after Media Failure
Noting implications of Instance Failure with an Archivelog Mode Database
Describing a Complete Recovery Operation
Performing recovery of a database in Archivelog Mode after Media Failure

Incomplete Recovery of an Oracle Database with Archiving
Identifying the situations to use an Incomplete Recovery to Recover the Database
Performing an Incomplete Database Recovery
Recovering after Losing Current and Active Redo Log Files
Describing and Performing a Tablespace-Point-in-Time Recovery

Oracle Export/Import Utilities
Using the Export Utility to create a Complete Logical Backup of a Database Object
Using the Export Utility to create an incremental backup of a Database Object
Invoking direct-path method export
Export and Transportable Tablespaces
Using the Import Utility to Recover a Database Object

Additional Recovery Issues
Starting Oracle with Missing Data Files
Parallelizing Recovery Operation
Recovering Read-Only Tablespaces
Recovering from Loss of Control Files
Recovering with Missing Data Files Backup

Oracle Utilities for Troubleshooting
Early detection of block corruption
Using DBMS_REPAIR for recovering a Table/Index with Block Corruption
Using the DBVERIFY utility to validate the structure of an Oracle Database File
Using LOGMINER to analyze the Log Files
Configuring Checksum Operations
Using Log and Trace Files to diagnose problems associated with Backup and Recovery Operations

Oracle Recovery Manager Architecture
Components of RMAN
Advantages of RMAN
Command interface to Stop and Start Database
Content of Recovery Catalog
Media Management Layer and Tape Catalog
Connecting to Recovery Manager

Oracle Recovery Catalog Maintenance
Creating a Recovery Catalog
Using Recovery Manager to register, resynch, and reset a database
Maintaining the Recovery Catalog using change, delete, and catalog Commands
Querying the Recovery Catalog to generate reports and lists
Creating and Executing scripts to perform Backup and Recovery ops.
Creating, storing, and running scripts

Back<<|Next >>