Method and apparatus for efficiently recovering from a failure in a database that includes unlogged objects
The present invention relates generally to data recovery in a database management system after an abnormal system termination and, more specifically, to a database management system recovery method and apparatus that does not use data recovery logging. Database tables which are to be loaded with lar...
Saved in:
| Main Authors | , , |
|---|---|
| Format | Patent |
| Language | English |
| Published |
20.05.2003
|
| Online Access | Get full text |
Cover
Loading…
| Summary: | The present invention relates generally to data recovery in a database management system after an abnormal system termination and, more specifically, to a database management system recovery method and apparatus that does not use data recovery logging.
Database tables which are to be loaded with large data objects (LOBs) are defined with a special logging attribute value. This attribute value causes the database management system to suspend recovery logging for the databases so defined, but to continue with the logging of control information, such as space management changes. Certain control information recovery log entries have a special status indicator. For LOBs, this status indicator is set to cause the associated LOB entry to be marked as invalid when the log entry is reapplied, for example, during a recovery operation from a media failure. Rather than invalidating the entire table, the database management system will only prevent access to the entries which have been invalidated during the recovery process. |
|---|