公开(公告)号：US08818943B1

公开(公告)日：2014-08-26

申请号：US13107900

申请日：2011-05-14

申请人： Matthew C. McCline ,  Milena Bergant

发明人： Matthew C. McCline ,  Milena Bergant

IPC分类号： G06F17/30

CPC分类号： G06F17/30581 ,  G06F17/30575

摘要： In a mirrored database system, mirror resynchronization of fixed length pages is optimized for quick repair and high availability by identifying those lost page changes that must be made for resynchronization and ignoring other duplicate changes. Essential pages are identified using log sequence numbers (LSNs) to locate the most current version of a changed page, and other lower valued LSNs of less current versions of that page are eliminated as having changes that are duplicated in the current version of the page. Page changes since the last database checkpoint before losing mirror synchronization and the current LSN of the transaction log are identified as possibly necessary changes to be made.

摘要翻译： 在镜像数据库系统中，固定长度页面的镜像重新同步通过识别必须为重新同步而忽略其他重复更改的丢失页面更改而进行优化，从而实现快速修复和高可用性。 使用日志序列号（LSN）来标识基本页面以定位更改的页面的最新版本，并且删除该页面的较小当前版本的其他较低值的LSN，因为在当前版本的页面中具有重复的更改。 丢失镜像同步之前的最后一个数据库检查点的页面更改和事务日志的当前LSN被标识为可能需要进行的更改。

公开(公告)号：US08751443B1

公开(公告)日：2014-06-10

申请号：US13107922

申请日：2011-05-15

申请人： Matthew C. McCline ,  Milena Bergant

发明人： Matthew C. McCline ,  Milena Bergant

IPC分类号： G06F17/30

CPC分类号： G06F17/30581 ,  G06F17/30575

摘要： In a mirrored database system, good quality of service and high availability is afforded by minimizing the time required for suspension of operations to transition between mirror states, and by keeping track of changes made to a primary database while the mirror database was out of communications so that a later mirror resynchronization process can quickly catch up the mirror database by making only the lost changes.

摘要翻译： 在镜像数据库系统中，通过最小化停止操作在镜像状态之间转换所需的时间，以及在镜像数据库超出通信时跟踪对主数据库所做的更改，可以提供良好的服务质量和高可用性。 稍后的镜像重新同步过程可以通过仅进行丢失的更改来迅速赶上镜像数据库。

公开(公告)号：US08667033B1

公开(公告)日：2014-03-04

申请号：US13107898

申请日：2011-05-14

申请人： Matthew C. McCline ,  Milena Bergant

发明人： Matthew C. McCline ,  Milena Bergant

IPC分类号： G06F12/00 ,  G06F17/30

CPC分类号： G06F17/30117 ,  G06F17/30312

摘要： In a mirrored database system, a careful write of intentions to perform file system actions is recorded in a persistent file system objects table that is flushed to disk prior to the actions being taken. The table durably and accurately records identities of file system objects that were in use by the database to facilitate creation and deletion of physical file directories and files on a database during crash recovery and during mirror resynchronize. In the event of a failure, crash recovery may quickly and easily identify file system objects which need to be cleaned up by reference to the persistent file system objects table. Similarly, resynchronization of the mirror database can be performed quickly by referring to the persistent file system table data to detect changes since the last database checkpoint.

摘要翻译： 在镜像数据库系统中，仔细写入执行文件系统操作的意图将记录在持久性文件系统对象表中，在执行操作之前刷新到磁盘。 该表能够持久，准确地记录数据库正在使用的文件系统对象的身份，以便在崩溃恢复期间和镜像重新同步期间便于在数据库上创建和删除物理文件目录和文件。 在发生故障的情况下，崩溃恢复可能会快速轻松地识别需要通过引用持久性文件系统对象表来清理的文件系统对象。 类似地，可以通过参考持久文件系统表数据来快速执行镜像数据库的重新同步，以检测自上一个数据库检查点以来的变化。

公开(公告)号：US08818954B1

公开(公告)日：2014-08-26

申请号：US13077935

申请日：2011-03-31

申请人： Milena Bergant ,  Matthew C. McCline ,  Alon Goldshuv

发明人： Milena Bergant ,  Matthew C. McCline ,  Alon Goldshuv

IPC分类号： G06F17/30

CPC分类号： G06F11/2074 ,  G06F2201/80

摘要： A method, article of manufacture, and apparatus for recovering databases. In some embodiments, this includes switching an active segment to change tracking mode, intercepting write related changes on the active segment while in the change tracking mode, populating a change tracking log based on the intercepted write related changes, and storing the populated change tracking log in a storage device. In some embodiments, the storage device is memory. In some embodiments, the change tracking log if flushed from memory to disk.

