RMAN Backup Using Netbackup reports images are expired

[Navadeepan_Pill]

Hi Gurus,

We take Oracle database backup using RMAN and Netbackup. When we check the backup images using bplist commands, netbackup shows it is available.

But when we use RMAN command , here is the output

RMAN> CROSSCHECK BACKUP OF DATABASE;

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=HOT_ORAP_T20051108_s162_p1 recid=116 stamp=573829995

It is the latest Backup image.

Can anyone help me.

[patrickkuah]

HI,

crosscheck will mark backup image as expired if they cant find the image. Try to restore the backup from tape back to the original location which the image located and rerun the crosscheck command again, it should revert back to available if it able to find the image.

patrick :)

[Navadeepan_Pill]

Hi ,

The tapes are available in the Library. When we issue crosscheck backup , it shows only the latest backup set as available and all other backups are maked expired.

We have tried taking 3 backups on the same day. After this , when we check crosscheckbackup, it shows the latest backup as available and all other backups are expired.

I am attaching the error messages

RMAN> CROSSCHECK BACKUP OF DATABASE;

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=HOT_ORAP_T20051108_s162_p1 recid=116 stamp=573829995

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=HOT_ORAP_T20051108_s163_p1 recid=117 stamp=573829995

Best Regards
Navadeepan

[patrickkuah]

Hi,

What your retention period?? is the tape being overwritten??

patrickkuah

[Navadeepan_Pill]

Hi,

The retention period is one week.

The crosscheck backup shows the images that were taken today as expired.

as i mentioned, only the latest backup is shows as available.

When we take 2 backups today, use crosscheck backup command, it will show the latest backup taken today as available and the second latest taken today as expired.

Best Regards
Navadeepan