Hi everyone, I have a full backup script scheduled for every sunday:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
run {
BACKUP AS BACKUPSET FILESPERSET 10 INCREMENTAL LEVEL 0 TAG 'dbaas_incr_backup_prd' DATABASE FORMAT '/nfsbup/PDB_00000169/%d_t%t_s%s_p%p' CURRENT CONTROLFILE FORMAT '/nfsbup/PDB_00000169/%d_C_%T_%u' SPFILE FORMAT '/nfsbup/PDB_00000169/%d_S_%T_%u' plus archivelog FORMAT '/nfsbup/PDB_00000169/%d_A_%T_%u_s%s_p%p';
DELETE FORCE NOPROMPT ARCHIVELOG ALL BACKED UP 1 TIMES TO DISK COMPLETED BEFORE 'SYSDATE - 1';
DELETE FORCE NOPROMPT OBSOLETE;
BACKUP CURRENT CONTROLFILE FORMAT '/nfsbup/PDB_00000169/%d_C_%T_%u' SPFILE FORMAT '/nfsbup/PDB_00000169/%d_S_%T_%u';
}
and an incremental level 1 backup script scheduled every day (excluding sundays):
run {
allocate channel ch1 type disk;
BACKUP AS BACKUPSET FILESPERSET 10 INCREMENTAL LEVEL 1 TAG 'dbaas_incr_backup_prd' DATABASE FORMAT '/nfsbup/PDB_00000169/%d_t%t_s%s_p%p' CURRENT CONTROLFILE FORMAT '/nfsbup/PDB_00000169/%d_C_%T_%u' SPFILE FORMAT '/nfsbup/PDB_00000169/%d_S_%T_%u' plus archivelog FORMAT '/nfsbup/PDB_00000169/%d_A_%T_%u_s%s_p%p';
DELETE FORCE NOPROMPT ARCHIVELOG ALL BACKED UP 1 TIMES TO DISK COMPLETED BEFORE 'SYSDATE - 1';
DELETE FORCE NOPROMPT OBSOLETE;
BACKUP CURRENT CONTROLFILE FORMAT '/nfsbup/PDB_00000169/%d_C_%T_%u' SPFILE FORMAT '/nfsbup/PDB_00000169/%d_S_%T_%u';
}
I have to migrate to a new database server; full backup is about 6 TB, so I was planning to restore the full backup and restore incremental backups every time they are created.
I am restoring the full backup using its control file backed-up; when I need to restore the incremental backups, do I need to restore the latest control file or just catalog latest backup files and do a “recover database” ?