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 <[EMAIL PROTECTED]>
>Reply-To: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>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
>[EMAIL PROTECTED]
>
>
> >>> [EMAIL PROTECTED] 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
