Database Backup and Recovery (MOSC)

MOSC Banner

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';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center