We don't mirror but we use filesystem snapshotting for a clean backup with less than 10 seconds of downtime:
Dbpause Sleep few (3-5) seconds File system snapshot (5 seconds or so) Dbresume Backup from snapshot Trash snapshot Only cost in this is enough disk for snapshot. Jeff Butera Sent from my iPhone On Aug 20, 2011, at 1:51 PM, Bill Haskett <wphask...@advantos.net> wrote: > That's what I like... > > "As others have mentioned, you can pause the database. If you've got a mirror > then DBPAUSE the database, break the mirror, and DBRESUME. " > > Sounds so simple yet can be so complex and expensive. There are so many > "ifs" with the term "break the mirror" it's not much of a wonder that most > small businesses never go down that path; as much as we'd all like to! :-) > > Wouldn't it be nice if we had a simple white-paper describing this > functionality so the next batch of inexpensive servers we bought we could > accomplish this. Presently I have to shut down the database and keep it > shutdown for the 30-60 minutes the backup runs. :-( Jeeze, we have simple > Windows backup scripts we've shared and would always share; you'd think U2 > would have this down pat and distributed onto their site or to the wiki. Oh > well, should anyone figure out a simple, effective and inexpensive way to do > this sort of thing, please post it. > > Bill > > ------------------------------------------------------------------------ > Wols Lists wrote: >> On 18/08/11 05:07, Chris Lee wrote: >>> Hi All, >>> >>> We're running UniVerse 10.1.17 on AIX 5.3 and the backup feature >>> included within our vendors software is pretty basic and only allows >>> backups of Universe to tape. >>> >>> [snipped] >> [snipped] >> As others have mentioned, you can pause the database. If you've got a >> mirror then DBPAUSE the database, break the mirror, and DBRESUME. >> >> [snipped] >> >> Cheers, >> Wol > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
