Database Backup and Recovery (MOSC)

MOSC Banner

Missing RMAN backup information

Hi team,

I have strange situation. We are using CommVault software for taking incremental backups in our environment. I was able to go back and list first backup that was taken during December last year. Now when i list backups i can go back till April, but dates before are missing.

I use this query to list RMAN backups in our 12.1 database:


select SESSION_KEY, INPUT_TYPE, STATUS,

to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,

to_char(END_TIME,'mm/dd/yy hh24:mi') end_time,

elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS

order by start_time desc;

Tagged:

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