Hi everybody,

I need one help from u all. Let me tell u first I am working for one big company in India since last 10 year. I am working as a Project Manager and Oracle DBA. I am certified Oracle 8i and Oracle 9i DBA worked on SCO-UNIX, Linux and NT We have lot of branches in India. Because of some reason we could not centralized database at mumbai and now we are going to do that in short time. Currently all the databases r distributed and all the branches sent only imp data by email and we insert those into main database.

Our Development (full in house package) which we are using since last 7/8 years is working fine (we have upgraded with d2k 6i) with all the branches including operation and accounts. Now same we have to centralize. So management had decided that lets study same package from professional people. So we have already appointed some XYZ company to audit our system. We thought we will learn something professional things from them. But I think we got something really funny report. Lets not go in to deep level. I want to talk only on 1 point .



We have Oracle 9i Database server with Data Guard Architecture (Stand alone in 8i).We have around 10GB Not so much. We are planning to go for Real Application Cluster.



Now important point is xyz company DBA and functional manager who studied our package and database suggested (just in 15 days they took to study we call them professional) that u should use 2 different physical databases one for operation and 2nd for only accounts. As per my experience and my knowledge concern I am totally against it. I feel there will be some major disadvantages; I hope u will also contribute some so I can tell management those…


Thanks in advance.

Disadvantage: -


1) Database performance will degrade because every time application has to give two call to two separate databases.

2) Entire application will have to change, which is not so easy.

3) License will have to purchase for two servers O/S Linux as well as for Oracle databases.

4) Lots of Coding has to make for transferring data from 1 database to 2nd database, which will really create problems.

5) Operation data and Accounts data which is so important for any company will wont be flow online (Any program or report has to be based on 2 different server)

6) Changes made into operation database has to be made again into accounts, vise-versa

7) Both server required backup server (Data Guard) or if we go for RAC environment then again both server required more server which will have to maintain properly.

8) Disaster and Backup strategy have to implement properly for both server.

9) If any one operation or accounts (Production) server failed then entire application will come to halt till problem get solved.