Skip to content

Instantly share code, notes, and snippets.

@ecimen
Last active December 16, 2015 22:29
Rman fullbackup 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";
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment