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

------------------------------------------------------------------------
[email protected] 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 Haskett<[email protected]>  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
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to