Topic Options
Rate This Topic
#134177 - 03/23/06 01:27 PM ARS/Oracle backup server
dkoski Offline
newbie

Registered: 03/23/06
Posts: 0
I'm interested to know what everyone is using for backups for their systems.<br />I have 6.3 and Oracle 9i running in production with a second server setup to<br />deploy 6.3/Oracle 9i on a backup server. What is the easiest way to get the<br />records transferred over from the production to the backup system without<br />spending any further cash outlay? The current system is running on Solaris.<br />It doesn't have to be up to the split second but once a night minimum to a<br />couple of times a day update would be nice. I guess I'm looking for the<br />easiest most efficient way without increasing the budget to make sure the<br />servers are close to being in sync.<br /><br /> Thanks<br /><br /> David<br /><br /><br />UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org

Top
#134178 - 03/24/06 05:22 AM Re: ARS/Oracle backup server [Re: jfeirouz]
dkoski Offline
newbie

Registered: 03/23/06
Posts: 0
** <br /><br />I guess I should have been a little clearer.<br /><br /> <br /><br />Currently we have a primary and a backup server license. What I'm looking for is the easiest way to keep both those server in sync at least to within a day of one another (if not more). I'm not sure if the best way to do this is through oracle (How do we deal with server names inside ARS?), or ???<br /><br /> <br /><br /> Thanks<br /><br /> <br /><br /> David<br /><br /> <br /><br /><br /><br />From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe DeSouza<br />Sent: Friday, March 24, 2006 11:33 AM<br />To: arslist@ARSLIST.ORG<br />Subject: Re: ARS/Oracle backup server<br /><br /> <br /><br />** <br /><br /> <br /><br />David,<br /><br /> <br /><br />If you do not mind spending a little on AR Server license, setting up a load balance server would be a good option.<br /><br /> <br /><br />Then there is a hot backup server option available at half the cost of what you have spent on your licenses on the primary server.<br /><br /> <br /><br />Really depends on what your budget for this whole exercise is. I can't think of a solution where there will be absolutely no cost at all involved..<br /><br /> <br /><br />Even keeping a standby server with an image of the live server would involve hardware cost, cost of downtime between switching the server when the main server goes down as you would have to switch the NIC etc..<br /><br /> <br /><br />Cheers<br /><br /> <br /><br />Joe D'Souza<br /><br />Remedy Developer / Consultant,<br /><br />Shyle Networks,<br /><br />New Jersey.<br /><br />David Koski <dkoski@UMICH.EDU> wrote:<br /><br /> I'm interested to know what everyone is using for backups for their systems.<br /> I have 6.3 and Oracle 9i running in production with a second server setup to<br /> deploy 6.3/Oracle 9i on a backup server. What is the easiest way to get the<br /> records transferred over from the production to the backup system without<br /> spending any further cash outlay? The current system is running on Solaris.<br /> It doesn't have to be up to the split second but once a night minimum to a<br /> couple of times a day update would be nice. I guess I'm looking for the<br /> easiest most efficient way without increasing the budget to make sure the<br /> servers are close to being in sync.<br /> <br /> Thanks<br /> <br /> David<br /> <br /> <br /> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org<br /><br /> <br /><br /><br /><br />New Yahoo! Messenger with Voice. <http://us.rd.yahoo.com/mailus/taglines/postman4/*http:/us.rd.yahoo.com/evt=39666/*http:/beta.messenger.yahoo.com%0d%0a> Call regular phones from your PC for low, low rates. 20060125This posting was submitted with HTML in it !DSPAM:44241f4e59201264719043! <br /><br />20060125This posting was submitted with HTML in it <br />

Top
#134179 - 03/24/06 04:33 AM Re: ARS/Oracle backup server [Re: jfeirouz]
joe_remedy107 Offline
old hand

