Oracle Latest Technology: Oracle RMAN Tutorial Part 1 Creating and configuring RMAN repository

Here are the basic description on RMAN configuration and setup. By reading this article you can configure a RMAN by yourself in a very practical manner. I have only concentrated on RMAN practical implementation perspective here.

First lets check how to setup a RMAN repository. Ideally this repository should be a other database than target[the db which would be backed up] database.

Repository Catalog Creation and Configuration

create tablespace
$ sqlplus / as sysdba

SQL> create tablespace rman datafile '/u01/.....dbf' size 125m autoextend on next 50m maxsize 500m;
SQL> grant recovery_catalog_owner to rmanUser identified by rmanUser;
SQL> alter user rmanUser default tablespace rman quota unlimited on rman;

Create catalog
$ rman catalog rmanUser/rmanUser@<rman Catalog db>

RMAN> create catalog;

Register a Target Database

$ rman target / catalog rmanUser@<rman Catalog db>

RMAN> register database;

Now, show all default RMAN settings.

RMAN> show all;

Now, check how to change some of the default configuration. Lets change the retention policy first.

RMAN> configure retention policy to recovery window of 2 days;
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/s1/ors/backup01/rmanbackup/control_backup/controlfile_Weekly%F.trc';
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/s1/ors/backup01/rmanbackup/control_backup/snap_control_file_Weekly_PORS.f';
RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 1;
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/sky1/UORSrmanbkp/FULL/backup_Weekly_%D_%s_%p_%t.rman' MAXPIECESIZE 2048M;

configure the backup as compressed backup.

RMAN> configure device type disk backup type to compressed backupset;

Some common initialization parameter ->

DB_RECOVERY_FILE_DEST = location of RMAN disk backup by default. Also the flash back up recovery location.
DB_RECOVERY_FILE_DEST_SIZE = upper limit flash back up recovery size.