公开(公告)号：US09268659B2

公开(公告)日：2016-02-23

申请号：US11326035

申请日：2006-01-05

申请人： Aditya Kapoor ,  Wenlu Ma ,  Craig G. Duncan

发明人： Aditya Kapoor ,  Wenlu Ma ,  Craig G. Duncan

IPC分类号： G06F17/00 ,  G06F11/20 ,  G06F11/14 ,  G06F17/30

CPC分类号： G06F11/2094 ,  G06F11/1458 ,  G06F17/30306

摘要： In one example, a method for detecting failover in a database mirroring system that begins when a determination is made as to the time of the most recent backup of the principal database. Next, the time of the most recent backup of the mirror database is determined. Then, the time of the most recent backup of the principal database is compared to the time of the most recent backup of the mirror database to determine if the principal database was backed up most recently. Finally, if the mirror database is the database that was backed up most recently, it is established that failover has occurred.

摘要翻译： 在一个示例中，一种用于检测数据库镜像系统中的故障切换的方法，该方法在对主体数据库的最新备份的时间进行确定时开始。 接下来，确定镜像数据库的最新备份的时间。 然后，将主体数据库的最新备份时间与镜像数据库的最新备份时间进行比较，以确定最近是否备份了主体数据库。 最后，如果镜像数据库是最近备份的数据库，则建立了故障转移已发生。

公开(公告)号：US07822717B2

公开(公告)日：2010-10-26

申请号：US11348982

申请日：2006-02-07

申请人： Aditya Kapoor ,  Wenlu Ma ,  Craig G. Duncan

发明人： Aditya Kapoor ,  Wenlu Ma ,  Craig G. Duncan

IPC分类号： G06F7/00 ,  G06F17/00

CPC分类号： G06F11/1471 ,  G06F11/1469 ,  G06F2201/80

摘要： This disclosure concerns systems and methods for restoring data. In one example, a method for restoring a database to a particular state begins when a query is sent to a backup server requesting a list of all backup versions for the database. Next, the list of all backup versions is received from the backup server. Then, the time t0 at which the most recent backup version in the list was created is determined. Next, a point in time t2 subsequent to time t0 is identified. Finally, a command set that, when executed, functions to restore the database to the state that existed at time t2 is automatically formulated.

摘要翻译： 本公开涉及恢复数据的系统和方法。 在一个示例中，将数据库恢复到特定状态的方法开始于将查询发送到请求数据库的所有备份版本列表的备份服务器。 接下来，从备份服务器接收到所有备份版本的列表。 然后，确定创建列表中最新备份版本的时间t0。 接下来，识别在时间t0之后的时间点t2。 最后，一个命令设置，当被执行时，将将数据库恢复到在时刻t2存在的状态的功能被自动表述。

公开(公告)号：US20070168401A1

公开(公告)日：2007-07-19

申请号：US11326079

申请日：2006-01-05

申请人： Aditya Kapoor ,  Wenlu Ma ,  Craig Duncan

发明人： Aditya Kapoor ,  Wenlu Ma ,  Craig Duncan

IPC分类号： G06F17/30

CPC分类号： G06F11/1451 ,  G06F11/1469 ,  G06F2201/80

摘要： This disclosure concerns systems and methods for restoring data. In one example, a method for piecemeal restoration of a database involves a computer system having a user interface and a selection device. The method begins when a query is sent to a database server application requesting a list of all offline filegroups for the database. Next, the list of all offline filegroups is received from the database server application. Then, the list of all offline filegroups is automatically presented on the user interface. Next, a list selection signal is received, indicative of the selection device designating one or more of the filegroups from the list. Finally, in response to the receipt of the list selection signal, a command is automatically formulated to bring the designated one or more filegroups online.

摘要翻译： 本公开涉及恢复数据的系统和方法。 在一个示例中，用于零碎地恢复数据库的方法涉及具有用户界面和选择装置的计算机系统。 当查询发送到请求数据库的所有脱机文件组的列表的数据库服务器应用程序时，该方法开始。 接下来，从数据库服务器应用程序接收到所有脱机文件组的列表。 然后，所有脱机文件组的列表将自动显示在用户界面上。 接下来，接收列表选择信号，指示选择装置从列表中指定一个或多个文件组。 最后，响应于接收到列表选择信号，自动地制定一个命令以使指定的一个或多个文件组联机。

公开(公告)号：US20070185922A1

公开(公告)日：2007-08-09

申请号：US11348982

申请日：2006-02-07

申请人： Aditya Kapoor ,  Wenlu Ma ,  Craig Duncan

发明人： Aditya Kapoor ,  Wenlu Ma ,  Craig Duncan

