What to do with this situiation 2

Another situation - a critical issue on emergency plan.

In a client-server system, a client is committing a batch of records, say, 200, to an Oracle database (multiple tables perhaps) at the server. During the prcess, OOPS! the client's power is off! Only half of the records could be successfully committed. The user's just sitting there, shocked! Saying 'where have all the data gone...?'

When the power is on again, I don't think I could rollback all the records cos some of them has been committed.

But what to do with the rest of the 'committing' data? Would it disappear forever?
What should a system designer handle in design time? Does Oracle say anything about this?

Most important. Any good books covering this issue?

I'll be happy if anyone here could share ur experience :D

Thanx very very very much!

Thenard

--
********************************************************


***                                                  ***

***   ¦³°ÝÃD¶Ü¡H          Got a problem?             ***

***   §äªü´ö§a¡A          Just ask Thenardier,       ***

***   ¥L·|±N¥¦Åܦ¨¨aÃø¡I  he'll make it a tragedy!   ***


***                                                  ***

********************************************************