RMAN - I (Basics of RMAN (No Catalog))

RMAN client utility:  

rman (executable)  à $ORACLE_HOME/bin

recover.bsq à $ORACLE_HOME/rdbms/admin/recover.bsq

PL/SQL Packages:

dbms_backup_restore

dbms_rcvcat          owned by user sys

Connecting to the Target Database Without a Catalog from the Command Line

$rman   target  /    nocatalog

To backup the db (all datafiles)

RMAN> backup database;

-        It generates backup pieces and stores in $ORACLE_HOME/dbs and backup set (backup info) into the target db controlfile.

Basic commands for rman:

To backup a single datafile

Rman > backup datafile 10;

To backup a single tablespace

Rman > backup tablespace users;

To backup controlfile

Rman> backup current controlfile;

To backup all archive files

Rman>backup archivelog all;

To backup spfile

Rman>backup spfile;

To backup archive logs and delete them

Rman>backup archivelog all delete input;

To backup all files at a time

Rman>backup database include current controlfile plus archivelog;

To store backup (piece) in a particular location

Rman>backup database format ‘/u01/user18/rmanbkp/full_bkp_%U’;

List & Report Commands

To get information about backups

Rman > list backup;

Rman> list backup of datafile 2;

Rman>list backup of archivelog;

Rman>list backup tablespace users;

To delete backup

Rman>delete backup;