Data consistency verification method based on Oracle database
A verification method and database technology, applied in the field of data consistency verification based on Oracle database, can solve the problems of low table verification efficiency, large resource consumption, time consumption, temporary table space or file system directory, etc., and achieve configuration Ease of use, fast calibration efficiency
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment Construction
[0038] The present invention will be further described below in conjunction with the accompanying drawings and embodiments.
[0039] figure 1 It is a schematic diagram of the data consistency check process based on the Oracle database in the present invention.
[0040] See figure 1 , the data consistency checking method based on Oracle database provided by the present invention comprises the steps:
[0041] Step S1: Suspend the Oracle database replication process, so that the Oracle database commits all transactions; for example, if the seqno and rba values of the replication process are checked to be consistent, it can be confirmed that the replication process is in a stopped state.
[0042] Step S2: Obtain the time stamp information SCN of the source database; the time stamp information will be different for different database platforms. For the oracle database involved in the present invention, the time stamp information available for verification is SCN. The full nam...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com