Using Replication for Backup [message #284979] |
Mon, 03 December 2007 01:10 |
jbohrmann
Messages: 5 Registered: December 2007
|
Junior Member |
|
|
Hi,
heres another Replication-Question. We have two ORACLE-Standard-Edition installations, one is installed on a maschine in our production department and one is installed on an central server. We want to replicate the data from the production-DB to the central server to backup the data on tape drives.
Is this possible using the feature of standard edition? Which way would be the best to implement that scenario?
Thanks in advance
Jens
|
|
|
|
Re: Using Replication for Backup [message #284996 is a reply to message #284979] |
Mon, 03 December 2007 01:40 |
jbohrmann
Messages: 5 Registered: December 2007
|
Junior Member |
|
|
Another question i have is concerning the materialized views, are they stored physically on the server i replicate them to so that i can backup and restore them? I have to archive the data that we capture and in case of a problem i need to take a look to the data after several years.
|
|
|
|
Re: Using Replication for Backup [message #285009 is a reply to message #285005] |
Mon, 03 December 2007 02:01 |
jbohrmann
Messages: 5 Registered: December 2007
|
Junior Member |
|
|
Besides the backup we need the data on the main-server because there are several applications that should access the data to analyse it and we also want the production system to be able to work even if the main-system is not available (in case of network-problems etc.).
|
|
|
|
|
|
|
Re: Using Replication for Backup [message #285552 is a reply to message #284979] |
Wed, 05 December 2007 00:47 |
jbohrmann
Messages: 5 Registered: December 2007
|
Junior Member |
|
|
The "central server" is the server where the most of our data is stored and that is accessed by many applications.
The "production server" is just needed to make the production independent of the availability of the "central server".
|
|
|