There are two databases DB1,DB2 situated at two different placessay pl1,pl2.people at place pl1 will access DB1 and for people at pl2 access DB2.Basically these two databases same date and that is acheived currently through (perl)scripts(of the web interface which write to both the databases at a time).It is bugged when one server is down no insert or update will work(according to scripts).
Now i have to make this system more redundent by finding a solution through oracle(involved as a DBA ).I need suggesion in how to tackle the situation such that give them more redundent solution...like how shall i proceed with....will parallel server (on distributed Db systems as they r physically located at different location) or will replication would be the solution in any case the DOWNTIME MUST BE ZERO AND IN THE DUE COURSE OF BRINGING UP THE FAILED SERVER STILL THE USERS SHOULD ACCESS THE DATABASE(THERE ARE 2 MILLION USERS).(am on sun OS)
quite urgent matter and looking for the help.and also ne one can explain how clustering in oralce occurs.
thanks,



[Edited by raaj on 06-15-2001 at 12:16 PM]