Originally posted by samdba
...
Thanks for the link. I am going to use foll. commands.
allocate channel for maintenance type disk;
crosscheck backup of database;
crosscheck backup of archivelog all;
delete expired backup;
release channel;
exit
As I understand, delete expired backup will delete catalog records for the backup piece it does not find on the backup location. In our case, we first take the backup on the disk and then on to the tape. After that, we delete backup from the disk. In that case, it will not find backup on the disk and will delete catalog records.
Will it not create problem in case if we need to restore that backup piece?
...
That is correct sam. You will not be able to restore that backup piece since the crosscheck will not find it in the backup location.
To use that backup piece, you would need to restore the catalog database to the point in time after the backups were taken but prior to the crosscheck that expired them.
alapps
Fast, Cheap, Reliable... Pick Two(2)