It is advised to use V$RMAN_BACKUP_JOB_DETAILS to identify status of backup jobs. But it is difficult to understand when it was taken full backup of Oracle DB due to in the INPUT_TYPE of the output you can find "DB INCR" value as for FULL Incremental level 0 backups as for Incremental level 1 backups.
You can find way to clarify incremental levels or to find out when was taken FULL backup with the V$BACKUP_SET_DETAILS view.
For instance,
select * from V$BACKUP_SET_DETAILS where BACKUP_TYPE='I' and INCREMENTAL_LEVEL='0'
You can find way to clarify incremental levels or to find out when was taken FULL backup with the V$BACKUP_SET_DETAILS view.
For instance,
select * from V$BACKUP_SET_DETAILS where BACKUP_TYPE='I' and INCREMENTAL_LEVEL='0'
No comments:
Post a Comment