There is not a UniData backup utility like UniVerse does. Every site that I have been involved with uses o/s level backups.
There is a need to quiesce the database before breaking the mirror for backups. dbpause will force all writes to disk and will inhibit writes to the datafiles in the database, with a few exceptions (writes to the _HOLD_, _PH_) and will not interrupt report printing. Once the dbpause is executed, the mirror is broken, and the database is resumed with dbresume. This can be scripted so as to minimize the actual down time. For a very large installation (>1800 users, very active system) this time is in the neighborhood of 1-4 minutes, depending on disk activity, and how much data needs to be flushed to disk. Please contact me off line if you would like to discuss further. Regards, Robert --- Regards, Robert -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, May 17, 2006 10:42 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Backup Question Does unidata have a backup utility at all, or are all backups done at the os level? Unidata DOES have journaling. I don't know how much overhead that adds to the system, but it could be worth looking into. If you go the mirroring route, you would still have to stop the database before breaking the mirror to ensure the integrity of what you are backing up on the mirror, so it seems there would still be down-time required. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Wednesday, May 17, 2006 9:53 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Backup Question > > > [EMAIL PROTECTED] wrote: > > Hello all, > > > > > > > > I have a client that only does backup once a week. I feel > this is a > > dangerous situation and would like to suggest they look for an > > alternative. I believe that they could mirror the live system, stop > > the mirror, backup this copy and then restart and resync the mirror. > > The problem with this approach is that UV does not update the > headers that much. Dunno about UD. So if they ever DID need > to recover, you might find yourself in a world of hurt with > uvfixfile over this ... > > > What I don't know, and > > would like a little more information on before I approach them with > > the idea, is now these steps are done. Or, if anyone has a better > > solution to a shop that has to be up 24/7 I am willing to listen, I > > just hope they are. > > > The safest UV backup is always one that uses the native UV > facilities... there's something called UVBackup :-) > > > > They are running SunOS 5.8. They have just hired a new Unix > > Administrator, right out of college, and I don't know if he is > > understands the problem. That is why I would like to > suggest the steps > > that he looks into, just to get the ball rolling. > > > Doesn't understand the importance of backing up, or doesn't > understand the importance / problems of backing up U2? > > What you probably want to do is use uvbackup to automatically > dump the database every time the system is likely to be quiet > - you can run that while people are logged on - it's not a > problem. That simply dumps all the accounts into a text dump > file that you can back up onto tape or whatever later. And > there are no file integrity problems. > > If you go down the mirror route (and yes, that is a good > idea, but there's no need to do it that often if you're > uvbackup'ing), then I think there's a dbpause command that > will sync files and stop any disk i/o. Pause the db (doesn't > stop users using it), break the mirror, resume the db, backup > the mirror, resume the mirror. > > If you've got both types of backup you should be reasonably secure. > > If he doesn't understand the importance of using UV-aware > backup tools, just ask him if he has any experience of > backing up Windows - and how often do his backups there screw > up because Windows has a file open? Although Unix will quite > happily let him back up an open UV file, because it's open > it's internally inconsistent on disk, and a disk backup tool > won't get a clean backup! > > Cheers, > Wol > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.1.392 / Virus Database: 268.6.0/341 - Release > Date: 5/16/2006 > > -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.6.0/341 - Release Date: 5/16/2006 ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
