Hi JH,

Maybe i the explanation of my problem below clarify things:

I am trying to configure veritas netbackup oracle application backup to
backup my oracle database.
With the help of my DBA, i am able to successfully backup the database
using RMAN script via my veritas policy.

However, when i check on my tapes retention period, they are of the
same be it weekly full or daily incremental backup policy. When i
further investigate the cause of this, i discover that it is actually
the tape retention period was taken from my "application backup"
schedule(create default by veritas) instead of my "automatic backup"
schedule.

I tried to create multiple "application backup" schedules and
differentiate the schedules by different start time windows(i can't use
"calender day" to differentiate weekdays or weekends like "automatic
backup" schedule). That means monday to saturday start windows for
daily incremental and sunday start window for weekly full backup.
However, weekly full and monthly full backup has which happens on the
same day, sunday(monthly is 1st sunday of the month) will have the same
retention period.

May i know how can i solve my above retention periods problem.

My backup policy is based on daily incremental(2 weeks retention),
weekly full(1month retention), monthly full(12 months retention) and
yearly full(7 years retention).

May i know how do create the above retention periods on my schedule so
that i can have my desired retention periods?

Hope you can share your experiences with me.

regards,
Yam

Jining Han wrote:
> yam wrote:
> > Hi,
> >
> > I am trying to configure veritas netbackup oracle application backup to
> > backup my oracle database running on my DB server.
> > With the help of my DBA, i am able to successfully backup the datbase
> > using RMAN script. My backup policy is based on daily incremental,
> > weekly full, monthly full and yearly full.
> >
> > May i know how do create the above retention periods on my schedule
> > with backup type "application-backup"?
> >
> > Thanks in advance for your time.
> >
> > regards,
> > yam
>
> I am not sure if I understand your question correctly, but here is
> what I think to be the case:
>
> There are two possible places where you specify the retention:
>
> 1) RMAN catalog (assuming you are using one)
> 2) Netbackup CLASS/Policy
>
> If you don't do anything about 1), chances are all your backup
> information will be stored in the catalog forever, therefore giving you
> infinite catalog retention. However, if your netbackup retention is
> only two weeks, then having infinite retention for catalog information
> is probably no good.
>
> At the Veritas/Netbackup level, you can create one or multiple
> policies/classes with different retention specifications. Then in
> your RMAN script, you can specify which NB_ORA_CLASS to use for the
> backup.
>
> JH