On Sun, Sep 10, 2006 at 11:47:57PM +0700, Wira Chinwong wrote:

> perform daily backup. But I don't have an idea to setup monthly & yearly
> backup policy. The expiration on daily & monthly & yearly are conflicted.
> Anybody who have an experience please advise.

You shouldn't use TSM expiration parameters like Versions Exists, Versions
Deleted, etc. Those settings should be configured according to the TDP
installation manual.

You must use RMAN to configure your database backup retention policy. You
can do this using the RMAN CONFIGURE command, and you can always use the
KEEP option for individual backups. See the RMAN documentation for this,
it's not complicated.

--
Jurjen Oskam

Savage's Law of Expediency:
        You want it bad, you'll get it bad.