G
George Potemkin
Guest
Another idea: Progress could add new type of the block chains - a chain of the corrupted blocks. The fatal errors like 819 where Progress is unable to handle the changes of a block can move the block to this chain with creating the corresponding recovery note. So these errors will not even crash a database, it will stay online. Any attempts of the sessions to read a block on the chain of the corrupted blocks should result in the error. The fatal errors will not result in the lost of database (and its replicas). We will lose only one block inside a database instead of the whole database. In case of the 819 the block contained only the holder left after the record's fragment created by the same transaction that resulted in the 819 during undo. In other words, we will lose nothing if we will format the corrupted block. No downtime at all! No data lost (not guaranteed but very likely)!
Continue reading...
Continue reading...