Recovery Manager – I

Recovery Manager – I

 

 

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 all;

Rman>list backup of tablespace users;

To delete backup

Rman>delete backup;