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