Re: Veritas Netbackup users

On 8/3/06, Fred Smith <fred_fred_1@xxxxxxxxxxx> wrote:


If you backup <1 database on the master server and <1 databases on a client server, how do you configure it? Do you run a separate policy for each server OR a separate policy for each database? (Or do you combine the jobs into 1 policy?)



How you configure will likely be affected by your environment:

* number of servers
* number of databases per server

I'm going to assume that you use RMAN.

We use RMAN for all but 2 databases. Those are 7.3 databases that will
soon be upgraded to 10g.

We have an RMAN repository, but I am phasing it out.  I haven't seen there's
all that much benefit to having one.

Not that this bit matters all that much as far as configuration goes, but
that's
how we are setup.

As far as policies for databases (Oracle specifically, we also have SQL
Server)
a database may be several different policies.

Say for example you have a server s1 with three databases on it: d1, d2 and
d3.

All databases are in archive log mode.

General methods:

Archive logs are backed up once per day and left on disk.

Production databases are backed up once per day (night time), and archive
logs are backed up and deleted.  This puts some/most archive logs
on tape twice.  I haven't found a way (built in anyway) with RMAN
to ensure that a archive log is put on tape twice before being deleted.
(Ideas on this one?)

Development and low-activity databases may be backed up only
once a week.

Occasionally a database is generating a lot more redo than normal,
and a job must be run to backup the arch logs and delete them
immediately.

Some db's are subject to SarbOx standards, and must be backed up
quarterly with a near infinite retention time.

Database d1 and d2 are not subject to SarbOx.

Database d3 is subject to SarbOx.

Policies:

Polocies are named for server, database, and method.
Method and database are optional components, but at
least one of them must be used.

ORA_s1_weekly
  d1 and d2 full database backup
  retention time is 2 weeks
  This backup is scheduled

ORA_s1_archive
  d1, d2 and d3 archive logs backed up and left on disk
  retention time is 2 weeks
  This backup is scheduled

ORA_s1_arch_delete
  d1, d2 and d3 archive logs backed up and removed from disk
  retention time is 2 weeks
  This backup is not scheduled  - must be run manually

  There may also be indiviual policies per database.
  eg.  ORA_s1_d1_arch_delete, ORA_s1_d2_arch_delete, ...

ORA_s1_weekly
 d1 and d2 databases are backed up weekly.
 archive logs are backed up and removed
 retention time is 2 weeks.
 This backup is scheduled.

ORA_s1_d3
 d3 database is backed up
 archive logs are backed up and removed
 retention time is 2 weeks.
 This backup is scheduled.

ORA_s1_d3_quarterly
 d3 database is backed up
 archive logs are backed up and removed
 retention time is a long time (7 years IIRC)
 This backup is scheduled.

HTH


-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: