LOG-SHIPPING DATA REPLICATION WITH EARLY LOG RECORD FETCHING
    1.
    发明申请
    LOG-SHIPPING DATA REPLICATION WITH EARLY LOG RECORD FETCHING 有权
    使用早期日志记录进行日志传送数据复制

    公开(公告)号:US20120084260A1

    公开(公告)日:2012-04-05

    申请号:US12895644

    申请日:2010-09-30

    IPC分类号: G06F12/16 G06F17/30

    摘要: Methods, systems and program products for log-shipping data replication from a primary system to a communicatively-coupled standby system. Embodiments of the invention may receive transactional log data at a standby system, from the primary system, and before the transactional log data is written to storage on the primary system. Embodiments may then receive a notification from the primary system indicating that the corresponding log data was written to storage on the primary system, and responsive to receiving the notification, may process the received transactional log data.

    摘要翻译: 用于日志传送从主系统到通信耦合待机系统的数据复制的方法,系统和程序产品。 本发明的实施例可以在备用系统,主要系统和事务日志数据被写入主系统之间的存储器之前接收事务日志数据。 实施例然后可以从主系统接收指示对应的日志数据被写入主系统上的存储并且响应于接收到通知的通知可以处理所接收的事务日志数据。

    Consistent reintegration of a failed primary instance
    3.
    发明授权
    Consistent reintegration of a failed primary instance 失效
    失败的主要实例的一致重新整合

    公开(公告)号:US07499954B2

    公开(公告)日:2009-03-03

    申请号:US10978548

    申请日:2004-11-01

    IPC分类号: G06F17/30

    摘要: A method and system are provided for providing a consistent reintegration of a failed primary instance as a new secondary instance with implementation of truncation of log records. Upon failure of a primary instance, a secondary instance may be reassigned as the new primary instance. Prior to reintegration, any portion of the database log of the failed primary that is after the log position of the new primary instance may be truncated, followed by a comparison of the log positions of both the new primary instance and the new secondary instance. In limited circumstances, the truncation of the log data generated by the failed primary instance after the point of failure is possible, and supports reintegration of the failed primary as a new secondary instance with limited overhead.

    摘要翻译: 提供了一种方法和系统,用于将失败的主实例作为新的辅助实例提供一致的重新集成,并实现截断日志记录。 在主实例失败时,可以将辅助实例重新分配为新的主实例。 在重新集成之前,可能会截断新主要实例的日志位置之后的失败主数据库的任何部分,然后比较新的主实例和新的辅助实例的日志位置。 在有限的情况下,在故障点之后由失败的主实例生成的日志数据的截断是可能的,并且支持将故障主要重新集成为具有有限开销的新辅助实例。

    Log shipping data replication with parallel log writing and log shipping at the primary site
    4.
    发明授权
    Log shipping data replication with parallel log writing and log shipping at the primary site 失效
    在主站点上记录并行日志写入和日志传送的日志传送数据复制

    公开(公告)号:US07529783B2

    公开(公告)日:2009-05-05

    申请号:US11021002

    申请日:2004-12-22

    IPC分类号: G06F17/30

    摘要: A log-shipping data replication system employs a primary server coupled to a standby server. In operation, the primary server concurrently flushes log data at the primary server and transmits the same log data from the primary server to the standby server. The primary server further transmits at least one buffer flush boundary indication to the standby server indicating the flushing status of the log data at the primary server. The standby server processes the log data as a function of receiving the log data from the primary server, and/or receiving the at least one buffer flush boundary indication from the primary server.

    摘要翻译: 日志传送数据复制系统使用耦合到备用服务器的主服务器。 在运行时,主服务器同时刷新主服务器上的日志数据,并将相同的日志数据从主服务器发送到备用服务器。 主服务器还向备用服务器发送至少一个缓冲区清除边界指示,指示主服务器上日志数据的刷新状态。 备用服务器将日志数据作为从主服务器接收日志数据和/或从主服务器接收至少一个缓冲区清除边界指示的功能。

    ONLINE VERIFICATION OF A STANDBY DATABASE IN LOG SHIPPING PHYSICAL REPLICATION ENVIRONMENTS
    5.
    发明申请
    ONLINE VERIFICATION OF A STANDBY DATABASE IN LOG SHIPPING PHYSICAL REPLICATION ENVIRONMENTS 审中-公开
    日志中的STANDBY DATABASE在线验证物理复制环境的在线验证

    公开(公告)号:US20130198134A1

    公开(公告)日:2013-08-01

    申请号:US13360962

    申请日:2012-01-30

    IPC分类号: G06F7/00

    摘要: Techniques are disclosed for performing an operation for determining whether a standby database is synchronized with a primary database in a log shipping physical database replication environment. In one embodiment, the operation may include receiving a transaction log at the standby database from the primary database. The transaction log may specify a first one or more checksum values for a first set of pages on the primary database. The operation may also include calculating a second one or more checksum values for a second set of pages on the standby database. The operation may also include determining whether the standby database is synchronized with the primary database by comparing the first one or more checksum values with the second one or more checksum values.

    摘要翻译: 公开了用于执行用于确定备用数据库是否与日志传送物理数据库复制环境中的主数据库同步的操作的技术。 在一个实施例中,操作可以包括从主数据库在备用数据库处接收事务日志。 事务日志可以为主数据库上的第一组页面指定第一个或多个校验和值。 操作还可以包括为备用数据库上的第二组页计算第二个一个或多个校验和值。 该操作还可以包括通过将第一个或多个校验和值与第二个一个或多个校验和值进行比较来确定备用数据库是否与主数据库同步。

    Standby index in physical data replication
    6.
    发明授权
    Standby index in physical data replication 失效
    物理数据复制中的备用索引

    公开(公告)号:US08386462B2

    公开(公告)日:2013-02-26

    申请号:US12825264

    申请日:2010-06-28

    IPC分类号: G06F7/00

    摘要: Generating a standby index on a standby database server in a physical log-shipping data replication environment. Embodiments of the invention include providing a primary database server and a standby database server, replicating a primary database and a primary database index from the primary database server to the standby database server, generating a standby index on the standby database server, and cataloging the standby index on the standby database server.

    摘要翻译: 在物理日志传送数据复制环境中的备用数据库服务器上生成备用索引。 本发明的实施例包括提供主数据库服务器和备用数据库服务器,将主数据库和主数据库索引从主数据库服务器复制到备用数据库服务器,在备用数据库服务器上生成备用索引,以及对备用数据库进行编目 备份数据库服务器上的索引。

    Reducing likelihood of data loss during failovers in high-availability systems
    7.
    发明授权
    Reducing likelihood of data loss during failovers in high-availability systems 有权
    降低高可用性系统故障转移期间数据丢失的可能性

    公开(公告)号:US07669080B2

    公开(公告)日:2010-02-23

    申请号:US11839739

    申请日:2007-08-16

    IPC分类号: G06F11/00

    摘要: A method, system, and computer program product for reducing likelihood of data loss during performance of failovers in a high-availability system comprising a primary system and a standby system are provided. The method, system, and computer program product provide for defining a halt duration, periodically determining a halt end time, halting data modifications at the primary system responsive to failure of data replication to the standby system, resuming data modifications at the primary system responsive to a last determined halt end time being reached or data replication to the standby system resuming, and responsive to the primary system failing prior to a previously determined halt end time, determining that a failover to the standby system will not result in data loss on the standby system with respect to the primary system.

    摘要翻译: 提供了一种用于在包括主系统和备用系统的高可用性系统中执行故障转移期间减少数据丢失的可能性的方法,系统和计算机程序产品。 方法,系统和计算机程序产品提供定义停止持续时间,周期性地确定停止结束时间,停止主系统上的数据修改,以响应数据复制到备用系统的故障,响应于主系统恢复数据修改 达到最后确定的停止结束时间或恢复到备用系统的数据复制,并且响应于先前确定的停止结束时间之前的主系统故障,确定到备用系统的故障切换不会导致备用系统上的数据丢失 系统相对于主系统。

    Method for providing recovery from a failure in a system utilizing
distributed audit
    8.
    发明授权
    Method for providing recovery from a failure in a system utilizing distributed audit 失效
    使用分布式审计从系统故障中提供恢复的方法

    公开(公告)号:US5832203A

    公开(公告)日:1998-11-03

    申请号:US377381

    申请日:1995-01-23

    IPC分类号: G06F11/14 G06F11/00

    CPC分类号: G06F11/1471

    摘要: An improved recovery method utilizes sequence numbers to order log records and reduce the excess compensating actions due to a failure during recovery. Next undo records are written to the log after a preset number of compensating actions which include the sequence number of the record currently being scanned. After a failure, all records between the next undo record and the record having the sequence number included in the next undo record are ignored during when the log is scanned backwards.

    摘要翻译: 改进的恢复方法利用序列号来排序日志记录,并减少由于恢复期间的故障引起的多余的补偿动作。 在预设数量的补偿动作(包括当前正在扫描的记录的序列号)之后,下一个撤消记录将写入日志。 失败后,在向后扫描日志时,将忽略下一个撤销记录与下一个撤销记录中包含序列号的记录之间的所有记录。