Karen,

Solaris 2.5.1/ADSM 2.6

I have the db and log mirror on one controller/device
and db mirror and log on another controller/device.

I do not use rollforward mode on the log, and I've not implemented DSM (yet).

I do a full backup the db to a 4mm DAT tape every day using
the following command:

backup db type=full dev=hp4mm scratch=no vol=<next available volume>

I have a set of 21 tapes for this purpose.  The tapes are labled with
the dsmlabel utility.  I send one tape offsite each day and get the
seven oldest tapes back on Monday morning.  When the tapes come back,
I delete their volume history records with the following command:

del volhist type=dbbackup todate=<date of most recent tape in set + one day>

The database backup volumes do not appear to be managed by ADSM except for the
records on the volume history.

Karen Krowzack writes:
> As a soon-to-be in production ADSM site, I have had a concern expressed to
> me about the backup of the ADSM database.  Since the ADSM database is so
> critical to the proper functioning of ADSM, what are the best steps taken to
> ensure that it can be restored in case of a problem? To date, we are doing
> the following:
>
> 1)  Mirroring the db and recovery log
> 2)  Backup the db to a file on disk on the ADSM server every day.
>
> Eventually, we also plan to copy the db file to a tape or onto another ADSM
> server.  At what age does that db backup become useless (24 hours, 1 day, 3
> days???)
>
> Any other ideas on how to take the best care of the database and recovery
> log?  If the database is truly lost, can the tapes in the ADSM library be
> re-read to re-build the database?
>
> Thank you for your ideas and comments.
>
> Karen Krowzack
> IBM Global Services
> Tieline 461, x7309
> Outside phone - 312-394-7309
> Pager:  800-759-8888, PIN 1967096
> email:  Karen.M.Krowzack AT ucm DOT com
>


--
Jon Vander Hill, N8PAP
Jon Vander Hill, N8PAP
Senior Systems Engineer        Email: vanderhill AT berbee DOT com
Berbee Information Networks    URL:   http://www.mailbag.com/users/vanderhill
5220 Research Park Drive       Voice: (608) 288-3000 x1606
Madison, WI 53711-5377         Fax:   (608) 288-3007