-
Urgent: database is becoming inconsistent due to data service failure
I have one webservice in which i have done connection with oracle database
now suppose my webservice crashes due to power failure..it had submitted
some transactions say update on database;
now database is intact but my webservice failed..so locks are remaining on the database
now i create a new webservice, for recovering database. i am losing my previous long transaction (still not committed) because of power failure.
when transaction is executing if we do "alter system log switch", checkpoints
are taken..buffers are writted to disk..can these help me when after failure i am starting a new recovery service- My intension is i dont want to submit
whole transaction again...thru checkpoints i want to recovery transactions effect which i had submitted through my webservice(beacuse executing long
transaction from scratch takes too much time)..can checkpoint facility(inbuilt in oracle) help me solve this?
How?
thnx
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|