Originally posted by samdba
Hi alapps,

I am sorry but I could not understand clearly what you are trying to say.

Once, I issue 'DELETE EXPIRED...' command, it will delete all records from catalog repository where it finds 'expired' backup copies.

So, if I need to perform the restore and that backup piece is not available on the disk (but there on the tape) and its records have been deleted from the catalog database, will I be able to perform 'restore' using that backup copy or not?

Pl. explain.

Thanks,
Senario:
- ... (Pre existing backups)
- Backup level 0 on February 01
- Backup level 1 on February 02
- Backup level 1 on February 03
- Backup level 1 on February 04
- Backup level 1 on February 05
- Backup level 1 on February 06
- export rman catalog DB
- delete older than 14 days
- crosscheck
- ... (1 month goes by)


To restore to February 03, you would need to get the level 0 from February 01 and the level 1's for February 02/03. However, the rman catalog has been cleared via the crosscheck. The catalog would need to be imported from the export rman catalog DB step. This usually occurs when setting up a test environment from a production environment.

As Jodie said, use scripts to maintain the catalog manually since you are storing your backups on tape.