Recovery Manager (RMAN)

on 2:54 PM

Recovery Manager (RMAN) is a utility that can manage your entire Oracle backup and recovery activities.

Backed files with RMAN 

Database Files (with RMAN) 
Control Files (with RMAN) 
Offline Redolog Files (with RMAN) 
INIT.ORA (manually) 
Password Files (manually)

Architectural components of RMAN

1.RMAN executable
2.Server processes
3.Channels
4.Target database
5.Recovery catalog database (optional)
6.Media management layer (optional)
7.Backups, backup sets, and backup pieces

Channels :

A channel is an RMAN server process started when there is a need to communicate with an I/O device, such as a disk or a tape. A channel is what reads and writes RMAN backup files. It is through the allocation of channels that you govern I/O characteristics such as: 

1.Type of I/O device being read or written to, either a disk or an sbt_tape
2.Number of processes simultaneously accessing an I/O device 
3.Maximum size of files created on I/O devices 
4.Maximum rate at which database files are read
5.Maximum number of files open at a time

Backup set :

A logical grouping of backup files -- the backup pieces -- that are created when you issue an RMAN backup command. A backup set is RMAN's name for a collection of files associated with a backup. A backup set is composed of one or more backup pieces.

Backup piece :

A physical binary file created by RMAN during a backup. Backup pieces are written to your backup medium, whether to disk or tape. They contain blocks from the target database's datafiles, archived redo log files, and control files. 

Benefits of using RMAN 

1. Incremental backups that only copy data blocks that have changed since the last backup. 
2. Tablespaces are not put in backup mode, thus there is noextra redo log generation during online backups. 
3. Detection of corrupt blocks during backups. 
4. Parallelization of I/O operations. 
5. Automatic logging of all backup and recovery operations. 
6. Built-in reporting and listing commands. 

Differential backup: This is the default type of incremental backup which backs up all blocks changed after the most recent backup at level n or lower.

Cumulative backup: Backup all blocks changed after the most recent backup at level n-1 or lower.

Restoring : It involves copying backup files from secondary storage (backup media) to disk. This can be done to replace damaged files or to copy/move a database to a new location. 

Recovery : It is the process of applying redo logs to the database to roll it forward. One can roll-forward until a specific point-in-time (before the disaster occurred), or roll-forward until the last transaction recorded in the log files. 

Hot backup : when the database is online 

Cold backup : taken during shut down period

1 comments:

pushpendra said...

cold bkp by rman @mount state.

very nice

Post a Comment