IPC分类号： G06F17/30

CPC分类号： G06F11/1471 ,  G06F11/1469 ,  G06F2201/80

摘要： This disclosure concerns systems and methods for restoring data. In one example, a method for restoring a database to a particular state begins when a query is sent to a backup server requesting a list of all backup versions for the database. Next, the list of all backup versions is received from the backup server. Then, the time t0 at which the most recent backup version in the list was created is determined. Next, a point in time t2 subsequent to time t0 is identified. Finally, a command set that, when executed, functions to restore the database to the state that existed at time t2 is automatically formulated.

摘要翻译： 本公开涉及恢复数据的系统和方法。 在一个示例中，将数据库恢复到特定状态的方法开始于将查询发送到请求数据库的所有备份版本列表的备份服务器。 接下来，从备份服务器接收到所有备份版本的列表。 然后，确定创建列表中最新备份版本的时间t <0> 。 接下来，识别时间t 0 0之后的时间点t 2 2 。 最后，一个命令集，当被执行时，将自动地拟定在时间t 2存在的状态恢复数据库的功能。

公开(公告)号：US07526514B2

公开(公告)日：2009-04-28

申请号：US11080229

申请日：2005-03-15

申请人： Mu Chai ,  Aditya Kapoor ,  Wenlu Ma ,  Craig Duncan

发明人： Mu Chai ,  Aditya Kapoor ,  Wenlu Ma ,  Craig Duncan

IPC分类号： G06F17/30

CPC分类号： G06F11/1464 ,  G06F11/2071 ,  G06F11/2082 ,  Y10S707/99952 ,  Y10S707/99955

摘要： In a computer network that includes database mirroring, a first database is located on a first database server and a second database is located on a second database server and, optionally, a witness database server. One of the first database or the second database is a live database while the other database is the mirror database. A process is initiated for communicating with the first database server, the second database server, or the witness database server, to determine which of the first database or the second database is the live database. The location of the live database is determined by reading information from the table entries in system databases on either the first or second database servers, or the optional witness database server, and a backup operation is performed wherein the live database is backed up.

摘要翻译： 在包括数据库镜像的计算机网络中，第一数据库位于第一数据库服务器上，而第二数据库位于第二数据库服务器和可选的证人数据库服务器上。 第一个数据库或第二个数据库之一是实时数据库，而另一个数据库是镜像数据库。 启动与第一数据库服务器，第二数据库服务器或证人数据库服务器进行通信的过程，以确定第一数据库或第二数据库中的哪一个是实时数据库。 通过从第一或第二数据库服务器或可选的见证数据库服务器上的系统数据库中的表条目读取信息来确定实时数据库的位置，并且执行备份操作，其中备份实时数据库。

公开(公告)号：US20070180289A1

公开(公告)日：2007-08-02

申请号：US11651971

申请日：2007-01-09

申请人： Mu Chai ,  Craig Duncan ,  Aditya Kapoor ,  Wenlu Ma

发明人： Mu Chai ,  Craig Duncan ,  Aditya Kapoor ,  Wenlu Ma

IPC分类号： G06F11/00

CPC分类号： G06F11/1469 ,  G06F11/1464 ,  G06F11/2071 ,  G06F11/2082 ,  G06F2201/80

摘要： In a network that includes a first database located on a first client and a second database located on a second client, a user or administrator initiates a restore operation. A dynamic mirror relationship existing between the first and second clients is terminated and a backup version of a database which the user or administrator wishes to recreate is identified. One of the first or second clients receives information concerning the location of the backup version of the database, as well as the role designation of the database at the time the backup operation was performed, from a restore server. The backup version of the database is retrieved from the storage location and recreated on each of the first and second clients, and the dynamic mirror relationship is reestablished between the first and second clients.

公开(公告)号：US20060149797A1

公开(公告)日：2006-07-06

申请号：US11080229

申请日：2005-03-15

申请人： Mu Chai ,  Aditya Kapoor ,  Wenlu Ma ,  Craig Duncan

发明人： Mu Chai ,  Aditya Kapoor ,  Wenlu Ma ,  Craig Duncan

IPC分类号： G06F12/00

CPC分类号： G06F11/1464 ,  G06F11/2071 ,  G06F11/2082 ,  Y10S707/99952 ,  Y10S707/99955

摘要： In a computer network that includes database mirroring, a first database is located on a first database server and a second database is located on a second database server and, optionally, a witness database server. One of the first database or the second database is a live database while the other database is the mirror database. A process is initiated for communicating with the first database server, the second database server, or the witness database server, to determine which of the first database or the second database is the live database. The location of the live database is determined by reading information from the table entries in system databases on either the first or second database servers, or the optional witness database server, and a backup operation is performed wherein the live database is backed up.

