Re: Configuring Veritas Netbackup Oracle Application Backup with Different Levels of Retention Period

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
Received on Mon Jul 17 2006 - 23:26:09 CDT