Re: [U2] Question about uvbackup dd and uvrestore
Hi, Do a Backup of universe on snapshot ; to perform a binary backup. Yes, if you don't use Type30 / dynamic files because while a T30 file is open, some header file's information stays in memory. You must close the T30 files (all users) to be sure the header is flushed. I prefer using uvbackup. To avoid the 2gb limit, I prepare files-list to uvbackup and run multiple uvbackup -cmdfil . For uvfiles which are greather than 2gb himself, I use Distribution (DEFINE.DF) then I manage only files smaller than 2gb (a easy solution to make resizing administration regarding administation of 64bit nGb files). My 2 pence. manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de bpa...@serta.com Envoyé : vendredi 15 avril 2011 23:39 À : u2-users@listserver.u2ug.org Objet : Re: [U2] Question about uvbackup dd and uvrestore The product provided by Ashwood handles this nicely. On an AIX system, it pauses the database, performs a JFS2 snapshot (in seconds), releases the database, then the customizable backup script (we use tar and gzip) backs up the snapshot. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Friday, April 15, 2011 12:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Question about uvbackup dd and uvrestore On 15/04/11 13:30, Rex Gozar wrote: Unless you need record-level restores, I would recommend using tar to backup your Universe accounts. While UV is running and being used? tar is all very well, but if the database is being used 24/7 it could easily lead to a corrupt backup. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material not intended for Public use. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this communication in error, please notify the sender and delete the material from any and all computers or devices. ___ 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] Question about uvbackup dd and uvrestore
Thanks Rex. It's a pity. This way, you need lots of space. And what's worse: If you try to restore from the decompressed image (bigger than 2Gb) you get an end of reel after restoring the first 2Gb... So that, if you need to backup more than 20 Gb you can't do it to disk, because of this 2Gb limit size for each output image and the other limit of 9 images destination for each command (uvbackup -t file1.bk -t file2.bk ... -t file9.bk) Regards -- Augusto Alonso IT Manager QUITER SERVICIOS CENTRALES Zoco Gran Santander, 1ª planta - 39011 Santander - España Telf: +34 902233323 - Fax: +34 902234280 AVISO LEGAL: Este mensaje contiene información destinada exclusivamente al usuario de destino, pudiendo contener información confidencial o protegida legalmente. Si, por un error de envío o transmisión, ha recibido este mensaje y usted no es el destinatario del mismo, por favor, notifique de este hecho al remitente y no use, informe, distribuya, imprima, copie o difunda este mensaje bajo ningún medio . Cualquier opinión en él contenida, es exclusiva de su autor y no representa necesariamente la opinión de Quiter Servicios Centrales. LEGAL WARNING: This e-mail and any attachment, contain information intended solely for the addressee and may contain confidential information or legally protected data. If you are not the intended recipient, please notify the sender and do not use, disclose, distribute, copy, print or rely on this e-mail under any circumstances. The views and opinions expressed are the author´s own and do not necessarily reflect those of Quiter Servicios Centrales. 2011/4/14 Rex Gozar rgo...@gmail.com Universe admin documentation has the disclaimer: Note: uvrestore does not support reading from stdin. You'll need to gunzip the backup file to disk before you can uvrestore it. rex On Wed, Apr 13, 2011 at 9:12 PM, Augusto Alonso aalo...@quiter.com wrote: Hi all. I'm trying to pipe uvbackup (universe) and gzip in order to compress backups on the fly. I've done it with success. But the problem arise when I try to uvrestore from it. A simple test that you can try: RHEL:/u2/uv# find HS.SALES | bin/uvbackup -v -f - |dd of=hs_sales.bk Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type: Full Backup (ver9 UNIX) Block Size: 8192 bytes NLS on: False Label : Current device(s): stdout Backing up HS.SALES Backing up HS.SALES/VOC.u Backing up HS.SALES/D_VOC Backing up HS.SALES/VOCLIB Backing up HS.SALES/D_VOCLIB Backing up HS.SALES/CUSTOMER Backing up HS.SALES/CUSTOMER.u Backing up HS.SALES/D_CUSTOMER Backing up HS.SALES/D_CUSTOMER.u Backing up HS.SALES/PRODUCTS Backing up HS.SALES/PRODUCTS.u Backing up HS.SALES/D_PRODUCTS Backing up HS.SALES/D_PRODUCTS.u Backing up HS.SALES/STATES Backing up HS.SALES/STATES.u Backing up HS.SALES/D_STATES Backing up HS.SALES/D_STATES.u Backing up HS.SALES/HS_FILE_A000 Backing up HS.SALES/D_HS_FILE_A000 Backing up HS.SALES/.hs_fileinfo Backing up HS.SALES/VOC Backing up HS.SALES/.uvconfig Backing up HS.SALES/uvconfig Backing up HS.SALES/puntouvconfig Total files: 24 Total bytes : 97273 Elapsed Time: 00:00:01 12 operating system files processed, 0 broken, totalling 41444 data bytes. 12 UniVerse files processed, 0 corrupted. 939 UniVerse records processed, 0 corrupted, totalling 55829 data bytes. -1073742616 extended keys processed, 0 not supported at specified revision level. EndOfUvbackup 288+0 records in 288+0 records out RHEL:/u2/uv# dd if=hs_sales.bk | bin/uvrestore -v -i -t /dev/stdin Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type: Full Backup (ver9 UNIX) Block Size: 8192 bytes NLS on: False FastWrite On : False Label : Current device(s): /dev/stdin WARNING: Block 1 checksum value of 0 does not match computed checksum of -6667. Integrity of block questionable. Continue (Y/N)? intended publication of source code. * Total files: 0 Total bytes : 0 Elapsed Time: 12:00:00 0 operating system files processed, 0 broken, totalling 0 data bytes. 0 UniVerse files processed, 0 corrupted. 0 UniVerse records processed, 0 corrupted, totalling 0 data bytes. -1073742632 extended keys processed, 0 not supported at specified revision level. EndOfUvrestore 26+0 records in 25+0 records out RHEL:/u2/uv# Could someone explain why this happen? And the backup is all right, because it works if you change the syntax (without pipe): RHEL:/u2/uv# bin/uvrestore -v -i -t hs_sales.bk Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type: Full Backup (ver9 UNIX) Block Size: 8192 bytes NLS on: False FastWrite On : False Label : Current device(s): /u2/uv/hs_sales.bk HS.SALES (Apr 13 21:22:29) HS.SALES/VOC.u
Re: [U2] Question about uvbackup dd and uvrestore
Unless you need record-level restores, I would recommend using tar to backup your Universe accounts. rex ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Question about uvbackup dd and uvrestore
Ad I am not directly associated with Ashwood Computer Companies, but after the thrashing others have taken for not including the Ad moniker on their postings I felt compelled. Ashwood Computer Companies at www.ashwoodcomputer.com (do...@ashwoodcomputer.com) have a backup product that is specifically designed to work with MV databases and is quite capable and reliable. You might want to look into their product. You can find it on their web site. Thanks Tom Dodds On Apr 13, 2011, at 8:12 PM, Augusto Alonso wrote: Hi all. I'm trying to pipe uvbackup (universe) and gzip in order to compress backups on the fly. I've done it with success. But the problem arise when I try to uvrestore from it. A simple test that you can try: RHEL:/u2/uv# find HS.SALES | bin/uvbackup -v -f - |dd of=hs_sales.bk Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type: Full Backup (ver9 UNIX) Block Size: 8192 bytes NLS on: False Label : Current device(s): stdout Backing up HS.SALES Backing up HS.SALES/VOC.u Backing up HS.SALES/D_VOC Backing up HS.SALES/VOCLIB Backing up HS.SALES/D_VOCLIB Backing up HS.SALES/CUSTOMER Backing up HS.SALES/CUSTOMER.u Backing up HS.SALES/D_CUSTOMER Backing up HS.SALES/D_CUSTOMER.u Backing up HS.SALES/PRODUCTS Backing up HS.SALES/PRODUCTS.u Backing up HS.SALES/D_PRODUCTS Backing up HS.SALES/D_PRODUCTS.u Backing up HS.SALES/STATES Backing up HS.SALES/STATES.u Backing up HS.SALES/D_STATES Backing up HS.SALES/D_STATES.u Backing up HS.SALES/HS_FILE_A000 Backing up HS.SALES/D_HS_FILE_A000 Backing up HS.SALES/.hs_fileinfo Backing up HS.SALES/VOC Backing up HS.SALES/.uvconfig Backing up HS.SALES/uvconfig Backing up HS.SALES/puntouvconfig Total files: 24 Total bytes : 97273 Elapsed Time: 00:00:01 12 operating system files processed, 0 broken, totalling 41444 data bytes. 12 UniVerse files processed, 0 corrupted. 939 UniVerse records processed, 0 corrupted, totalling 55829 data bytes. -1073742616 extended keys processed, 0 not supported at specified revision level. EndOfUvbackup 288+0 records in 288+0 records out RHEL:/u2/uv# dd if=hs_sales.bk | bin/uvrestore -v -i -t /dev/stdin Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type: Full Backup (ver9 UNIX) Block Size: 8192 bytes NLS on: False FastWrite On : False Label : Current device(s): /dev/stdin WARNING: Block 1 checksum value of 0 does not match computed checksum of -6667. Integrity of block questionable. Continue (Y/N)? intended publication of source code. * Total files: 0 Total bytes : 0 Elapsed Time: 12:00:00 0 operating system files processed, 0 broken, totalling 0 data bytes. 0 UniVerse files processed, 0 corrupted. 0 UniVerse records processed, 0 corrupted, totalling 0 data bytes. -1073742632 extended keys processed, 0 not supported at specified revision level. EndOfUvrestore 26+0 records in 25+0 records out RHEL:/u2/uv# Could someone explain why this happen? And the backup is all right, because it works if you change the syntax (without pipe): RHEL:/u2/uv# bin/uvrestore -v -i -t hs_sales.bk Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type: Full Backup (ver9 UNIX) Block Size: 8192 bytes NLS on: False FastWrite On : False Label : Current device(s): /u2/uv/hs_sales.bk HS.SALES (Apr 13 21:22:29) HS.SALES/VOC.u (Apr 13 21:22:29) HS.SALES/D_VOC (Apr 13 21:22:29) HS.SALES/VOCLIB (Apr 13 21:22:29) HS.SALES/D_VOCLIB (Apr 13 21:22:29) HS.SALES/CUSTOMER (Apr 13 21:22:29) HS.SALES/CUSTOMER.u (Apr 13 21:22:29) HS.SALES/D_CUSTOMER (Apr 13 21:22:29) HS.SALES/D_CUSTOMER.u (Apr 13 21:22:29) HS.SALES/PRODUCTS (Apr 13 21:22:29) HS.SALES/PRODUCTS.u (Apr 13 21:22:29) HS.SALES/D_PRODUCTS (Apr 13 21:22:29) HS.SALES/D_PRODUCTS.u (Apr 13 21:22:29) HS.SALES/STATES (Apr 13 21:22:29) HS.SALES/STATES.u (Apr 13 21:22:29) HS.SALES/D_STATES (Apr 13 21:22:29) HS.SALES/D_STATES.u (Apr 13 21:22:29) HS.SALES/HS_FILE_A000 (Apr 13 21:22:29) HS.SALES/D_HS_FILE_A000 (Apr 13 21:22:29) HS.SALES/.hs_fileinfo (Apr 13 21:22:29) HS.SALES/VOC (Apr 13 21:22:29) HS.SALES/.uvconfig (Apr 13 21:22:29) HS.SALES/uvconfig (Apr 13 21:22:29) HS.SALES/puntouvconfig (Apr 13 21:22:29) Total files: 0 Total bytes : 0 Elapsed Time: 12:00:00 0 operating system files processed, 0 broken, totalling 0 data bytes. 0 UniVerse files processed, 0 corrupted. 0 UniVerse records processed, 0 corrupted, totalling 0 data bytes. -1073742632 extended keys processed, 0 not supported at specified revision level. EndOfUvrestore RHEL:/u2/uv# Any suggestion? Regards -- Augusto Alonso IT manager QUITER SERVICIOS CENTRALES Zoco Gran Santander, 1ª planta - 39011 Santander - España Telf: +34 902233323 - Fax: +34 902234280 AVISO LEGAL: Este mensaje contiene información destinada exclusivamente al
Re: [U2] Question about uvbackup dd and uvrestore
I am not familiar with the specific backup product, but I used to work for Ashwood years ago. They are VERY good people and leaving them was one of the hardest decisions I ever had to make. If you call, tell Doug I said hi. John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Dodds Sent: Friday, April 15, 2011 8:44 AM To: U2 Users List Subject: Re: [U2] Question about uvbackup dd and uvrestore Ad I am not directly associated with Ashwood Computer Companies, but after the thrashing others have taken for not including the Ad moniker on their postings I felt compelled. Ashwood Computer Companies at www.ashwoodcomputer.com (do...@ashwoodcomputer.com) have a backup product that is specifically designed to work with MV databases and is quite capable and reliable. You might want to look into their product. You can find it on their web site. Thanks Tom Dodds On Apr 13, 2011, at 8:12 PM, Augusto Alonso wrote: Hi all. I'm trying to pipe uvbackup (universe) and gzip in order to compress backups on the fly. I've done it with success. But the problem arise when I try to uvrestore from it. A simple test that you can try: RHEL:/u2/uv# find HS.SALES | bin/uvbackup -v -f - |dd of=hs_sales.bk Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type: Full Backup (ver9 UNIX) Block Size: 8192 bytes NLS on: False Label : Current device(s): stdout Backing up HS.SALES Backing up HS.SALES/VOC.u Backing up HS.SALES/D_VOC Backing up HS.SALES/VOCLIB Backing up HS.SALES/D_VOCLIB Backing up HS.SALES/CUSTOMER Backing up HS.SALES/CUSTOMER.u Backing up HS.SALES/D_CUSTOMER Backing up HS.SALES/D_CUSTOMER.u Backing up HS.SALES/PRODUCTS Backing up HS.SALES/PRODUCTS.u Backing up HS.SALES/D_PRODUCTS Backing up HS.SALES/D_PRODUCTS.u Backing up HS.SALES/STATES Backing up HS.SALES/STATES.u Backing up HS.SALES/D_STATES Backing up HS.SALES/D_STATES.u Backing up HS.SALES/HS_FILE_A000 Backing up HS.SALES/D_HS_FILE_A000 Backing up HS.SALES/.hs_fileinfo Backing up HS.SALES/VOC Backing up HS.SALES/.uvconfig Backing up HS.SALES/uvconfig Backing up HS.SALES/puntouvconfig Total files: 24 Total bytes : 97273 Elapsed Time: 00:00:01 12 operating system files processed, 0 broken, totalling 41444 data bytes. 12 UniVerse files processed, 0 corrupted. 939 UniVerse records processed, 0 corrupted, totalling 55829 data bytes. -1073742616 extended keys processed, 0 not supported at specified revision level. EndOfUvbackup 288+0 records in 288+0 records out RHEL:/u2/uv# dd if=hs_sales.bk | bin/uvrestore -v -i -t /dev/stdin Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type: Full Backup (ver9 UNIX) Block Size: 8192 bytes NLS on: False FastWrite On : False Label : Current device(s): /dev/stdin WARNING: Block 1 checksum value of 0 does not match computed checksum of -6667. Integrity of block questionable. Continue (Y/N)? intended publication of source code. * Total files: 0 Total bytes : 0 Elapsed Time: 12:00:00 0 operating system files processed, 0 broken, totalling 0 data bytes. 0 UniVerse files processed, 0 corrupted. 0 UniVerse records processed, 0 corrupted, totalling 0 data bytes. -1073742632 extended keys processed, 0 not supported at specified revision level. EndOfUvrestore 26+0 records in 25+0 records out RHEL:/u2/uv# Could someone explain why this happen? And the backup is all right, because it works if you change the syntax (without pipe): RHEL:/u2/uv# bin/uvrestore -v -i -t hs_sales.bk Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type: Full Backup (ver9 UNIX) Block Size: 8192 bytes NLS on: False FastWrite On : False Label : Current device(s): /u2/uv/hs_sales.bk HS.SALES (Apr 13 21:22:29) HS.SALES/VOC.u (Apr 13 21:22:29) HS.SALES/D_VOC (Apr 13 21:22:29) HS.SALES/VOCLIB (Apr 13 21:22:29) HS.SALES/D_VOCLIB (Apr 13 21:22:29) HS.SALES/CUSTOMER (Apr 13 21:22:29) HS.SALES/CUSTOMER.u (Apr 13 21:22:29) HS.SALES/D_CUSTOMER (Apr 13 21:22:29) HS.SALES/D_CUSTOMER.u (Apr 13 21:22:29) HS.SALES/PRODUCTS (Apr 13 21:22:29) HS.SALES/PRODUCTS.u (Apr 13 21:22:29) HS.SALES/D_PRODUCTS (Apr 13 21:22:29) HS.SALES/D_PRODUCTS.u (Apr 13 21:22:29) HS.SALES/STATES (Apr 13 21:22:29) HS.SALES/STATES.u (Apr 13 21:22:29) HS.SALES/D_STATES (Apr 13 21:22:29) HS.SALES/D_STATES.u (Apr 13 21:22:29) HS.SALES/HS_FILE_A000 (Apr 13 21:22:29) HS.SALES/D_HS_FILE_A000 (Apr 13 21:22:29) HS.SALES/.hs_fileinfo (Apr 13 21:22:29) HS.SALES/VOC (Apr 13 21:22:29) HS.SALES/.uvconfig (Apr 13 21:22:29) HS.SALES/uvconfig (Apr 13 21:22:29) HS.SALES/puntouvconfig (Apr 13 21:22:29) Total files: 0 Total bytes : 0
Re: [U2] Question about uvbackup dd and uvrestore
LOL, Tom. Just to clarify -- when users of a product or service praise the product or company, when they have no fiduciary stake or relationship to the company, the AD tag is not required. An AD tag is only required when someone stands to gain financially from the product or service that they're recommending. It's just fair disclosure. Larry Hiscock Moderator -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Dodds Sent: Friday, April 15, 2011 5:44 AM To: U2 Users List Subject: Re: [U2] Question about uvbackup dd and uvrestore Ad I am not directly associated with Ashwood Computer Companies, but after the thrashing others have taken for not including the Ad moniker on their postings I felt compelled. Ashwood Computer Companies at www.ashwoodcomputer.com (do...@ashwoodcomputer.com) have a backup product that is specifically designed to work with MV databases and is quite capable and reliable. You might want to look into their product. You can find it on their web site. Thanks Tom Dodds On Apr 13, 2011, at 8:12 PM, Augusto Alonso wrote: Hi all. I'm trying to pipe uvbackup (universe) and gzip in order to compress backups on the fly. I've done it with success. But the problem arise when I try to uvrestore from it. A simple test that you can try: RHEL:/u2/uv# find HS.SALES | bin/uvbackup -v -f - |dd of=hs_sales.bk Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type: Full Backup (ver9 UNIX) Block Size: 8192 bytes NLS on: False Label : Current device(s): stdout Backing up HS.SALES Backing up HS.SALES/VOC.u Backing up HS.SALES/D_VOC Backing up HS.SALES/VOCLIB Backing up HS.SALES/D_VOCLIB Backing up HS.SALES/CUSTOMER Backing up HS.SALES/CUSTOMER.u Backing up HS.SALES/D_CUSTOMER Backing up HS.SALES/D_CUSTOMER.u Backing up HS.SALES/PRODUCTS Backing up HS.SALES/PRODUCTS.u Backing up HS.SALES/D_PRODUCTS Backing up HS.SALES/D_PRODUCTS.u Backing up HS.SALES/STATES Backing up HS.SALES/STATES.u Backing up HS.SALES/D_STATES Backing up HS.SALES/D_STATES.u Backing up HS.SALES/HS_FILE_A000 Backing up HS.SALES/D_HS_FILE_A000 Backing up HS.SALES/.hs_fileinfo Backing up HS.SALES/VOC Backing up HS.SALES/.uvconfig Backing up HS.SALES/uvconfig Backing up HS.SALES/puntouvconfig Total files: 24 Total bytes : 97273 Elapsed Time: 00:00:01 12 operating system files processed, 0 broken, totalling 41444 data bytes. 12 UniVerse files processed, 0 corrupted. 939 UniVerse records processed, 0 corrupted, totalling 55829 data bytes. -1073742616 extended keys processed, 0 not supported at specified revision level. EndOfUvbackup 288+0 records in 288+0 records out RHEL:/u2/uv# dd if=hs_sales.bk | bin/uvrestore -v -i -t /dev/stdin Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type: Full Backup (ver9 UNIX) Block Size: 8192 bytes NLS on: False FastWrite On : False Label : Current device(s): /dev/stdin WARNING: Block 1 checksum value of 0 does not match computed checksum of -6667. Integrity of block questionable. Continue (Y/N)? intended publication of source code. * Total files: 0 Total bytes : 0 Elapsed Time: 12:00:00 0 operating system files processed, 0 broken, totalling 0 data bytes. 0 UniVerse files processed, 0 corrupted. 0 UniVerse records processed, 0 corrupted, totalling 0 data bytes. -1073742632 extended keys processed, 0 not supported at specified revision level. EndOfUvrestore 26+0 records in 25+0 records out RHEL:/u2/uv# Could someone explain why this happen? And the backup is all right, because it works if you change the syntax (without pipe): RHEL:/u2/uv# bin/uvrestore -v -i -t hs_sales.bk Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type: Full Backup (ver9 UNIX) Block Size: 8192 bytes NLS on: False FastWrite On : False Label : Current device(s): /u2/uv/hs_sales.bk HS.SALES (Apr 13 21:22:29) HS.SALES/VOC.u (Apr 13 21:22:29) HS.SALES/D_VOC (Apr 13 21:22:29) HS.SALES/VOCLIB (Apr 13 21:22:29) HS.SALES/D_VOCLIB (Apr 13 21:22:29) HS.SALES/CUSTOMER (Apr 13 21:22:29) HS.SALES/CUSTOMER.u (Apr 13 21:22:29) HS.SALES/D_CUSTOMER (Apr 13 21:22:29) HS.SALES/D_CUSTOMER.u (Apr 13 21:22:29) HS.SALES/PRODUCTS (Apr 13 21:22:29) HS.SALES/PRODUCTS.u (Apr 13 21:22:29) HS.SALES/D_PRODUCTS (Apr 13 21:22:29) HS.SALES/D_PRODUCTS.u (Apr 13 21:22:29) HS.SALES/STATES (Apr 13 21:22:29) HS.SALES/STATES.u (Apr 13 21:22:29) HS.SALES/D_STATES (Apr 13 21:22:29) HS.SALES/D_STATES.u (Apr 13 21:22:29) HS.SALES/HS_FILE_A000 (Apr 13 21:22:29) HS.SALES/D_HS_FILE_A000 (Apr 13 21:22:29) HS.SALES/.hs_fileinfo (Apr 13 21:22:29) HS.SALES/VOC (Apr 13 21:22:29) HS.SALES/.uvconfig (Apr 13 21:22:29) HS.SALES/uvconfig (Apr 13 21:22:29) HS.SALES/puntouvconfig (Apr 13 21:22:29) Total files
Re: [U2] Question about uvbackup dd and uvrestore
Thanks for the clarification, Larry. With the verbal beating some people took over the last view weeks, I felt it better to be safe than beaten. Sent from my iPhone Tom Dodds t...@ix.netcom.com 630.235.2975 On Apr 15, 2011, at 11:54, Larry Hiscock lar...@wcs-corp.com wrote: LOL, Tom. Just to clarify -- when users of a product or service praise the product or company, when they have no fiduciary stake or relationship to the company, the AD tag is not required. An AD tag is only required when someone stands to gain financially from the product or service that they're recommending. It's just fair disclosure. Larry Hiscock Moderator -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Dodds Sent: Friday, April 15, 2011 5:44 AM To: U2 Users List Subject: Re: [U2] Question about uvbackup dd and uvrestore Ad I am not directly associated with Ashwood Computer Companies, but after the thrashing others have taken for not including the Ad moniker on their postings I felt compelled. Ashwood Computer Companies at www.ashwoodcomputer.com (do...@ashwoodcomputer.com) have a backup product that is specifically designed to work with MV databases and is quite capable and reliable. You might want to look into their product. You can find it on their web site. Thanks Tom Dodds On Apr 13, 2011, at 8:12 PM, Augusto Alonso wrote: Hi all. I'm trying to pipe uvbackup (universe) and gzip in order to compress backups on the fly. I've done it with success. But the problem arise when I try to uvrestore from it. A simple test that you can try: RHEL:/u2/uv# find HS.SALES | bin/uvbackup -v -f - |dd of=hs_sales.bk Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type: Full Backup (ver9 UNIX) Block Size: 8192 bytes NLS on: False Label : Current device(s): stdout Backing up HS.SALES Backing up HS.SALES/VOC.u Backing up HS.SALES/D_VOC Backing up HS.SALES/VOCLIB Backing up HS.SALES/D_VOCLIB Backing up HS.SALES/CUSTOMER Backing up HS.SALES/CUSTOMER.u Backing up HS.SALES/D_CUSTOMER Backing up HS.SALES/D_CUSTOMER.u Backing up HS.SALES/PRODUCTS Backing up HS.SALES/PRODUCTS.u Backing up HS.SALES/D_PRODUCTS Backing up HS.SALES/D_PRODUCTS.u Backing up HS.SALES/STATES Backing up HS.SALES/STATES.u Backing up HS.SALES/D_STATES Backing up HS.SALES/D_STATES.u Backing up HS.SALES/HS_FILE_A000 Backing up HS.SALES/D_HS_FILE_A000 Backing up HS.SALES/.hs_fileinfo Backing up HS.SALES/VOC Backing up HS.SALES/.uvconfig Backing up HS.SALES/uvconfig Backing up HS.SALES/puntouvconfig Total files: 24 Total bytes : 97273 Elapsed Time: 00:00:01 12 operating system files processed, 0 broken, totalling 41444 data bytes. 12 UniVerse files processed, 0 corrupted. 939 UniVerse records processed, 0 corrupted, totalling 55829 data bytes. -1073742616 extended keys processed, 0 not supported at specified revision level. EndOfUvbackup 288+0 records in 288+0 records out RHEL:/u2/uv# dd if=hs_sales.bk | bin/uvrestore -v -i -t /dev/stdin Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type: Full Backup (ver9 UNIX) Block Size: 8192 bytes NLS on: False FastWrite On : False Label : Current device(s): /dev/stdin WARNING: Block 1 checksum value of 0 does not match computed checksum of -6667. Integrity of block questionable. Continue (Y/N)? intended publication of source code. * Total files: 0 Total bytes : 0 Elapsed Time: 12:00:00 0 operating system files processed, 0 broken, totalling 0 data bytes. 0 UniVerse files processed, 0 corrupted. 0 UniVerse records processed, 0 corrupted, totalling 0 data bytes. -1073742632 extended keys processed, 0 not supported at specified revision level. EndOfUvrestore 26+0 records in 25+0 records out RHEL:/u2/uv# Could someone explain why this happen? And the backup is all right, because it works if you change the syntax (without pipe): RHEL:/u2/uv# bin/uvrestore -v -i -t hs_sales.bk Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type: Full Backup (ver9 UNIX) Block Size: 8192 bytes NLS on: False FastWrite On : False Label : Current device(s): /u2/uv/hs_sales.bk HS.SALES (Apr 13 21:22:29) HS.SALES/VOC.u (Apr 13 21:22:29) HS.SALES/D_VOC (Apr 13 21:22:29) HS.SALES/VOCLIB (Apr 13 21:22:29) HS.SALES/D_VOCLIB (Apr 13 21:22:29) HS.SALES/CUSTOMER (Apr 13 21:22:29) HS.SALES/CUSTOMER.u (Apr 13 21:22:29) HS.SALES/D_CUSTOMER (Apr 13 21:22:29) HS.SALES/D_CUSTOMER.u (Apr 13 21:22:29) HS.SALES/PRODUCTS (Apr 13 21:22:29) HS.SALES/PRODUCTS.u (Apr 13 21:22:29) HS.SALES/D_PRODUCTS (Apr 13 21:22:29) HS.SALES/D_PRODUCTS.u (Apr 13 21:22:29) HS.SALES/STATES (Apr 13 21:22:29) HS.SALES/STATES.u (Apr 13 21:22:29) HS.SALES/D_STATES (Apr 13 21:22:29) HS.SALES
Re: [U2] Question about uvbackup dd and uvrestore
On 15/04/11 13:30, Rex Gozar wrote: Unless you need record-level restores, I would recommend using tar to backup your Universe accounts. While UV is running and being used? tar is all very well, but if the database is being used 24/7 it could easily lead to a corrupt backup. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Question about uvbackup dd and uvrestore
The product provided by Ashwood handles this nicely. On an AIX system, it pauses the database, performs a JFS2 snapshot (in seconds), releases the database, then the customizable backup script (we use tar and gzip) backs up the snapshot. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Friday, April 15, 2011 12:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Question about uvbackup dd and uvrestore On 15/04/11 13:30, Rex Gozar wrote: Unless you need record-level restores, I would recommend using tar to backup your Universe accounts. While UV is running and being used? tar is all very well, but if the database is being used 24/7 it could easily lead to a corrupt backup. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material not intended for Public use. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this communication in error, please notify the sender and delete the material from any and all computers or devices. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Question about uvbackup dd and uvrestore
IBM has a nice point in time product as well... Danny -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bpa...@serta.com Sent: Friday, April 15, 2011 2:39 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Question about uvbackup dd and uvrestore The product provided by Ashwood handles this nicely. On an AIX system, it pauses the database, performs a JFS2 snapshot (in seconds), releases the database, then the customizable backup script (we use tar and gzip) backs up the snapshot. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Friday, April 15, 2011 12:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Question about uvbackup dd and uvrestore On 15/04/11 13:30, Rex Gozar wrote: Unless you need record-level restores, I would recommend using tar to backup your Universe accounts. While UV is running and being used? tar is all very well, but if the database is being used 24/7 it could easily lead to a corrupt backup. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material not intended for Public use. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this communication in error, please notify the sender and delete the material from any and all computers or devices. ___ 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] Question about uvbackup dd and uvrestore
Universe admin documentation has the disclaimer: Note: uvrestore does not support reading from stdin. You'll need to gunzip the backup file to disk before you can uvrestore it. rex On Wed, Apr 13, 2011 at 9:12 PM, Augusto Alonso aalo...@quiter.com wrote: Hi all. I'm trying to pipe uvbackup (universe) and gzip in order to compress backups on the fly. I've done it with success. But the problem arise when I try to uvrestore from it. A simple test that you can try: RHEL:/u2/uv# find HS.SALES | bin/uvbackup -v -f - |dd of=hs_sales.bk Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type : Full Backup (ver9 UNIX) Block Size : 8192 bytes NLS on : False Label : Current device(s): stdout Backing up HS.SALES Backing up HS.SALES/VOC.u Backing up HS.SALES/D_VOC Backing up HS.SALES/VOCLIB Backing up HS.SALES/D_VOCLIB Backing up HS.SALES/CUSTOMER Backing up HS.SALES/CUSTOMER.u Backing up HS.SALES/D_CUSTOMER Backing up HS.SALES/D_CUSTOMER.u Backing up HS.SALES/PRODUCTS Backing up HS.SALES/PRODUCTS.u Backing up HS.SALES/D_PRODUCTS Backing up HS.SALES/D_PRODUCTS.u Backing up HS.SALES/STATES Backing up HS.SALES/STATES.u Backing up HS.SALES/D_STATES Backing up HS.SALES/D_STATES.u Backing up HS.SALES/HS_FILE_A000 Backing up HS.SALES/D_HS_FILE_A000 Backing up HS.SALES/.hs_fileinfo Backing up HS.SALES/VOC Backing up HS.SALES/.uvconfig Backing up HS.SALES/uvconfig Backing up HS.SALES/puntouvconfig Total files: 24 Total bytes : 97273 Elapsed Time: 00:00:01 12 operating system files processed, 0 broken, totalling 41444 data bytes. 12 UniVerse files processed, 0 corrupted. 939 UniVerse records processed, 0 corrupted, totalling 55829 data bytes. -1073742616 extended keys processed, 0 not supported at specified revision level. EndOfUvbackup 288+0 records in 288+0 records out RHEL:/u2/uv# dd if=hs_sales.bk | bin/uvrestore -v -i -t /dev/stdin Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type : Full Backup (ver9 UNIX) Block Size : 8192 bytes NLS on : False FastWrite On : False Label : Current device(s): /dev/stdin WARNING: Block 1 checksum value of 0 does not match computed checksum of -6667. Integrity of block questionable. Continue (Y/N)? intended publication of source code. * Total files: 0 Total bytes : 0 Elapsed Time: 12:00:00 0 operating system files processed, 0 broken, totalling 0 data bytes. 0 UniVerse files processed, 0 corrupted. 0 UniVerse records processed, 0 corrupted, totalling 0 data bytes. -1073742632 extended keys processed, 0 not supported at specified revision level. EndOfUvrestore 26+0 records in 25+0 records out RHEL:/u2/uv# Could someone explain why this happen? And the backup is all right, because it works if you change the syntax (without pipe): RHEL:/u2/uv# bin/uvrestore -v -i -t hs_sales.bk Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type : Full Backup (ver9 UNIX) Block Size : 8192 bytes NLS on : False FastWrite On : False Label : Current device(s): /u2/uv/hs_sales.bk HS.SALES (Apr 13 21:22:29) HS.SALES/VOC.u (Apr 13 21:22:29) HS.SALES/D_VOC (Apr 13 21:22:29) HS.SALES/VOCLIB (Apr 13 21:22:29) HS.SALES/D_VOCLIB (Apr 13 21:22:29) HS.SALES/CUSTOMER (Apr 13 21:22:29) HS.SALES/CUSTOMER.u (Apr 13 21:22:29) HS.SALES/D_CUSTOMER (Apr 13 21:22:29) HS.SALES/D_CUSTOMER.u (Apr 13 21:22:29) HS.SALES/PRODUCTS (Apr 13 21:22:29) HS.SALES/PRODUCTS.u (Apr 13 21:22:29) HS.SALES/D_PRODUCTS (Apr 13 21:22:29) HS.SALES/D_PRODUCTS.u (Apr 13 21:22:29) HS.SALES/STATES (Apr 13 21:22:29) HS.SALES/STATES.u (Apr 13 21:22:29) HS.SALES/D_STATES (Apr 13 21:22:29) HS.SALES/D_STATES.u (Apr 13 21:22:29) HS.SALES/HS_FILE_A000 (Apr 13 21:22:29) HS.SALES/D_HS_FILE_A000 (Apr 13 21:22:29) HS.SALES/.hs_fileinfo (Apr 13 21:22:29) HS.SALES/VOC (Apr 13 21:22:29) HS.SALES/.uvconfig (Apr 13 21:22:29) HS.SALES/uvconfig (Apr 13 21:22:29) HS.SALES/puntouvconfig (Apr 13 21:22:29) Total files: 0 Total bytes : 0 Elapsed Time: 12:00:00 0 operating system files processed, 0 broken, totalling 0 data bytes. 0 UniVerse files processed, 0 corrupted. 0 UniVerse records processed, 0 corrupted, totalling 0 data bytes. -1073742632 extended keys processed, 0 not supported at specified revision level. EndOfUvrestore RHEL:/u2/uv# Any suggestion? Regards -- Augusto Alonso IT manager QUITER SERVICIOS CENTRALES Zoco Gran Santander, 1ª planta - 39011 Santander - España Telf: +34 902233323 - Fax: +34 902234280 AVISO LEGAL: Este mensaje contiene información destinada exclusivamente al usuario de destino, pudiendo contener información confidencial o protegida legalmente. Si, por un error de envío o transmisión, ha recibido este mensaje y usted no es el destinatario del mismo, por favor, notifique de este hecho al remitente y no
[U2] Question about uvbackup dd and uvrestore
Hi all. I'm trying to pipe uvbackup (universe) and gzip in order to compress backups on the fly. I've done it with success. But the problem arise when I try to uvrestore from it. A simple test that you can try: RHEL:/u2/uv# find HS.SALES | bin/uvbackup -v -f - |dd of=hs_sales.bk Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type: Full Backup (ver9 UNIX) Block Size: 8192 bytes NLS on: False Label : Current device(s): stdout Backing up HS.SALES Backing up HS.SALES/VOC.u Backing up HS.SALES/D_VOC Backing up HS.SALES/VOCLIB Backing up HS.SALES/D_VOCLIB Backing up HS.SALES/CUSTOMER Backing up HS.SALES/CUSTOMER.u Backing up HS.SALES/D_CUSTOMER Backing up HS.SALES/D_CUSTOMER.u Backing up HS.SALES/PRODUCTS Backing up HS.SALES/PRODUCTS.u Backing up HS.SALES/D_PRODUCTS Backing up HS.SALES/D_PRODUCTS.u Backing up HS.SALES/STATES Backing up HS.SALES/STATES.u Backing up HS.SALES/D_STATES Backing up HS.SALES/D_STATES.u Backing up HS.SALES/HS_FILE_A000 Backing up HS.SALES/D_HS_FILE_A000 Backing up HS.SALES/.hs_fileinfo Backing up HS.SALES/VOC Backing up HS.SALES/.uvconfig Backing up HS.SALES/uvconfig Backing up HS.SALES/puntouvconfig Total files: 24 Total bytes : 97273 Elapsed Time: 00:00:01 12 operating system files processed, 0 broken, totalling 41444 data bytes. 12 UniVerse files processed, 0 corrupted. 939 UniVerse records processed, 0 corrupted, totalling 55829 data bytes. -1073742616 extended keys processed, 0 not supported at specified revision level. EndOfUvbackup 288+0 records in 288+0 records out RHEL:/u2/uv# dd if=hs_sales.bk | bin/uvrestore -v -i -t /dev/stdin Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type: Full Backup (ver9 UNIX) Block Size: 8192 bytes NLS on: False FastWrite On : False Label : Current device(s): /dev/stdin WARNING: Block 1 checksum value of 0 does not match computed checksum of -6667. Integrity of block questionable. Continue (Y/N)? intended publication of source code. * Total files: 0 Total bytes : 0 Elapsed Time: 12:00:00 0 operating system files processed, 0 broken, totalling 0 data bytes. 0 UniVerse files processed, 0 corrupted. 0 UniVerse records processed, 0 corrupted, totalling 0 data bytes. -1073742632 extended keys processed, 0 not supported at specified revision level. EndOfUvrestore 26+0 records in 25+0 records out RHEL:/u2/uv# Could someone explain why this happen? And the backup is all right, because it works if you change the syntax (without pipe): RHEL:/u2/uv# bin/uvrestore -v -i -t hs_sales.bk Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type: Full Backup (ver9 UNIX) Block Size: 8192 bytes NLS on: False FastWrite On : False Label : Current device(s): /u2/uv/hs_sales.bk HS.SALES (Apr 13 21:22:29) HS.SALES/VOC.u (Apr 13 21:22:29) HS.SALES/D_VOC (Apr 13 21:22:29) HS.SALES/VOCLIB (Apr 13 21:22:29) HS.SALES/D_VOCLIB (Apr 13 21:22:29) HS.SALES/CUSTOMER (Apr 13 21:22:29) HS.SALES/CUSTOMER.u (Apr 13 21:22:29) HS.SALES/D_CUSTOMER (Apr 13 21:22:29) HS.SALES/D_CUSTOMER.u (Apr 13 21:22:29) HS.SALES/PRODUCTS (Apr 13 21:22:29) HS.SALES/PRODUCTS.u (Apr 13 21:22:29) HS.SALES/D_PRODUCTS (Apr 13 21:22:29) HS.SALES/D_PRODUCTS.u (Apr 13 21:22:29) HS.SALES/STATES (Apr 13 21:22:29) HS.SALES/STATES.u (Apr 13 21:22:29) HS.SALES/D_STATES (Apr 13 21:22:29) HS.SALES/D_STATES.u (Apr 13 21:22:29) HS.SALES/HS_FILE_A000 (Apr 13 21:22:29) HS.SALES/D_HS_FILE_A000 (Apr 13 21:22:29) HS.SALES/.hs_fileinfo (Apr 13 21:22:29) HS.SALES/VOC (Apr 13 21:22:29) HS.SALES/.uvconfig (Apr 13 21:22:29) HS.SALES/uvconfig (Apr 13 21:22:29) HS.SALES/puntouvconfig (Apr 13 21:22:29) Total files: 0 Total bytes : 0 Elapsed Time: 12:00:00 0 operating system files processed, 0 broken, totalling 0 data bytes. 0 UniVerse files processed, 0 corrupted. 0 UniVerse records processed, 0 corrupted, totalling 0 data bytes. -1073742632 extended keys processed, 0 not supported at specified revision level. EndOfUvrestore RHEL:/u2/uv# Any suggestion? Regards -- Augusto Alonso IT manager QUITER SERVICIOS CENTRALES Zoco Gran Santander, 1ª planta - 39011 Santander - España Telf: +34 902233323 - Fax: +34 902234280 AVISO LEGAL: Este mensaje contiene información destinada exclusivamente al usuario de destino, pudiendo contener información confidencial o protegida legalmente. Si, por un error de envío o transmisión, ha recibido este mensaje y usted no es el destinatario del mismo, por favor, notifique de este hecho al remitente y no use, informe, distribuya, imprima, copie o difunda este mensaje bajo ningún medio . Cualquier opinión en él contenida, es exclusiva de su autor y no representa necesariamente la opinión de Quiter Servicios Centrales. LEGAL WARNING: This e-mail and any attachment, contain information intended solely for the addressee and may contain confidential information or legally protected data.
