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 1 3218
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.go ogle.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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Cherrish Vaidiyan |
last post by:
Hello,
I have certain doubts regarding replication of Oracle 9i in Red Hat
Linux 9.
1) I want to implement asynchronous/synchronous multimaster
replication.I have heard about Replication Management Tool in OEM.
What are the steps to be taken initailly for using Replication
Management Tool ?
|
by: Cherrish Vaidiyan |
last post by:
Frank <fbortel@nescape.net> wrote in message news:<bqgb99$a04$1@news1.tilbu1.nb.home.nl>...
> Cherrish Vaidiyan wrote:
> > Hello,
> >
> > I have certain doubts regarding replication of Oracle 9i in Red Hat
> > Linux 9.
> >
> > 1) I want to implement asynchronous/synchronous multimaster
> > replication.I have heard about Replication...
|
by: Cherrish Vaidiyan |
last post by:
hello,
Thanx for replying to my earlier Google group query about Replication
of Oracle 9i on RH9.IF the query followed is being repeated by me I am
sorry for it..
I want to implement replication by means of SQL commamnd prompt.Can u
help me with the sample script that you own.I can change the schema,
tables according to my need...Here is...
|
by: Cherrish Vaidiyan |
last post by:
hello,
I am been getting mad with so many doubts and errors..
I have posted some doubts,test cases regarding listener,replication
and standby database.But i havent got any response..(I am sorry as
some of the queries i have posted twice).Is it that my doubt are funny
and simple for u gurus. I am just interested in Oracle on Linux . i...
|
by: Cherrish Vaidiyan |
last post by:
Sir,
I have implemented asynchronous replication on 2 database located in 2
different system. I did it with Replication Management GUI Tool.
Before explaining the error i will explain my replication environment.
The details of the systems are
Hostname1- node2 Hostname2- node3
ip address- 192.168.0.232 ...
| |
by: RYAN |
last post by:
Hi All,
I am new to Oracle and I have some question that I hope that someone out
there can help me.
I have heard the Oracle Rman can do replication of Archives logs. In this
way, one can setup some sort or Oracle Instances replication accross 2
machine at different sites.
1. Does amyone know how is the performance of this method of...
|
by: shaun.mostashari |
last post by:
Hello all, I am curious to know if anyone has done a trade study on
DB2, SQL Server, and Oracle databases. Basically I am trying to
identify which one to chose based on "Ease of implementation", Ease of
maintenance", "Pricing" and "Ease of technical support". The criteria
I am looking at can be obtained by interviewing people who have worked...
|
by: Rafael Faria |
last post by:
Hello All,
I'm new to DB2, so apologies in advance for any stupid comments I
might make on this replication problem.
Using Information integrator and DB2 8.2 I managed to create a
nickname that references a table sitting on an Oracle 10g Database on
a different server.
I can reference the nickname and retrieve all the information on that...
|
by: Amy |
last post by:
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...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |