Re: [U2] UniVerse backups to disk
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
Re: [U2] UniVerse backups to disk
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
Re: [U2] UniVerse backups to disk
Jeff: Am I mistaken to assume this is for Linux (or other variant)? See, things aren't anywhere near as easy as they seem. :-) Bill jbut...@hampshire.edu wrote: 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 Haskettwphask...@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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse backups to disk
Yes this is on Linux (we don't touch windows here). Same approach works on solaris and other *nix but I'm betting someone who knows windows better than I could also make it work. Jeff Butera Sent from my iPhone On Aug 20, 2011, at 6:56 PM, Bill Haskett wphask...@advantos.net wrote: Jeff: Am I mistaken to assume this is for Linux (or other variant)? See, things aren't anywhere near as easy as they seem. :-) Bill jbut...@hampshire.edu wrote: 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 Haskettwphask...@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 ___ 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
