Hi Jurjen,
   As your suggestion, currently instead rman database, I'm using
controlfile to keep the catalog. Can I still follow by your recommendation?

Best Regards,

Wira Chinwong

Engineering Service Manager
Enterprise Division

SCSI Co., Ltd.
976/22 Rimklongsamsen Rd., Bangkapi,
Huaykwang, Bangkok 10320
Tel. 66 (2) 641 4003-4
Fax. 66 (2) 641 4002
E-mail: wira AT scsi.co DOT th



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Jurjen Oskam
Sent: Monday, September 11, 2006 3:04 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] TDP for Oracle

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.