Re: Hot Backups

In article <3mvatq$bmt_at_ionews.ionet.net>, lmcgilvi_at_ionet.net (Laurel McGilvery) says:
>
>We are currently backing up a 30 gig database to optical disk drives
>using a combination of hot and cold backups. Has anyone out there run
>hot backups backing up more than one tablespace at a time? I know the
>book recommends against it. Just curious what would happen. I don't
>propose testing it on a production system. Our main issue is the backup
>software is NOT as flexible as one would like. Unfortunately, I have to
>use it to access the optical drives.
>
>Thanks.
>
>- Laurel
>

At my previous employer, our hot backup script went as follows:

1. Get a list of all archive log files
2. Place all tablespaces in the production database in backup mode
3. Issue command to make a backup copy of one of the control files
4. Issue system backup command (in our case it was cpio). This copied all the tablespaces to tape.
5. Place all tablespaces in non-backup mode
6. Remove all archive log files in list from #1. This leaves new ones created during the backup on disk.

NOTE: This V 6.0.32 on SCO Unix. We also did an export of the user data tables. This was a small database (< 1 gig). Received on Tue Apr 18 1995 - 00:00:00 CEST