Re: [U2] UniVerse backups to disk

2011-08-23 Thread Wols Lists
On 22/08/11 14:56, Robert Porter wrote: The snapshot disk space only needs to hold the amount of the changed data - not the whole filesystem. To the applications, it appears that a copy was made, but actually writes are being held behind the scenes. Don't think I'm explaining this well

Re: [U2] UniVerse backups to disk

2011-08-23 Thread Robert Porter
Snapshotting doesn't get rid of mirroring just the need to break/merge them. I'd still suggest using mirrors. The risk of disk failure is too great. Guess you could use some other level of RAID to get there but it's hard to beat spindles plus mirrors (0+1) for databases. In fact our snapshot

Re: [U2] UniVerse backups to disk

2011-08-23 Thread John Thompson
Here is some Pie in the Sky info for ya... btrfs or Butter FS is being developed by Oracle for Linux. Its one of the reasons Oracle shutdown the development of ZFS when they bought Sun. (ZFS has many of those snapshotting features you are talking about). So now you have all of these spinoffs

Re: [U2] UniVerse backups to disk

2011-08-23 Thread John Thompson
On a relevant note. I was always told that: The best way to get an accurate backup on U2 is to: -Pause the writes -Do a logical volume snapshot (*nix only) -Resume the writes -Let the logical volume snapshot finish copying off to your backup space to disk. -On top of that you should still do a

Re: [U2] UniVerse backups to disk

2011-08-22 Thread Carl Dula
take a look at http://www.pulsarsystems.com/uvback.html -- Carl Dula Voice: 973-227-8440 X111 Pulsar Systems, Inc.Fax: 973-227-8440 271 US Highway 46, STE H209 email:c...@pulsarsystems.com

Re: [U2] UniVerse backups to disk

2011-08-22 Thread Robert Porter
People are still splitting mirrors? From what I can see AIX 5.2 (Oct 2002!) added JFS and snapshots. Removes the risk of a mirror getting merged back the wrong way if the break-backup-merge crashes and has to be undone by hand. Breaking the mirror means either you need to have multiple mirror

Re: [U2] UniVerse backups to disk

2011-08-22 Thread Robert Porter
The snapshot disk space only needs to hold the amount of the changed data - not the whole filesystem. To the applications, it appears that a copy was made, but actually writes are being held behind the scenes. Don't think I'm explaining this well (Monday am), so lets try an example. Say that

Re: [U2] UniVerse backups to disk

2011-08-20 Thread Bill Haskett
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

Re: [U2] UniVerse backups to disk

2011-08-20 Thread jbut...@hampshire.edu
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

Re: [U2] UniVerse backups to disk

2011-08-20 Thread Bill Haskett
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

Re: [U2] UniVerse backups to disk

2011-08-20 Thread jbut...@hampshire.edu
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:

Re: [U2] UniVerse backups to disk

2011-08-19 Thread Wols Lists
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. I'm going to continue running backups to tape on a nightly basis, but I'd also

Re: [U2] UniVerse backups to disk

2011-08-18 Thread Gregor Scott
Chris, add the options -notag -limit 1 to your command line. The -notag stops UV from updating the header of each record after it is included in the backup. The -limit 1 stops uvbackup from trying to use the shared-memory feature, which can severely impact the performance. The uvbackup

Re: [U2] UniVerse backups to disk

2011-08-18 Thread DavidJMurray (mvdbs.com)
Chris Lee-17 wrote: What's the best way to achieve this, is it necessary to use UniVerse's built-in uvbackup utility ? In the past for a small client who had a overnight 'dead' period, I used a simple windows script (UniVerse on MS-Windows) to backup using uvbackup to a scratch disk,

Re: [U2] UniVerse backups to disk

2011-08-18 Thread John Hester
I do an additional archival backup with cp at the linux OS level before and after our month-end batch processing since that's the data we typically have to refer back to. I bought a 4TB iomega NAS appliance that was relatively inexpensive just for this purpose. The archive share is NFS mounted