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@;att.net Professional Association of Contract Employees (P.A.C.E. -- www.pacepros.com) -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@;VM.MARIST.EDU]On Behalf Of Mark Stapleton Sent: Tuesday, October 29, 2002 10:19 AM To: [EMAIL PROTECTED] Subject: Re: monthly backup From: ADSM: Dist Stor Manager [mailto:ADSM-L@;VM.MARIST.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 ([EMAIL PROTECTED]) Certified TSM consultant Certified AIX system engineer MCSE
