The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Aug. 29, 2006
Filed:
Apr. 29, 2003
Matthew Albert Huras, Ajax, CA;
Dale Murray Mcinnis, Aurora, CA;
Effi Ofar, Thornhill, CA;
Michael Jeffrey Winer, Markham, CA;
Roger Lq. Zheng, Scarborough, CA;
Matthew Albert Huras, Ajax, CA;
Dale Murray McInnis, Aurora, CA;
Effi Ofar, Thornhill, CA;
Michael Jeffrey Winer, Markham, CA;
Roger LQ. Zheng, Scarborough, CA;
International Business Machines Corporation, Armonk, NY (US);
Abstract
A system and an associated method selectively process log files for enhancing performance of tablespace recovery by processing only those log files required, and for selecting which log file to process during recovery for both redo and rollback phases of recovery. The system and method skip the processing of log files that do not contain records of interest for the tablespace being recovered and determines whether a log file contains anything that needs to be played, in particular for the recovery of a subsystem in the database, such as a tablespace. Pre processing of the log files is not done, rather including tablespace ID correlated with log file ID information is collected while the log files are created. The cross-correlated information is used during tablespace recovery to selectively determine which of the log files to process. Some log files may be skipped in cases where not all of the database system is being recovered. A sub set of the database can be recovered, such as a tablespace, and which log files to process is determined based on a lock instruction.