摘要翻译： 一种用于恢复数据库的方法，制品和装置。 在一些实施例中，这包括切换活动段以改变跟踪模式，在变化跟踪模式下拦截活动段上的写入相关变化，基于所截获的与写入相关的改变填充变化跟踪日志，以及存储填充的变化跟踪日志 在存储设备中。 在一些实施例中，存储设备是存储器。 在一些实施例中，改变跟踪日志如果从存储器刷新到磁盘。

公开(公告)号：US08938429B1

公开(公告)日：2015-01-20

申请号：US13077939

申请日：2011-03-31

申请人： Milena Bergant ,  Matthew C. McCline ,  Alon Goldshuv

发明人： Milena Bergant ,  Matthew C. McCline ,  Alon Goldshuv

IPC分类号： G06F17/30

CPC分类号： G06F11/1662 ,  G06F11/2094 ,  G06F2201/80

摘要： A method, article of manufacture, and apparatus for recovering databases. In some embodiments, this includes switching an active segment to a resynchronization mode, receiving a change tracking log, determining a data block based on the change tracking log, and resynchronizing the determined data block with a non-active segment. In some embodiments, writes performed on the active segment are synchronized with the non-active segment.

摘要翻译： 一种用于恢复数据库的方法，制品和装置。 在一些实施例中，这包括将活动段切换到重新同步模式，接收改变跟踪日志，基于变化跟踪日志确定数据块，以及使用非活动段重新同步所确定的数据块。 在一些实施例中，对活动段执行的写入与非活动段同步。

公开(公告)号：US08799216B1

公开(公告)日：2014-08-05

申请号：US13107902

申请日：2011-05-14

申请人： Matthew C. McCline ,  Milena Bergant

发明人： Matthew C. McCline ,  Milena Bergant

IPC分类号： G06F17/30

CPC分类号： G06F17/30592 ,  G06F17/30371 ,  G06F17/30575

摘要： In a mirrored database system, mirror resynchronization of bulk load and append-only tables during ongoing transactions is optimized for quick repair and high availability by catching up any changes to primary database tables that have not been made to mirror database tables during the transaction itself, and making changes due to ongoing transactions when the databases are synchronized to the resynchronization process.

摘要翻译： 在镜像的数据库系统中，正在进行的事务中的大容量加载和仅追加表的镜像重新同步被优化，以便通过在事务本身期间对未进行镜像数据库表的主数据库表的任何更改进行快速修复和高可用性， 并且当数据库同步到重新同步过程时，由于正在进行的事务而进行更改。

公开(公告)号：US08775381B1

公开(公告)日：2014-07-08

申请号：US13107897

申请日：2011-05-14

申请人： Matthew C. McCline ,  Milena Bergant

发明人： Matthew C. McCline ,  Milena Bergant

IPC分类号： G06F17/30

CPC分类号： G06F17/30581 ,  G06F17/30368 ,  G06F17/3038 ,  G06F17/30578

摘要： In a database cluster comprising a plurality of mirrored database segments, a mirror database pair comprising a primary database and a mirror database are maintained substantially consistent by writing changes resulting from transactions to page data in parallel to the primary database and to the mirror database. Changes are sent to the mirror database over a network using network communications. Transaction logs are also written to the primary and mirrored databases in parallel, the transaction logs being sent to the mirror database using network communications. Bulk load changes resulting from transactions are written in parallel over the network to the primary database and the mirror database without writing the changes to a transaction log. In the event of a failure, resynchronization of the mirror database can be performed quickly while avoiding a lengthy ongoing redo process on the mirror database.

摘要翻译： 在包括多个镜像数据库段的数据库集群中，包括主数据库和镜像数据库的镜像数据库对通过将事务产生的更改并行地写入主数据库和镜像数据库而保持基本一致。 通过使用网络通信的网络将更改发送到镜像数据库。 事务日志也并行写入主镜像数据库和镜像数据库，事务日志使用网络通信发送到镜像数据库。 事务所产生的大容量负载更改将通过网络并行写入主数据库和镜像数据库，而无需将更改写入事务日志。 在发生故障的情况下，可以快速执行镜像数据库的重新同步，同时避免在镜像数据库上进行漫长的重做过程。

公开(公告)号：US20080155316A1

公开(公告)日：2008-06-26

申请号：US11538554

申请日：2006-10-04

申请人： Sitaram Pawar ,  Jean Pierre Bono ,  Milena Bergant ,  Ajay S. Potnis ,  Ashwin B. Agrawal

发明人： Sitaram Pawar ,  Jean Pierre Bono ,  Milena Bergant ,  Ajay S. Potnis ,  Ashwin B. Agrawal

IPC分类号： G06F11/00

CPC分类号： G06F11/1435 ,  G06F11/1076 ,  G06F11/2094 ,  G06F2211/1088

