Now requirement has changed , source database will be in read write mode and where as destination database will be read only mode, i know from 11g it is possible through active datagaurd, apart from active datagaurd is there any option availbale
Appreciated for the inputs
If you are using 11g Enterprise Edition, Oracle Active Dataguard feature will surely help you to achieve your requirement.
Read the below Oracle document to better understand the use of Oracle Active DataGuard
If you are on 10g version , then you dont have any other options rather than Oracle Goldengate or Oracle Streams replication