Backup & Recovery

Oracle database backup and recovery plays a vital role in oracle database administration. The purpose of a backup and recovery is to protect the database against data loss and reconstruct the database after data loss.

1. Introduction to Oracle Backup and Recovery
2. What is Oracle Backup and its Different Types
3. Oracle Backup and Recovery Key data structures

RMAN

Recovery manager (RMAN) is a command line utility used to perform backup and recovery. RMAN provide greater ease of management and administration of the backup and recovery operations. RMAN backup clause backup database files, archive logs and other oracle database files. RMAN backup performa backups without shutting down the database.

1. What is rman backup
2. RMAN Components
3. RMAN Repository
4. RMAN Catalog
5. Start and Connect to RMAN
6. Monitoring RMAN Through V$ Views
7. RMAN and Scripting and Logfile
8. Backup and recovery operations using RMAN (Part-2)

Configure RMAN

The RMAN backup and recovery environment is preconfigured for each target database. The RMAN configuration is persistent and applies to all subsequent operations on target database, even if you exit and restart RMAN.

1. Configure RMAN
2. Configure RMAN Channel
3. Configure RMAN Control File Autobackup
4. Configure RMAN Retention Policy
5. Configure RMAN Backup Compression
6. Configure RMAN Tablespace Exclusion

RMAN Backup

The primary purpose of RMAN backups is to protect your data. If a media failure or disaster occurs, then you can restore your backups and recover lost changes.

1. Introduction to RMAN Backup
2. RMAN Backup Set
3. RMAN Image Copy
4. RMAN Backup Format
5. RMAN Backup TAG
6. RMAN Compress Backup
7. RMAN Database Backup
8. RMAN Datafile Backup
9. RMAN Tablespace Backup
10. RMAN Archivelog Backup
11. RMAN Controlfile Backup
12. RMAN spfile Backup
13. RMAN Incremental Backup
14. RMAN Incremental Backup Block Change Tracking

RMAN Restore & Recover

Oracle RMAN Recovery involves two parts: restoring a physical backup and then performing recovery with the changes made to the database since the last backup. A media recovery is executed on the user's command, usually in response to media failure. In media recovery, online or archived redo logs can be used to make a restored backup current or to update it to a specific point in time.

Media recovery can restore the whole database, a tablespace or a datafile and recover them to a specified time. Whenever redo logs are used or a database is recovered to some non-current time, media recovery is being performed.

Use the RESTORE and RECOVER commands for RMAN restore and recovery of physical database files.

1. Determining Which Database Files to Restore or Recover
2. Restore and Recovery Database Files With RMAN
3. Restore..Preview Backups
4. Validate Backup
5. Restore ArchiveLogs
6. Restore and Recover Oracle Database
7. Restore Server Parameter File (SPFILE)
8. Restore Control File
9. Recover Datafiles and Tablespaces
10. Recover Whole Database

RMAN Duplicate

RMAN DUPLICATE command creates duplicate database or clone from backups of the target database while retaining the original target database.

1. Duplicating Database using RMAN duplicate command

RMAN Commands

RMAN command list mostly used during the rman backup and recovery operations. These rman commands can be executed at RMAN prompt, or within a RUN block

1. RMAN REPORT command
2. RMAN LIST command
3. RMAN Command Reference
4. RMAN CONFIGURE Command
5. RMAN Connect Command
6. RMAN SHOW Command
7. RMAN BACKUP Command
8. RMAN RECOVER (Block Recovery) Command

RMAN Tools

1. Data Recovery Adviser

Tutorials How to Recover Oracle Database

Commonly performed operations, starting and exiting RMAN, configure RMAN environment, backup restore and recovery operations, and reporting with RMAN.

1. How to Schedule Archive Logs backup using enterprise manager?
2. How to Schedule whole database backup Level-1 using enterprise manager?
3. How to Schedule whole database backup Level-0 using enterprise manager?
4. How to relocate archive-log backups to different disk location?
5. How to check Corruption in Database datafile
6. How to Recover Oracle Datafile or Tablespce
7. How to find Oracle Database DBID
8. How to Recover Database without Backup if all control files are lost

Oracle FlashBack

Oracle Flashback provides an additional layer of data protection. You can use flashback features to view past states of data and rewind your database without restoring backups or performing point-in-time recovery.

1. Introduction to Oracle FlashBack
2. Oracle Flashback Database
3. Oracle Restore Point
4. Oracle Flashback Table
5. Oracle Flashback Drop
6. Oracle Flashback Query

Oracle Performance Tuning

The main responsibility of a DBA is to ensure that the Oracle database is tuned properly (effective utilization of resources in term of database speed and cost). The Oracle database is tunable and allows the database to be monitored and adjusted to increase its performance.

There are many reasons when oracle database tuning is required. User are waiting for database response is a big indication that tuning is required.

1. Query Optimizer Goals
2. Query Optimizer Access path
3. Query Optimizer
4. Query Optimizer Joins
5. Intoduction to oracle tuning
6. Explain Plan
7. Tuning with TKPROF & SQL Trace (Part-1)
8. Tuning using SQL Plus AutoTrace
9. Tuning examples using TKPROF & SQL Trace (Part-2)