Hello,
We have a database with more than 5 years of backup (with one backup per day).
Regularly, some backups are deleted from the netbackup server (and archived elsewhere).
For duplicates and other operations, we need to crosscheck all the backup so we're sure the duplicate does not try to use expired or unavailable backup but it takes an enormous amount of time.
What we would like to do is crosscheck only backups that are available (and ignore those which are already expired or unavailable).
Is there an easy way to do that? I could not find anything on the net.
What we want to do is:
- List all backup via rman, spool it to a file, grep the available and generate a crosscheck command with those
or
- query the rman catalog and generate a crosscheck command.
Do you have another idea? Have you been cronfronted with the same issue?
Thanks in advance for your answers.
Regards,