Method, server, and computer readable medium for index recovery using index redo log

Abstract

According to some exemplary embodiments of the present disclosure, a method for index recovery performed by a database server is disclosed. The method is an index redo logging method performed by a database server. The method may include performing a first recovery step of determining, by an instruction for recovering via an index redo log comprising an index physical redo log and an index logical redo log, an index tree structure by applying the index physical redo log, wherein the index physical redo log is generated by first index redo logging corresponding to a change of the index tree structure; and performing a second recovery step of performing an index tree search on the determined index tree structure to obtain physical information of the index logical redo log, and applying the index logical redo log to the determined index tree structure using the obtained physical information, wherein the index logical redo log is generated by second index redo logging corresponding to a data change in the index or generated based on a table redo log by the instruction for recovering.