Registered: 06/28/04
Posts: 0
** <br /> <br />David,<br /> <br />If you do not mind spending a little on AR Server license, setting up a load balance server would be a good option.<br /> <br />Then there is a hot backup server option available at half the cost of what you have spent on your licenses on the primary server.<br /> <br />Really depends on what your budget for this whole exercise is. I can't think of a solution where there will be absolutely no cost at all involved..<br /> <br />Even keeping a standby server with an image of the live server would involve hardware cost, cost of downtime between switching the server when the main server goes down as you would have to switch the NIC etc..<br /> <br />Cheers<br /> <br />Joe D'Souza<br />Remedy Developer / Consultant,<br />Shyle Networks,<br />New Jersey.<br /><br />David Koski <dkoski@UMICH.EDU> wrote:<br /><br /> I'm interested to know what everyone is using for backups for their systems.<br /> I have 6.3 and Oracle 9i running in production with a second server setup to<br /> deploy 6.3/Oracle 9i on a backup server. What is the easiest way to get the<br /> records transferred over from the production to the backup system without<br /> spending any further cash outlay? The current system is running on Solaris.<br /> It doesn't have to be up to the split second but once a night minimum to a<br /> couple of times a day update would be nice. I guess I'm looking for the<br /> easiest most efficient way without increasing the budget to make sure the<br /> servers are close to being in sync.<br /> <br /> Thanks<br /> <br /> David<br /> <br /> <br /> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org<br /> <br /><br /><br /><br /><br />New Yahoo! Messenger with Voice. <http://us.rd.yahoo.com/mailus/taglines/postman4/*http://us.rd.yahoo.com/evt=39666/*http://beta.messenger.yahoo.com> Call regular phones from your PC for low, low rates. 20060125This posting was submitted with HTML in it<br />

Top
#134180 - 03/24/06 05:48 AM Re: ARS/Oracle backup server [Re: jfeirouz]
joe_remedy107 Offline
old hand

Registered: 06/28/04
Posts: 0
** <br /> <br />David,<br /> <br />I would think a remote database that is shared between the two servers would be the best solution as far as only Remedy is concerned.. there wouldn't be a need to sync data, and when one goes down the other picks up from where the other left...<br /> <br />As far as fail-over for the DB server itself is concerned there are ways to do it at DB level and that differs from DB to DB but the gist of it is consider a clustered environment for your DB... your DB admins are surely aware of those solutions and these should be pretty transparent to the Remedy server or its connectivity...<br /> <br />Cheers<br /> <br />Joe D'Souza<br />Remedy Developer / Consultant,<br />Shyle Networks,<br />New Jersey.<br /><br />David Koski <dkoski@UMICH.EDU> wrote:<br /><br /> ** <br /> I guess I should have been a little clearer.<br /> <br /> Currently we have a primary and a backup server license. What Iím looking for is the easiest way to keep both those server in sync at least to within a day of one another (if not more). Iím not sure if the best way to do this is through oracle (How do we deal with server names inside ARS?), or ???<br /> <br /> Thanks<br /> <br /> David<br /> <br /> <br /><br /><br /> From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe DeSouza<br /> Sent: Friday, March 24, 2006 11:33 AM<br /> To: arslist@ARSLIST.ORG<br /> Subject: Re: ARS/Oracle backup server<br /> <br /> ** <br /> <br /> David,<br /> <br /> If you do not mind spending a little on AR Server license, setting up a load balance server would be a good option.<br /> <br /> Then there is a hot backup server option available at half the cost of what you have spent on your licenses on the primary server.<br /> <br /> Really depends on what your budget for this whole exercise is. I can't think of a solution where there will be absolutely no cost at all involved..<br /> <br /> Even keeping a standby server with an image of the live server would involve hardware cost, cost of downtime between switching the server when the main server goes down as you would have to switch the NIC etc..<br /> <br /> Cheers<br /> <br /> Joe D'Souza<br /> Remedy Developer / Consultant,<br /> Shyle Networks,<br /> New Jersey.<br /> <br /> David Koski <dkoski@UMICH.EDU> wrote:<br /><br /> I'm interested to know what everyone is using for backups for their systems.<br /> I have 6.3 and Oracle 9i running in production with a second server setup to deploy 6.3/Oracle 9i on a backup server. What is the easiest way to get the records transferred over from the production to the backup system without spending any further cash outlay? The current system is running on Solaris.<br /> It doesn't have to be up to the split second but once a night minimum to a couple of times a day update would be nice. I guess I'm looking for the easiest most efficient way without increasing the budget to make sure the servers are close to being in sync.<br /> <br /> Thanks<br /> <br /> David<br /><br /><br /><br />Yahoo! Messenger with Voice. Make PC-to-Phone Calls <http://us.rd.yahoo.com/mailus/taglines/postman1/*http://us.rd.yahoo.com/evt=39663/*http://voice.yahoo.com> to the US (and 30+ countries) for 2Ę/min or less. 20060125This posting was submitted with HTML in it<br />

Top
#134181 - 03/24/06 06:00 AM Re: ARS/Oracle backup server [Re: jfeirouz]
srfernandes Offline
newbie

