RMAN DATABASE BACKUP

RMAN DATABASE BACKUP 

Connect to the local target database.

rman target / nocatalog

Restoring spfile and controlfile;

strartup force nomount;

restore spfile from file 'file_name';

resotore controlfile from 'file_name';

Reports of database backup.

report schema;

list backup of database;

list backup of archivelog all;

Taking the Database Backup.

backup database;

backup tablespace users;

backup datafile 1;

Restore the Database:

resotre database;

restore tablespace users;

restore datafile 1;

Recovering the database;

recover database;

recover database until time 'dd-mm-yyy  hh24:mm:ss';

recover database until scn 'scn';