Determining whether a standby database is synchronized with a primary database

Determining whether a standby database is synchronized with a primary database

A method for performing an operation for determining whether a standby database is synchronized with a primary database in a log shipping physical database replication environment is disclosed. In operation a transaction log specifying on one or more checksum values for a first set of pages on the p...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: GARY NANHAO JIN, STEVEN ROBERT PEARSON, PRASADARAO AKULAVENKATAVARA, AARON ISRAEL HENNER
Format: Patent
Sprache:eng
Schlagworte:
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
container_end_page
container_issue
container_start_page
container_title
container_volume
creator GARY NANHAO JIN
STEVEN ROBERT PEARSON
PRASADARAO AKULAVENKATAVARA
AARON ISRAEL HENNER
description A method for performing an operation for determining whether a standby database is synchronized with a primary database in a log shipping physical database replication environment is disclosed. In operation a transaction log specifying on one or more checksum values for a first set of pages on the primary database. A second one or more checksum values for a second set of pages on the standby database is calculated. The checksums are compared to determine whether the standby database is synchronized with the primary database. If the checksum values match the primary and standby databases are synchronized. If they do not match the databases are not synchronized and an alert is generated. In preparing the second checksum a self consistency check may also be run on the standby database.
format Patent
fullrecord <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_GB2500085A</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>GB2500085A</sourcerecordid><originalsourceid>FETCH-epo_espacenet_GB2500085A3</originalsourceid><addsrcrecordid>eNqFyr0KwkAMAOBbHER9BvMCwqEUXP1tJyf3kvZiL2DT4xIo9el1EBydvuWbu9uZjHLPwtLBGMkiZUBQQwnNBAENG1QCVtBJ2pgH4RcFGNni56XMPebfW7rZA59Kq68Lt75e7qdqQ2moSRO2JGR1edwW3vt9cdj9H29d9TXT</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Determining whether a standby database is synchronized with a primary database</title><source>esp@cenet</source><creator>GARY NANHAO JIN ; STEVEN ROBERT PEARSON ; PRASADARAO AKULAVENKATAVARA ; AARON ISRAEL HENNER</creator><creatorcontrib>GARY NANHAO JIN ; STEVEN ROBERT PEARSON ; PRASADARAO AKULAVENKATAVARA ; AARON ISRAEL HENNER</creatorcontrib><description>A method for performing an operation for determining whether a standby database is synchronized with a primary database in a log shipping physical database replication environment is disclosed. In operation a transaction log specifying on one or more checksum values for a first set of pages on the primary database. A second one or more checksum values for a second set of pages on the standby database is calculated. The checksums are compared to determine whether the standby database is synchronized with the primary database. If the checksum values match the primary and standby databases are synchronized. If they do not match the databases are not synchronized and an alert is generated. In preparing the second checksum a self consistency check may also be run on the standby database.</description><language>eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2013</creationdate><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20130911&amp;DB=EPODOC&amp;CC=GB&amp;NR=2500085A$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,776,881,25542,76290</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20130911&amp;DB=EPODOC&amp;CC=GB&amp;NR=2500085A$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>GARY NANHAO JIN</creatorcontrib><creatorcontrib>STEVEN ROBERT PEARSON</creatorcontrib><creatorcontrib>PRASADARAO AKULAVENKATAVARA</creatorcontrib><creatorcontrib>AARON ISRAEL HENNER</creatorcontrib><title>Determining whether a standby database is synchronized with a primary database</title><description>A method for performing an operation for determining whether a standby database is synchronized with a primary database in a log shipping physical database replication environment is disclosed. In operation a transaction log specifying on one or more checksum values for a first set of pages on the primary database. A second one or more checksum values for a second set of pages on the standby database is calculated. The checksums are compared to determine whether the standby database is synchronized with the primary database. If the checksum values match the primary and standby databases are synchronized. If they do not match the databases are not synchronized and an alert is generated. In preparing the second checksum a self consistency check may also be run on the standby database.</description><subject>CALCULATING</subject><subject>COMPUTING</subject><subject>COUNTING</subject><subject>ELECTRIC DIGITAL DATA PROCESSING</subject><subject>PHYSICS</subject><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2013</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNqFyr0KwkAMAOBbHER9BvMCwqEUXP1tJyf3kvZiL2DT4xIo9el1EBydvuWbu9uZjHLPwtLBGMkiZUBQQwnNBAENG1QCVtBJ2pgH4RcFGNni56XMPebfW7rZA59Kq68Lt75e7qdqQ2moSRO2JGR1edwW3vt9cdj9H29d9TXT</recordid><startdate>20130911</startdate><enddate>20130911</enddate><creator>GARY NANHAO JIN</creator><creator>STEVEN ROBERT PEARSON</creator><creator>PRASADARAO AKULAVENKATAVARA</creator><creator>AARON ISRAEL HENNER</creator><scope>EVB</scope></search><sort><creationdate>20130911</creationdate><title>Determining whether a standby database is synchronized with a primary database</title><author>GARY NANHAO JIN ; STEVEN ROBERT PEARSON ; PRASADARAO AKULAVENKATAVARA ; AARON ISRAEL HENNER</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_GB2500085A3</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2013</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>GARY NANHAO JIN</creatorcontrib><creatorcontrib>STEVEN ROBERT PEARSON</creatorcontrib><creatorcontrib>PRASADARAO AKULAVENKATAVARA</creatorcontrib><creatorcontrib>AARON ISRAEL HENNER</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>GARY NANHAO JIN</au><au>STEVEN ROBERT PEARSON</au><au>PRASADARAO AKULAVENKATAVARA</au><au>AARON ISRAEL HENNER</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Determining whether a standby database is synchronized with a primary database</title><date>2013-09-11</date><risdate>2013</risdate><abstract>A method for performing an operation for determining whether a standby database is synchronized with a primary database in a log shipping physical database replication environment is disclosed. In operation a transaction log specifying on one or more checksum values for a first set of pages on the primary database. A second one or more checksum values for a second set of pages on the standby database is calculated. The checksums are compared to determine whether the standby database is synchronized with the primary database. If the checksum values match the primary and standby databases are synchronized. If they do not match the databases are not synchronized and an alert is generated. In preparing the second checksum a self consistency check may also be run on the standby database.</abstract><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language eng
recordid cdi_epo_espacenet_GB2500085A
source esp@cenet
subjects CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
title Determining whether a standby database is synchronized with a primary database
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-02-02T22%3A40%3A13IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-epo_EVB&rft_val_fmt=info:ofi/fmt:kev:mtx:patent&rft.genre=patent&rft.au=GARY%20NANHAO%20JIN&rft.date=2013-09-11&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EGB2500085A%3C/epo_EVB%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rfr_iscdi=true