David,
To keep the database in synch you can use the Oracle archive logs or
snapshots and apply these to the backup/standby database periodically.
As long as you do not do any definition changes on your production
server I don't think server name reference would be an issue.
We had implemented something similar in a clustered environment. We had
Remedy installed on the primary and secondary nodes of the cluster and
Oracle installed on the SAN. Any issues on the Remedy side the
application would failover to the secondary node and the SAN disks that
hosted Oracle were mapped onto the secondary server. The failover time
used to be less than 3 minutes.
To answer your question on the database backup, we had a standby
database (with no Remedy install) that was remote and snapshots of the
changes from production were taken and applied every 30 minutes onto the
standby. There was a time when we had to resort to using the standby due
to a hardware failure on our production database infrastructure and it
took us approximately 15 minutes to be up and running by switching the
database in the ar.conf file to point to the standby (on both the nodes)
and our DBA opening the standby database to be read-write.
We were on ARS 512, Oracle 9i, HP-UX 11i.
Hope this is useful.
Regards,
Saby
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of David Koski
Sent: Friday, March 24, 2006 12:22 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARS/Oracle backup server
**
I guess I should have been a little clearer.
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 ???
Thanks
David
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe DeSouza
Sent: Friday, March 24, 2006 11:33 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARS/Oracle backup server
**
David,
If you do not mind spending a little on AR Server license, setting up a
load balance server would be a good option.
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.
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..
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..
Cheers
Joe D'Souza
Remedy Developer / Consultant,
Shyle Networks,
New Jersey.
David Koski wrote:
I'm interested to know what everyone is using for backups for
their systems.
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.
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.
Thanks
David
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
New Yahoo! Messenger with Voice.
/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!
20060125This posting was submitted with HTML in
it
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
Previous Topic
Index