Re: How to backup incomming data?

Hi,

The best solution for what you described appears to be using one of the 
options available in Oracle Dataguard(9i) where in u can have multiple 
locations can be specificed with fail safe features.



Veerabhadra Rao
Oracle DBA (OCP 8,8i&9i)
404 202 1245(Mobile)





>From: "Victor Shvetsky" <[email protected]>
>Reply-To: "Oracle" <[email protected]>
>To: "Oracle" <[email protected]>
>Subject: [oracle] How to backup incomming data?
>Date: Thu, 23 Jan 2003 07:33:06
>
>Hi, I have a question that I could not find an answer to anywhere.
>
>I have a reporting server that writes data to Oracle Database via SQLNET.
>If that product fails, no data is written into DB.
>
>So, our client asked us if we could add an additional reporting server
>that would write the same data into DB. This way, if one reporting server
>fails, the second one would still write data into DB, therefore, we would
>not lose the data.
>
>The problem is that we need to merge the data, so that we do not have
>duplicate records. That does not sound too hard. The problem starts with
>the fact that some of the tables' unique keys are generated by the server,
>therefore, server A and server B would have two different unique keys for
>the record. Should we just use combination of other fields as a key to
>compare the records, or is there a better way?
>
>Does anyone know of a good way to do it?
>
>Thanks,
>Vic
>[email protected]
>---
>Change your mail options at http://p2p.wrox.com/manager.asp or
>to unsubscribe send a blank email to %%email.unsub%%.


_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.  
http://join.msn.com/?page=features/virus


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].