Recover Database and ArchiveLogs from VSS-Writer Backup
Recover Database and ArchiveLogs from VSS-Writer Backup
I am test Oracle Enterprise 19.7.0.0 on Windows Server 2019.
Once a day I create a full backup with the Oracle VSS Writer.
The database runs in ArchiveLog mode.
Every hour I take a backup from the ArchiveLogs with the following RMAN script:
run
{
backup archivelog all format '\\BackupOracle\arch\%d_%s_%p_%c_%t.arc.rman' delete all input;
backup current controlfile FORMAT '\\BackupOracle\ctl\%d_%s_%p_%c_%t.ctl.rman';
backup spfile FORMAT '\\BackupOracle\spfile\%d_%s_%p_%c_%t.spfile.rman';
DELETE NOPROMPT BACKUP OF ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';