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.






Oracle RMAN Tutorial Part 1 Creating and configuring RMAN repository


Oracle RMAN Tutorial Part 2 BACKUP OPERATION


Oracle RMAN Tutorial Part 3 Recovery Operation

1 comment :

rebeka christy said...

Its really great information..Thanks for sharing this informative blog..

Oracle Training