Database Backup and Recovery (MOSC)

MOSC Banner

RESTORE ARCHIVELOG - RMAN-06025: no backup of archived log for thread 1 with sequence 40 and startin

edited Sep 17, 2020 9:07AM in Database Backup and Recovery (MOSC) 7 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.

This works fine.

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