RMAN incremental backup

RMAN incremental backup

RMAN Command

rman> report need backup;
The report need backup command tells you that you must back up which all database files to comply with your retention policy.

rman> report need backup; Report of files with less than 2 redundant backups
rman> list backup ; Gives in detail list
rman> list backup summary ;
rman> backup database tag ‘MON18thFeb’ ;
rman> report obsolete;
rman> delete obsolete;
rman> backup as compressed backupset database tag ‘Full_Backup’ ;
rman> backup incremental level 0 database tag ‘Level0’;
rman> backup incremental level 1 database tag ‘Level1’;
rman>crosscheck backup;
rman>crosscheck archivelog all;

RMAN incremental backup:

1-RMAN LEVEL 0 Backup ; (Full Backup)

RUN
{
BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 0 DATABASE INCLUDE CURRENT CONTROLFILE FILESPERSET 4 TAG ‘LEVEL0’;
DELETE NOPROMPT FORCE EXPIRED BACKUP;
DELETE NOPROMPT OBSOLETE;
}

2- LEVEL1 Backup:

Run
{
BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 1 DATABASE INCLUDE CURRENT CONTROLFILE FILESPERSET 4 TAG ‘LEVEL1’;
DELETE NOPROMPT FORCE EXPIRED BACKUP;
DELETE NOPROMPT OBSOLETE;
}

3-Archivelog backup:

run
{
BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL NOT BACKED UP FILESPERSET 10 DELETE ALL INPUT TAG ‘ARCH’;
DELETE NOPROMPT FORCE EXPIRED BACKUP;
DELETE NOPROMPT OBSOLETE;
}

 

Leave a Reply

Your email address will not be published. Required fields are marked *