Yep... most data center customers I've worked with prefer to do online full
backups during the week, then weekly and monthly offline/cold backups...
using "dsmc archive /Ora_instanceX/* -archmc=xyz -su=y".  Using archive
makes it very easy to do just what the customer wants:  weekly (and/or
monthly) cold-snapshot of the db, retained just for the desired amount of
time (as specified in the MC)... archive simply runs the list of files
specified -- no comparing of last-change attributes, etc.  The one
difference you should note is that an archive client schedule will be marked
as "failed" if any files must be skipped; whereas backup is not.


Don France
Technical Architect -- Tivoli Certified Consultant
Tivoli Storage Manager, WinNT/2K, AIX/Unix, OS/390
San Jose, Ca
(408) 257-3037
mailto:don_france AT att DOT net

Professional Association of Contract Employees
(P.A.C.E. -- www.pacepros.com)



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Mark Stapleton
Sent: Tuesday, October 29, 2002 10:19 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: monthly backup


From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> a client of ours wishes to have a monthly full-backup of their databases.
> My question is , is archiving a good altenative? and how do i set it up?
> (never used archiving options before)

Are you using the regular backup/archive client? If so, yes, that is the
preferred method for you're after. The command is

        dsmc arch <drive:>/<directory>/*.dbf -subdir=yes

Read up in the backup client documentation on proper setup.

If you're using a TDP agent, you can't archive with that software.

--
Mark Stapleton (stapleton AT berbee DOT com)
Certified TSM consultant
Certified AIX system engineer
MCSE