Hi all,
Can any of you suggest the configuration for a safe, fault proof, and minimum downtime Database environment? (In terms of how many servers, RAID or disk ARRAY or any combination. A minimum configuration is what I am looking for).
Right now we have one main server (Compaq proliant) and one standby database. But since the log switch takes place after about 10-15 minutes in the peak time and 30-40 minutes in not so peak time, plus our environment is 24x7, so if anything goes wrong with the production DB, it will take sometime to get back live and then some further time to catch up or redoing those entries which were lost because of no log witch. Hence even a downtime of few minutes brings the work to a halt plus any loss of data in between the archiving time is costly too.
So I want to suggest to our management a solution, which is as close to being fool-proof, if one server is down the other system can take its place in matters of minutes or seconds, and better if it is transparent to the user, or close.
Thanks & regards,
Hussain
