Hi, RMAN reports latest backup pieces as expired, I have configured the retention policy as follows:
RMAN>configure retention policy to recovery window of 30 days.
I take weekly full backup of database including archivelogs using rman. On month end I delete the archive logs from rman by giving the command to remove the previous one month old archivelogs from the disk.
Hi, I take backup on both disk and tape. The backup on disk is deleted by giving solaris operating system command (rm *) in the backup directory. The deletion is done weekly before taking full rman backup.
Iam maintaining 4 tapes to maintain one month rman backup. I delete the backup sets on disk due to less space. I can keep only 1 week backup set on my disk.
But why RMAN is showing the backup files as Expired now. Previously everything was ok. I used to follow the same procedure, like deleting the backup files from the disk using OS command and then taking full Rman backup, everything was ok.
CROSSCHECK command updates the repository status for a backup to EXPIRED when it cannot locate it at the location to which it was backed up.
This condition could occur if,
for example, a backup was deleted from disk at the operating system level
I suggest you either
Restore the backups from tape to the same loaction where you had backed up the database
and then run crosscheck command again this would make the backups available and you can verify with
list backup of database
if you dont want these backups then you can run the delete expired backups to delete these entries from rman catalog