Oracle Sample Rman Scripts

Rman full backup script;

	run {
	CONFIGURE DEVICE TYPE DISK PARALLELISM 3;
	BACKUP AS COMPRESSED BACKUPSET
	DEVICE TYPE DISK
	FORMAT '/backup/rman_backup/11gIsFull_%d_%u_%s_%T'
	DATABASE;
	crosscheck archivelog all;
	delete expired archivelog all;
	BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL FORMAT '/backup/rman_backup/arch_%d_%u_%s_%T';
	backup spfile format '/backup/rman_backup/spfile_%d_%s_%T_dbid%I';
	backup current controlfile format '/backup/rman_backup/ctl_%t_dbid%I';
	CROSSCHECK BACKUP;
	DELETE NOPROMPT ARCHIVELOG UNTIL TIME "SYSDATE-3";
	}

view raw rman_fullbackup.sql hosted with ❤ by GitHub

Rman Level 1 Cumulative;

	run {
	CONFIGURE DEVICE TYPE DISK PARALLELISM 3;
	BACKUP AS COMPRESSED BACKUPSET
	INCREMENTAL LEVEL = 1 CUMULATIVE
	DEVICE TYPE DISK
	TAG = 'LEVEL1-MONDAY'
	FORMAT '/backup/rman/11gRacInc_%d_%u_%s_%T'
	DATABASE;
	crosscheck archivelog all;
	delete expired archivelog all;
	BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL FORMAT '/backup/rman/arch_%d_%u_%s_%T';
	backup spfile format '/backup/rman/spfile_%d_%s_%T_dbid%I';
	backup current controlfile format '/backup/rman/ctl_%t_dbid%I';
	DELETE NOPROMPT ARCHIVELOG UNTIL TIME "SYSDATE-3";
	}

view raw rman_lvl1.sql hosted with ❤ by GitHub

Rman Level 0;

	run {
	BACKUP AS COMPRESSED BACKUPSET
	INCREMENTAL LEVEL = 0 CUMULATIVE
	DEVICE TYPE DISK
	TAG = 'LEVEL0-SUNDAY'
	FORMAT '/backup/rman/11gRacFull_%d_%u_%s_%T'
	DATABASE;
	crosscheck archivelog all;
	delete expired archivelog all;
	BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL FORMAT '/backup/rman/arch_%d_%u_%s_%T';
	backup spfile format '/backup/rman/spfile_%d_%s_%T_dbid%I';
	backup current controlfile format '/backup/rman/ctl_%t_dbid%I';
	CROSSCHECK BACKUP;
	DELETE NOPROMPT OBSOLETE;
	DELETE NOPROMPT EXPIRED BACKUP;
	DELETE NOPROMPT ARCHIVELOG UNTIL TIME "SYSDATE-3";
	}

view raw rman_lvl0.sql hosted with ❤ by GitHub