System and method for minimizing data outage time and data loss while handling errors detected during recovery
    1.
    发明授权
    System and method for minimizing data outage time and data loss while handling errors detected during recovery 失效
    减少数据中断时间和数据丢失的系统和方法,同时处理在恢复期间检测到的错误

    公开(公告)号:US07552147B2

    公开(公告)日:2009-06-23

    申请号:US11219409

    申请日:2005-09-02

    IPC分类号: G06F17/30

    摘要: A system, method a computer usable storage medium tangibly embodying a program of instructions executable by the computer to perform a computer-based method for restoration of a database from a failed data recovery. For each failed data recovery the method generates a log error data set having log records of a faulty transaction unapplied to data due to inconsistency. Log error data set is directly useable by a log analysis tool to regenerate and redo the unapplied faulty transaction to recover the data and by a print log tool to diagnose the faulty transaction. Log records mimic format of records of an archive log data set and identify data objects, faulty transactions on the data objects and a range of the unapplied data objects' updates.

    摘要翻译: 一种系统,方法一种计算机可用存储介质,其有形地体现由计算机执行的指令程序,以执行基于计算机的方法,用于从故障数据恢复恢复数据库。 对于每个失败的数据恢复,该方法生成一个日志错误数据集,其中由于不一致性而导致的错误事务的日志记录未应用于数据。 日志错误数据集可以由日志分析工具直接使用,以重新生成并重做未应用的故障事务以恢复数据,并通过打印日志工具来诊断故障事务。 日志记录模拟存档日志数据集记录的格式,并识别数据对象,数据对象上的故障事务和一系列未应用的数据对象的更新。

    System for data structure loading with concurrent image copy
    2.
    发明授权
    System for data structure loading with concurrent image copy 失效
    用于并行映像副本的数据结构加载系统

    公开(公告)号:US6038569A

    公开(公告)日:2000-03-14

    申请号:US798532

    申请日:1997-02-10

    IPC分类号: G06F17/30

    摘要: Data is loaded to a data structure while an image copy of the data structure is concurrently formed. After data records are obtained from one or more data sources, each of the data records is associated with one of multiple pages. As each page is completed, it is written to a primary data structure. Also upon completion of each page in the primary data structure, concurrently with storage of the page in the primary data structure, an image copy of the page is made in an image copy data set. Partially or completely failed primary data structures may also be restored using image copies made according to the invention. Timestamps mark the time at which each page are made; image copy pages include the same timestamp as their respective primary pages. Upon detecting a data structure failure, each page of the image copy is sequentially reviewed. For each image page being reviewed, the page's timestamp is compared with the timestamp of the corresponding page from the primary data structure. The page is copied from the image copy to the primary data structure only if the timestamp comparison indicates that the image page is more recent than the page from the primary data structure.

    摘要翻译: 数据被加载到数据结构,同时形成数据结构的图像副本。 在从一个或多个数据源获得数据记录之后,每个数据记录与多个页面之一相关联。 当每个页面完成时,它被写入主数据结构。 此外,在主数据结构中的每个页面完成时,与主数据结构中的页面的存储同时,在图像复制数据集中进行页面的图像副本。 也可以使用根据本发明制造的图像副本来恢复部分或完全失败的主数据结构。 时间戳标记每个页面的时间; 图像复制页面包含与其各自的主页面相同的时间戳。 在检测到数据结构故障时,依次审查图像副本的每一页。 对于正在审核的每个图像页面,将页面的时间戳与主数据结构中相应页面的时间戳进行比较。 只有当时间戳比较指示图像页面比主数据结构中的页面更新时,页面才从图像副本复制到主数据结构。

    Recovering different types of objects with one pass of the log
    3.
    发明授权
    Recovering different types of objects with one pass of the log 失效
    通过一次记录恢复不同类型的对象

    公开(公告)号:US6119128A

    公开(公告)日:2000-09-12

    申请号:US50554

    申请日:1998-03-30

    IPC分类号: G06F12/00

    摘要: A method, apparatus, and article of manufacture for a computer implemented recovery system for restoring a database in a computer. The database contains objects and is stored on a primary data storage device connected to the computer. Objects of different types in the database are copied from the primary data storage device to a secondary data storage device. Modifications to the objects are logged in a log file. A recovery indicator is received that indicates that recovery of the objects in the database is required. The objects are copied from the secondary data storage device to the database on the primary data storage device. Modifications in the log file are applied to the copied objects during one pass through the log file.

    摘要翻译: 一种用于计算机实现的用于恢复计算机中的数据库的恢复系统的方法,装置和制品。 数据库包含对象,并存储在连接到计算机的主数据存储设备上。 数据库中不同类型的对象从主数据存储设备复制到辅助数据存储设备。 对象的修改记录在日志文件中。 接收到恢复指示符,表示需要恢复数据库中的对象。 这些对象从副数据存储设备复制到主数据存储设备上的数据库。 在通过日志文件的一次通过期间,日志文件中的修改将应用于复制的对象。