Offline Database management

[tim007]

[FONT=Arial][SIZE=2]Hi all,

I have a Client server application running on Oracle 10 G.

Issue is that the connection with server may get lost or disrupted, but it must not effect the system, so I need to suggest a system that would synchronise the data with the server once the connection is established with server.

So is there any way were can synchronise the data with server after a network downtime, using ORACLE.

or any other approach is required

Any suggestion / Advice

Thanks
Tim
[/SIZE][/FONT]

[amitpatel66]

First thing database needs to be UP and RUNNING for any application to communicate with the database

In case if the network goes down, and you lose database connection, you will need to refresh the application/session or restart the session in order to sync with the database server once the connection is reestablished.

[tim007]

Thanks Amith,
but the situation is we have a client machine, which often has network problems,
if Database connection is lost, we need a work around....Page cannot be refreshed as it would mean re-typing all the the data again... so we need something like storing the data into a different DB , and then once the connection is re-established sync the DB with servers.
so now I need something like this or a better approach

so i need a automated datasynchronisa tion ... does Oracle support that
Any suggestion ?

[amitpatel66]

You want another databse set at your client side which should be synched with the DB at server side?

[tim007]

Yes thats right Amith

When network is down Client Data store would be used

and When Network is back to normal then we need to synchronise the data between the Client Data Store and Server data base

Is there any way we could automate this process(data sync) using Oracle 10 g ?

[amitpatel66]

Do you think this will be feasible to have a database at client machine? Say if you have 100 machines at client side, you will need to install DB in all the client machines and all of them need to be synched with Server DB every time the network is UP. I dont think that having a DB at client side is a practical solution for network problems.