Archival database for long-term backups
Hi,
I'm in the midst of process to setup archival backup for 5 years retention period.
Plan to using daily backup script and tagging as a 5 years backup.
DB version : 12c Enterprise Edition Release 12.1.0.2.0
connect target /
run {
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/vol_name/15yr/%F_CNT_0';
ALLOCATE CHANNEL C1 TYPE DISK;
Backup as compressed backupset Database tag DB_Full_15yrbkp format '/vol_name/15yr/full_vmSPDBSTG2_%U';
sql 'alter system archive log current';
BACKUP ARCHIVELOG ALL TAG Arc_Full_15yrbkp FORMAT '/vol_name/15yr/arch_vmSPDBSTG2_%U';