摘要： File systems possibly impacted by a bad sector in a disk drive are unmounted. Then the disk drive is scanned in order to identify additional bad sectors, and for each identified bad sector, a logical address of the bad sector is re-vectored to a good sector. An attempt is made to restore the data of each bad sector, and then the file system is checked for consistency. If a bad sector cannot be restored, any application relying on the bad sector is aborted. Once the file system is found to be consistent, the file system is remounted. Re-vectored blocks are reverse mapped to identify damaged or repaired directories and files. Damaged or repaired directories and files are reported to a system administrator, and damaged directories or files of a client are reported to the client.

摘要翻译： 可能会受到磁盘驱动器中坏扇区影响的文件系统的卸载。 然后扫描磁盘驱动器以识别其他坏扇区，并且对于每个识别的坏扇区，坏扇区的逻辑地址被重新映射到良好扇区。 尝试恢复每个坏扇区的数据，然后检查文件系统的一致性。 如果坏扇区无法恢复，任何依赖坏扇区的应用程序都将中止。 一旦发现文件系统一致，就重新安装文件系统。 重新定向的块被反向映射以识别损坏或修复的目录和文件。 损坏或修复的目录和文件被报告给系统管理员，并且向客户端报告客户端损坏的目录或文件。

公开(公告)号：US06934822B2

公开(公告)日：2005-08-23

申请号：US10213242

申请日：2002-08-06

申请人： Philippe Armangau ,  Milena Bergant ,  Hongmei Wang ,  Ajay S. Potnis ,  Raymond A. Angelone

发明人： Philippe Armangau ,  Milena Bergant ,  Hongmei Wang ,  Ajay S. Potnis ,  Raymond A. Angelone

IPC分类号： G06F17/30 ,  G08F12/00

CPC分类号： G06F11/1435 ,  G06F11/1458 ,  G06F11/1469 ,  G06F17/30097 ,  G06F2201/84 ,  Y10S707/99952

摘要： A file server maintains a production file system supported by a clone volume, and multiple snapshot file systems supported by respective save volumes in a snapshot queue. Before a data block is modified for the first time after creation of the youngest snapshot, the data block is copied from the clone volume to the save volume of the youngest snapshot. A bit map indicates the blocks that have already been copied, and a block map shows the save block address for each corresponding clone block address. When a new snapshot is created, the bit and block maps are converted to a hash index that is kept linked to the save volume of what had been the youngest snapshot. When other than the oldest snapshot file system is deleted, the respective save volume is retained as a hidden object until it becomes the oldest save volume.

摘要翻译： 文件服务器维护克隆卷支持的生产文件系统，以及快照队列中相应保存卷支持的多个快照文件系统。 在创建最小的快照之后首次修改数据块之前，将数据块从克隆卷复制到最小快照的保存卷。 位图表示已复制的块，块图显示每个对应的克隆块地址的保存块地址。 当创建新的快照时，位和块映射将转换为哈希索引，该索引保持与已保存的最新快照的保存卷相关联。 当除了最旧的快照文件系统之外，相应的保存卷将保留为隐藏对象，直到它成为最早的保存卷。

公开(公告)号：US20050015663A1

公开(公告)日：2005-01-20

申请号：US10603951

申请日：2003-06-25

申请人： Philippe Armangau ,  Milena Bergant ,  Karthikeyan Srinivasan

发明人： Philippe Armangau ,  Milena Bergant ,  Karthikeyan Srinivasan

IPC分类号： G06F11/20 ,  H02H3/05

CPC分类号： G06F11/2082 ,  G06F11/2064 ,  G06F11/2069 ,  G06F11/2074 ,  G06F2201/84 ,  H04L67/1095 ,  H04L69/40 ,  Y10S707/99953

摘要： In an asynchronous remote copy system, a primary site keeps a list of data blocks for which changes have been made to a primary file system and transmitted to a secondary file system at a secondary site. When the primary site becomes inoperative, the secondary site begins read/write access to the secondary file system and keeps a snapshot copy of the restart point. Once the primary site becomes operative, the primary file system is restored to the state of the secondary file system at the restart point by using the list of data blocks for obtaining from the snapshot copy the data of the blocks for which changes had been made to the primary file system after the restart point. Then the primary file system is synchronized to the secondary file system, and read/write access is switched back from the secondary file system to the primary file system.

摘要翻译： 在异步远程复制系统中，主站点保留对主文件系统进行了更改的数据块列表，并将其发送到辅助站点的辅助文件系统。 当主站点不起作用时，辅助站点开始对辅助文件系统的读/写访问，并保存重新启动点的快照副本。 一旦主站点变得可操作，主文件系统将通过使用数据块的列表恢复到重新启动点的辅助文件系统的状态，从快照副本获取已更改的块的数据 主文件系统重启点后。 然后，主文件系统与辅助文件系统同步，读/写访问从辅助文件系统切换回主文件系统。