Registered: 03/23/06
Posts: 0
David,<br /><br />To keep the database in synch you can use the Oracle archive logs or<br />snapshots and apply these to the backup/standby database periodically.<br />As long as you do not do any definition changes on your production<br />server I don't think server name reference would be an issue.<br /><br />We had implemented something similar in a clustered environment. We had<br />Remedy installed on the primary and secondary nodes of the cluster and<br />Oracle installed on the SAN. Any issues on the Remedy side the<br />application would failover to the secondary node and the SAN disks that<br />hosted Oracle were mapped onto the secondary server. The failover time<br />used to be less than 3 minutes. <br /><br />To answer your question on the database backup, we had a standby<br />database (with no Remedy install) that was remote and snapshots of the<br />changes from production were taken and applied every 30 minutes onto the<br />standby. There was a time when we had to resort to using the standby due<br />to a hardware failure on our production database infrastructure and it<br />took us approximately 15 minutes to be up and running by switching the<br />database in the ar.conf file to point to the standby (on both the nodes)<br />and our DBA opening the standby database to be read-write.<br /><br />We were on ARS 512, Oracle 9i, HP-UX 11i.<br /><br />Hope this is useful.<br /><br />Regards,<br />Saby<br /><br /><br /><br /><br />-----Original Message-----<br />From: Action Request System discussion list(ARSList)<br />[mailto:arslist@ARSLIST.ORG] On Behalf Of David Koski<br />Sent: Friday, March 24, 2006 12:22 PM<br />To: arslist@ARSLIST.ORG<br />Subject: Re: ARS/Oracle backup server<br /><br />** <br /><br />I guess I should have been a little clearer.<br /><br /> <br /><br />Currently we have a primary and a backup server license. What I'm<br />looking for is the easiest way to keep both those server in sync at<br />least to within a day of one another (if not more). I'm not sure if the<br />best way to do this is through oracle (How do we deal with server names<br />inside ARS?), or ???<br /><br /> <br /><br /> Thanks<br /><br /> <br /><br /> David<br /><br /> <br /><br /><br /><br />From: Action Request System discussion list(ARSList)<br />[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe DeSouza<br />Sent: Friday, March 24, 2006 11:33 AM<br />To: arslist@ARSLIST.ORG<br />Subject: Re: ARS/Oracle backup server<br /><br /> <br /><br />** <br /><br /> <br /><br />David,<br /><br /> <br /><br />If you do not mind spending a little on AR Server license, setting up a<br />load balance server would be a good option.<br /><br /> <br /><br />Then there is a hot backup server option available at half the cost of<br />what you have spent on your licenses on the primary server.<br /><br /> <br /><br />Really depends on what your budget for this whole exercise is. I can't<br />think of a solution where there will be absolutely no cost at all<br />involved..<br /><br /> <br /><br />Even keeping a standby server with an image of the live server would<br />involve hardware cost, cost of downtime between switching the server<br />when the main server goes down as you would have to switch the NIC etc..<br /><br /> <br /><br />Cheers<br /><br /> <br /><br />Joe D'Souza<br /><br />Remedy Developer / Consultant,<br /><br />Shyle Networks,<br /><br />New Jersey.<br /><br />David Koski <dkoski@UMICH.EDU> wrote:<br /><br /> I'm interested to know what everyone is using for backups for<br />their systems.<br /> I have 6.3 and Oracle 9i running in production with a second<br />server setup to<br /> deploy 6.3/Oracle 9i on a backup server. What is the easiest way<br />to get the<br /> records transferred over from the production to the backup<br />system without<br /> spending any further cash outlay? The current system is running<br />on Solaris.<br /> It doesn't have to be up to the split second but once a night<br />minimum to a<br /> couple of times a day update would be nice. I guess I'm looking<br />for the<br /> easiest most efficient way without increasing the budget to make<br />sure the<br /> servers are close to being in sync.<br /> <br /> Thanks<br /> <br /> David<br /> <br /> <br /><br /><br /> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org<br /><br /> <br /><br /><br /><br />New Yahoo! Messenger with Voice.<br /><http://us.rd.yahoo.com/mailus/taglines/postman4/*http:/us.rd.yahoo.com<br />/evt=39666/*http:/beta.messenger.yahoo.com%0d%0a> Call regular phones<br />from your PC for low, low rates. 20060125This<br />posting was submitted with HTML in it !DSPAM:44241f4e59201264719043! <br /><br />20060125This posting was submitted with HTML in<br />it <br /><br /><br />UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org

Top