Database Backup and Recovery (MOSC)

MOSC Banner

Deleting the backed up archive logs / control files / spfiles that are out of date

edited Sep 23, 2020 8:48AM in Database Backup and Recovery (MOSC) 9 commentsAnswered

Hello,

I am using "Oracle Database 19c" under Windows 2019 Server (Hyper-V VM).

Every day I made a backup of the entire OS (incl. Oracle Database) via windows server backup, the OracleVSS writer is triggered.

Every hour I made a Backup of the Archive Logs with

C:\oracle19\product\19.3.0\dbhome_1\bin\rman TARGET sys/xxx@oraxxx NOCATALOG cmdfile="C:\BackupOracle\dbrman.cmd" log="C:\BackupOracle\dbrman.log"

"dbrman.cmd" contains

run

{

sql 'alter system archive log current';

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

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