my consultant has designed a ha and back-up / dr strategy for me. i
have a 50 gb oracle 8i db running on a single windows 2k advanced
server.
he is recommending that
- set - up a microsoft windows server cluster in active - active mode
with another server and then run an oracle parallel failsafe on both
these. this should take care of the ha problem.
- move the database to archive log mode. currently it is not so.
- take a nightly hot back - up to a server within the same data
centre.
- multiplex the archivelogs and the control files to 3 diferent
servers so we can have 3 copies of these on different servers.
- take a weekly cold back - up to a server within the same data
centre. this is different than the one on which the nightly hot
back-ups are kept.
- use oracle dataguard to take a back-up and ship the archive logs to
a server within the same data centre. this server is different from the
ones on which the hot and cold back-ups are kept.
- use oracle dataguard to take a back-up and ship the archive logs
every 15 minutes to a server in a data centre about 1000 km away . this
can be done over the internet thru a vpn.
- do an export / import of the whole database to another server in the
data centre.
i have some questions on his recommendations.
- do i need to be doing all these things or is it an overkill? i do
have the necessary servers and the consultant tells me that i dont need
to pay oracle anything extra for all this.
my data is all financial data and it is very critical as in if i lose
it it will cause me a big financial loss.
- can i avoid the setting up of a windows cluster and still acheive the
ha part?
- will all this impact the performance which my users are getting ?
hey i know that was a long question but then so are my consultants
recommendations.
tia
vidyesh
Received on Thu Apr 21 2005 - 11:59:21 CDT