Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

HOW TO DELETE OBSOLETE BACKUP ON TAPE WHEN USING FLASHBACK? RMAN-06091

Laurent SchneiderFeb 16 2005 — edited Feb 17 2005

Hi,
Flashback is taking care of deleting the obsolete OMF on disk. That is, if you do NOT specify log_archive_dest_1 nor autobackup format, all your files in the recovery area will be deleted when obsolete regarding retention and size.

However, my question is, how would you then delete obsolete backups on tape?

RMAN> delete obsolete device type 'sbt_tape';

does not work in 10.1.0 (it is supposed to work in 10.2.0).

How can you figure out which backups are obsolete and where they are?

Thanks
Laurent

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 17 2005

Added on Feb 16 2005

#performance-availability, #recovery-manager-rman

7 comments

2,087 views