Re: RMAN crosscheck problem

Have you tried the DELETE OBSOLETE commands or one of it's variations? Here is what I found in the RMAN docs at http://www.stanford.edu/dept/itss/docs/oracle/9i/server.920/a96566/rcmquery.htm:

"Optionally, delete those backups that are obsolete. You can automatically delete obsolete backups and copies by issuing the DELETE OBSOLETE command. For example, you can enter: # delete obsolete backups and copies displayed when you issue REPORT OBSOLETE
DELETE OBSOLETE;
# delete obsolete backups and copies according to a specified recovery window
DELETE OBSOLETE RECOVERY WINDOW OF 7 DAYS; # delete obsolete backups and copies according to a specified redundancy
DELETE OBSOLETE REDUNDANCY = 2; Note that RMAN prompts you for confirmation before actually deleting the files. To suppress the prompt, specify the NOPROMPT option of the DELETE command. Specify FORCE to delete the files and remove their repository records regardless of whether the files exist. RMAN ignores any I/O errors for the deleted objects."

Chuck wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Can someone explain to me what's going on here? I recently queried my
> RMAN catalog and found a lot of old backups, much older than the
> configured retention period of 30 days. I run a "delete obsolete" once a
> week so I was surprised to find things well over a year old on the
> catalog. If I run "crosscheck backup" it doesn't even find any of the
> old backup sets, but if a do a "crosscheck backupset <bs_key>" (i.e.
> specify the backup set ID's manually) for the backups in question, it
> finds them and marks them as expired. Why doesn't the "crosscheck
> backup" find these old backups? The databases in question have only ever
> had one incarnation.
>
> RMAN and database versions are both 9.2.0.5. The catalog version is 10.1.0.
>
> TIA
>
> - --
> To reply by email remove "_nospam"
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.0 (MingW32)
>
> iEYEARECAAYFAkMm1uAACgkQzIf+rZpn0oTvcwCdENalM6s2KCifedlStjJE2z1Y
> bFIAnR/tFCw+JDAGCMaU9iDzUnmnjIP3
> =M9aP
> -----END PGP SIGNATURE-----
Received on Tue Sep 13 2005 - 10:05:12 CDT