ADSM-L

Re: backing up DBs from filesystems

2001-06-01 21:39:29
Subject: Re: backing up DBs from filesystems
From: Suad Musovich <suad AT CCU1.AUCKLAND.AC DOT NZ>
Date: Sat, 2 Jun 2001 13:40:22 +1200
For the archive option I was going to set date specific directories
(e.g. /staging/2001/06/02/) rather than unique filenames.

Cheers, Suad
--
On Thu, May 31, 2001 at 09:17:23AM -0400, David Longo wrote:
On Thu, May 31, 2001 at 09:17:23AM -0400, David Longo wrote:
> 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.
>
> ==============================================================================
<Prev in Thread] Current Thread [Next in Thread>
  • Re: backing up DBs from filesystems, Suad Musovich <=