recovery data

gasomma

Member
Hello to All,

Pls need help.

There is a DB parameter to entry in order to recover last data inserted in the DB after system crash?
Progress 9.1d

Thx.
JCA
 
You don't say anything what happened.

A basic functionality of the Progress database is the crash recovery which will ensure that the database is consistent after a crash. There is no need to supply a parameter to invoke it, it will be done automatically when you access the database (start the database or single user access) as the first thing.

What crash recovery will do for you:
1. It will write all data changes from committed transactions that have not been written yet to the database files.
2. It will back out all data changes from uncommitted transactions that have already been written to the database files.

I am not aware of any possibility to recovery data changes from transactions that were active at the time your database crashed. Maybe others know.

HTH, RealHeavyDude.
 
Crash recovery recovers data that was committed before the crash. "In flight" transactions (transactions that were in process but not yet committed) are lost.

If the entire server crashed and the database is no longer accessible or has been corrupted then you need to restore from backup and roll forward the after-image logs. (After image logs should be archived to a separate server every X minutes so that you can recover from these sorts of situations...)
 
Back
Top