公开(公告)号：US07404103B2

公开(公告)日：2008-07-22

申请号：US11651971

申请日：2007-01-09

申请人： Mu Chai ,  Craig Duncan ,  Aditya Kapoor ,  Wenlu Ma

发明人： Mu Chai ,  Craig Duncan ,  Aditya Kapoor ,  Wenlu Ma

IPC分类号： G06F11/00

CPC分类号： G06F11/1469 ,  G06F11/1464 ,  G06F11/2071 ,  G06F11/2082 ,  G06F2201/80

摘要： In a network that includes a first database located on a first client and a second database located on a second client, a user or administrator initiates a restore operation. A dynamic mirror relationship existing between the first and second clients is terminated and a backup version of a database which the user or administrator wishes to recreate is identified. One of the first or second clients receives information concerning the location of the backup version of the database, as well as the role designation of the database at the time the backup operation was performed, from a restore server. The backup version of the database is retrieved from the storage location and recreated on each of the first and second clients, and the dynamic mirror relationship is reestablished between the first and second clients.

摘要翻译： 在包括位于第一客户端上的第一数据库和位于第二客户端上的第二数据库的网络中，用户或管理员启动还原操作。 终止在第一和第二客户端之间存在的动态镜像关系，并且识别用户或管理员希望重新创建的数据库的备份版本。 第一或第二客户端之一从恢复服务器接收关于数据库的备份版本的位置的信息以及在执行备份操作时数据库的角色指定。 从存储位置检索数据库的备份版本，并在第一和第二客户机中的每一个上重新创建，并且在第一和第二客户端之间重新建立动态镜像关系。

公开(公告)号：US20070156781A1

公开(公告)日：2007-07-05

申请号：US11326035

申请日：2006-01-05

申请人： Aditya Kapoor ,  Wenlu Ma ,  Craig Duncan

发明人： Aditya Kapoor ,  Wenlu Ma ,  Craig Duncan

IPC分类号： G06F17/30

CPC分类号： G06F11/2094 ,  G06F11/1458 ,  G06F17/30306

摘要： This disclosure is concerned with systems and methods for backing up data. In one example, a method for detecting failover in a database mirroring system that begins when a determination is made as to the time of the most recent backup of the principal database. Next, the time of the most recent backup of the mirror database is determined. Then, the time of the most recent backup of the principal database is compared to the time of the most recent backup of the mirror database to determine if the principal database was backed up most recently. Finally, if the mirror database is the database that was backed up most recently, it is established that failover has occurred.

摘要翻译： 本公开涉及用于备份数据的系统和方法。 在一个示例中，一种用于检测数据库镜像系统中的故障切换的方法，该方法在对主体数据库的最新备份的时间进行确定时开始。 接下来，确定镜像数据库的最新备份的时间。 然后，将主体数据库的最新备份时间与镜像数据库的最新备份时间进行比较，以确定最近是否备份了主体数据库。 最后，如果镜像数据库是最近备份的数据库，则建立了故障转移已发生。

公开(公告)号：US07210060B2

公开(公告)日：2007-04-24

申请号：US11080047

申请日：2005-03-15

申请人： Mu Chai ,  Craig Duncan ,  Aditya Kapoor ,  Wenlu Ma

发明人： Mu Chai ,  Craig Duncan ,  Aditya Kapoor ,  Wenlu Ma

IPC分类号： G06F11/00

CPC分类号： G06F11/1469 ,  G06F11/1464 ,  G06F11/2071 ,  G06F11/2082 ,  G06F2201/80

摘要： In a network that includes a first database located on a first client and a second database located on a second client, a user or administrator initiates a restore operation. A dynamic mirror relationship existing between the first and second clients is terminated and a backup version of a database which the user or administrator wishes to recreate is identified. One of the first or second clients receives information concerning the location of the backup version of the database, as well as the role designation of the database at the time the backup operation was performed, from a restore server. The backup version of the database is retrieved from the storage location and recreated on each of the first and second clients, and the dynamic mirror relationship is reestablished between the first and second clients.

摘要翻译： 在包括位于第一客户端上的第一数据库和位于第二客户端上的第二数据库的网络中，用户或管理员启动还原操作。 终止在第一和第二客户端之间存在的动态镜像关系，并且识别用户或管理员希望重新创建的数据库的备份版本。 第一或第二客户端之一从恢复服务器接收关于数据库的备份版本的位置的信息以及在执行备份操作时数据库的角色指定。 从存储位置检索数据库的备份版本，并在第一和第二客户机中的每一个上重新创建，并且在第一和第二客户端之间重新建立动态镜像关系。