Unlock instant, AI-driven research and patent intelligence for your innovation.

Method and system for online verification of standby database in log shipping physical replication environment

A technology of physical replication and database, which is applied in the field of online verification and system of standby database in log shipping physical replication environment, and can solve the problems of inability to cover database and metadata pages.

Inactive Publication Date: 2017-04-26
INT BUSINESS MASCH CORP
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Some current validation methods cannot cover the entire database (without considerable user effort), and in no case cover metadata pages

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and system for online verification of standby database in log shipping physical replication environment
  • Method and system for online verification of standby database in log shipping physical replication environment
  • Method and system for online verification of standby database in log shipping physical replication environment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0013] Embodiments of the present invention provide techniques for validating a standby database in a log shipping physical replication environment while the standby database is online. In one embodiment, the application verifies the standby database against the primary database. In some embodiments, the application is part of a database management system (DBMS). Additionally, the application can be configured to generate transaction logs for pages in the primary database's tablespace. The transaction log contains checksum values ​​of the physical data representing each page of the database on the storage device. After generating logs for all pages in the tablespace, the application sends the transaction logs to the standby database. Those skilled in the art know that the standby database can be managed by the same DBMS as the primary database, by a different DBMS than the primary database, and can be located on the same physical computer as the primary database, or on a dif...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to an online verification method and system for a standby database in a log transfer physical replication environment. Techniques are disclosed for performing operations to determine whether a standby database is synchronized with a primary database in a log shipping physical database replication environment. In one embodiment, the operations include receiving, at the standby database, the transaction log from the primary database. The transaction log specifies one or more first checksum values ​​for a first set of pages on the primary database. The operations also include calculating one or more second checksum values ​​for the second set of pages on the standby database. The operations also include determining whether the standby database is synchronized with the primary database by comparing the one or more first checksum values ​​to the one or more second checksum values.

Description

Background technique [0001] A database is a computerized information storage and retrieval system. A database is operated by a database management system (DBMS) that implements various techniques for storing, retrieving and backing up data. Databases can utilize physical replication to keep backup (standby) copies up to date. This ensures that if there is a problem with the original copy (primary database), the standby database can assume the role of the primary database (take over) and use the current data for all database operations. Users typically require continuous access to their data, so replication facilitates minimal disruption. However, to ensure this protection, the standby database must be running and ready to take over at any time. [0002] Physically replicate to initially have two identical databases (either via disk-based replication, or via database backup and restore). From this point on, the databases are kept in sync by means of a non-stop transfer of t...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30G06F11/14G06F11/34
CPCG06F11/2038G06F11/2066G06F11/2069G06F11/2097G06F16/178G06F11/1446G06F11/1458G06F11/1471G06F16/275
Inventor P·奥克拉文卡特瓦拉A·I·汉纳G·N·金S·R·皮尔森
Owner INT BUSINESS MASCH CORP