Database Utilities (MOSC)

MOSC Banner

Are Backup files good or not

edited Apr 4, 2014 11:47AM in Database Utilities (MOSC) 5 commentsAnswered ✓

Hi,

on 10g R2 on Win 2003

I backup my DB using control files (nocatalog).

How can I verify that my backup files are good ? Of cours in Rman log there is no error.

In documentation the following is to verify the data files but not the backup files :

RMAN> BACKUP VALIDATE DATABASE ARCHIVELOG ALL;

In V$BACKUP table I have the following for all :

   FILE# STATUS            CHANGE# TIME   

---------- ------------------ ---------- --------

     1 NOT ACTIVE              0   
     2 NOT ACTIVE              0   
     3 NOT ACTIVE              0   
     4 NOT ACTIVE              0

Thank you.

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