[U2] UD hot backup/RFS options
We had a server crash 4pm yesterday (very unusual for IBM RS6000) and after guide/fixfile we had so much data corruption that a restore from previous days backup was needed. The question for the list is if anyone is successfully doing RFS or other incremental type backups? A quick google search shows a lot of people asking questions, but not a lot of it works great success stories. Looking to get a sense of real world usage before heading down that road, and potentially paying for consulting to implement. Any input, opinions, advice appreciated! Ian - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD hot backup/RFS options
We've been using RFS with Replication for years. Our entire DB is setup with RFS and is replicated, about 300GB. (AIX 7.1 UniData 7.2.13) The RFS Logs are on a separate set of RAID 10 Disks, and doesn't seem to add that much overhead although we are utilizing SSDs now. GUIDE Runs pretty fast 1hr. We run a triple mirror setup and split off the mirror nightly to backup. Any crashes (rare), RFS has been able to recover from. If needed we could run off of our DR System or copy the data back again (couple of hours). Ty Haller SEFCU Lead Administrator - System Services thal...@sefcu.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Friday, October 11, 2013 11:19 AM To: U2 Users List Subject: Re: [U2] UD hot backup/RFS options We have used it for about 15 years. I can remember the last time we crashed (Solaris). IF the redo logs look ok and the Unidata logs don't have issues, I don't run guide on our RFS files. We only have our largest files defined as RFS (10 gigabytes to almost 100 gigabytes). We did not put in the begin/end transaction statements in our code. So RFS uses a timing mechanism to figure out when to write data out. There is a performance difference, as you are doing extra i/o for each RFS read. But we can usually fully recover our site in a couple of hours. We are on Unidata 7.1 and hope to move to Unidata 7.2.13 soon. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of McGowan, Ian Sent: Friday, October 11, 2013 9:33 AM To: U2 Users List Subject: [U2] UD hot backup/RFS options We had a server crash 4pm yesterday (very unusual for IBM RS6000) and after guide/fixfile we had so much data corruption that a restore from previous days backup was needed. The question for the list is if anyone is successfully doing RFS or other incremental type backups? A quick google search shows a lot of people asking questions, but not a lot of it works great success stories. Looking to get a sense of real world usage before heading down that road, and potentially paying for consulting to implement. Any input, opinions, advice appreciated! Ian - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright (c) 2013 Cigna === === ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This message may contain confidential information and is intended for the sole purpose of communication with the addressee. Dissemination or publication in any format is strictly prohibited. If you have received this communication in error please notify SEFCU immediately. Help save a tree. Please print this e-mail only if it is truly necessary. Thank you. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD hot backup/RFS options
Thanks Ty and Rod. Good to hear RFS works well - perhaps the lack of google hits is because it Just Works (tm). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ty Haller Sent: Friday, October 11, 2013 8:28 AM To: U2 Users List Subject: Re: [U2] UD hot backup/RFS options We've been using RFS with Replication for years. Our entire DB is setup with RFS and is replicated, about 300GB. (AIX 7.1 UniData 7.2.13) The RFS Logs are on a separate set of RAID 10 Disks, and doesn't seem to add that much overhead although we are utilizing SSDs now. GUIDE Runs pretty fast 1hr. We run a triple mirror setup and split off the mirror nightly to backup. Any crashes (rare), RFS has been able to recover from. If needed we could run off of our DR System or copy the data back again (couple of hours). Ty Haller SEFCU Lead Administrator - System Services thal...@sefcu.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Friday, October 11, 2013 11:19 AM To: U2 Users List Subject: Re: [U2] UD hot backup/RFS options We have used it for about 15 years. I can remember the last time we crashed (Solaris). IF the redo logs look ok and the Unidata logs don't have issues, I don't run guide on our RFS files. We only have our largest files defined as RFS (10 gigabytes to almost 100 gigabytes). We did not put in the begin/end transaction statements in our code. So RFS uses a timing mechanism to figure out when to write data out. There is a performance difference, as you are doing extra i/o for each RFS read. But we can usually fully recover our site in a couple of hours. We are on Unidata 7.1 and hope to move to Unidata 7.2.13 soon. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of McGowan, Ian Sent: Friday, October 11, 2013 9:33 AM To: U2 Users List Subject: [U2] UD hot backup/RFS options We had a server crash 4pm yesterday (very unusual for IBM RS6000) and after guide/fixfile we had so much data corruption that a restore from previous days backup was needed. The question for the list is if anyone is successfully doing RFS or other incremental type backups? A quick google search shows a lot of people asking questions, but not a lot of it works great success stories. Looking to get a sense of real world usage before heading down that road, and potentially paying for consulting to implement. Any input, opinions, advice appreciated! Ian - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright (c) 2013 Cigna === === ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This message may contain confidential information and is intended for the sole purpose of communication with the addressee. Dissemination or publication in any format is strictly prohibited. If you have received this communication in error please notify SEFCU immediately. Help save a tree. Please print this e-mail only if it is truly necessary. Thank you. ___ 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