I also vote for archives. Archives are designed to keep a set of related
files together.   You do not want any type of versioning to occur when doing
a file level / os level backup of your database files.

James Thompson

From: David Longo <David.Longo AT HEALTH-FIRST DOT ORG>
Reply-To: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: backing up DBs from filesystems
Date: Thu, 31 May 2001 09:17:23 -0400

One question pops up to consider in the planning.  Do the files they put in
the staging area have a unique filename each day or will it be the same
filename each day?


David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH      321.434.5536
Pager  321.634.8230
Fax:    321.434.5525
david.longo AT health-first DOT org


>>> suad AT CCU1.AUCKLAND.AC DOT NZ 05/31/01 08:58AM >>>
We are about to start backing up our enterprise databases.
They are comprised of about 15 Oracle instances ranging from 7GB to 25GB.
About a third are being backed up nightly and the others are either 1 or 2
times
weekly.

On the server side, we will set up a seperate stgpool hierarchy as they
there
will be expectations for QOS etc. (I will seperate them out onto a 2nd
server
later this year)

There are no TDPs available (Dynix) so we have to use the command line
client
to backup. The DBAs run the database in backup mode and cpio the files to
a staging area, then the TSM client will scoop them up.

They want a 30day retention period with one backup a month kept for a year
(acheived
by a management class flag on dsmc)

Question:
Should we run incrementals or archive the files considering we have a date,
as
opposed to frequency, retention requirement?

Suad
--



"MMS <health-first.org>" made the following
 annotations on 05/31/01 09:19:45
------------------------------------------------------------------------------
This message is for the named person's use only.  It may contain
confidential, proprietary, or legally privileged information.  No
confidentiality or privilege is waived or lost by any mistransmission.  If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it, and notify
the sender.  You must not, directly or indirectly, use, disclose,
distribute, print, or copy any part of this message if you are not the
intended recipient.  Health First reserves the right to monitor all e-mail
communications through its networks.  Any views or opinions expressed in
this message are solely those of the individual sender, except (1) where
the message states such views or opinions are on behalf of a particular
entity;  and (2) the sender is authorized by the entity to give such views
or opinions.

==============================================================================

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com