Database Backup and Recovery (MOSC)

MOSC Banner

Rman recover issue

edited Dec 3, 2019 5:24AM in Database Backup and Recovery (MOSC) 4 commentsAnswered

Hi ,

We're restoring a backup from prod to test machine, it fails as in the attached logs, please let us know how to proceed further

This our L0 backup script,

RMAN> run{

2> Crosscheck Archivelog All;

3> report obsolete;

4> delete obsolete;

5> Backup incremental level=0  tag='Weekly_Full_database' filesperset 20 format "F:\RMAN\backups\backupset\Weekly_%T_L0_%d-%s_%p.db" database include current controlfile;

6> Sql 'alter system archive log current';

7> BACKUP ARCHIVELOG ALL format "F:\RMAN\backups\backupset\ARCH_%T_%d-%s_%p.arc" DELETE INPUT;

8> DELETE BACKUP OF ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';

9> }

Thanks.

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