469,366 Members | 2,198 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,366 developers. It's quick & easy.

Info on Oracle Replication

Amy
Hello All,

We are currently looking into archiving our production system. I have
looked into several different options to accomplish this, and Oracle
Replication is one of them.

Can anyone give me any info on Oracle Replication? We currently have
Oracle 8i, and it comes with the GUI interface Replication Manager,
which we would be using. We are running on a Windows environment. I
have read issues about having to monitor too closely after the fact,
deadlocks, etc.

We are looking to create a separate Oracle instance and dumping the
data in there. It would be read-only. We would want to automate the
updating and when the replication ran automatically, as it would be
changing. We don't know for sure yet if we would like this instance
to serve as a failsafe to the live system.

Any info or feedback would be greatly appreciated. I want to get a
better idea of how users and DBAs out there like this product, and if
it is manageable.

Thanks!!
Amy
Jul 19 '05 #1
1 2996
Hi ,

If you are looking for having second instance in Read-Only (which you
can use for Reporting Purpose ti isolate OLTP & DSS ) , you can go for
Standby Database as well. It automates all the things .
Check for Standby Database Feature for Oracle .

Hope it helps

Regards,
Mahesh Hardikar
ka*****@msn.com (Amy) wrote in message news:<74**************************@posting.google. com>...
Hello All,

We are currently looking into archiving our production system. I have
looked into several different options to accomplish this, and Oracle
Replication is one of them.

Can anyone give me any info on Oracle Replication? We currently have
Oracle 8i, and it comes with the GUI interface Replication Manager,
which we would be using. We are running on a Windows environment. I
have read issues about having to monitor too closely after the fact,
deadlocks, etc.

We are looking to create a separate Oracle instance and dumping the
data in there. It would be read-only. We would want to automate the
updating and when the replication ran automatically, as it would be
changing. We don't know for sure yet if we would like this instance
to serve as a failsafe to the live system.

Any info or feedback would be greatly appreciated. I want to get a
better idea of how users and DBAs out there like this product, and if
it is manageable.

Thanks!!
Amy

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Cherrish Vaidiyan | last post: by
reply views Thread by Cherrish Vaidiyan | last post: by
1 post views Thread by RYAN | last post: by
6 posts views Thread by shaun.mostashari | last post: by
1 post views Thread by Amy | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.