/rman_fullbackup.sql Secret
Last active
December 16, 2015 22:29
Rman fullbackup script
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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