RMAN backup

 1)Backupsets 

2)Images copies

1)Backupsets 

Whole database backup

Full database backup

Partial database backup

Whole database backup:

Whole backups of a database include the complete contents of all datafile of the database, plus control file,arhived redo log files, and server parameter files 

RMAN>backup database plus archivelog;

Full database backup:

Full backups of a database include the complete content of all datafiles of the database plus the controlfile and server parameter file 

RMAN>backup database;

Partial database backup:

Backup of all datafiles for an individual tablespace 

Backup a single datafile.

 RMAN>backup tablespace users;

RMAN>backup datafile 6;

Image Copies:

An image copy backup is the exact copy of the data files including free space.

RMAN>backup as copy database;

Cold or consistent backup :(offline backups)

offline backups are taken while the database is not open.

Hot or Inconsistent backup :(Online backups)

Online backups are taken while the database is open.

RMAN Tools:

RMAN> backup database plus archivelog

RMAN> backup database;

RMAN> backup tablespace users;

RMAN> backup datafile 6;

RMAN> backup archivelog all;

RMAN List Backup Commands:

RMAN>list backup;

RMAN>list backup summary ;

RMAN>list backup by file;

RMAN>list backup of database;

RMAN>list backup of tablespace system;

RMAN>list backup of tablespace users;

RMAN>list backup of datafile 1;

RMAN>list backup of datafile 2;

RMAN>list backup of controlfile;

RMAN>list backup of archivelog all;