Database large data volume online migration method based on oracle

A technology with large data volume and database, applied in the field of big data migration, it can solve the problem of many usage restrictions, and achieve the effect of ensuring security, zero risk, and avoiding the problem of excessive downtime.

Inactive Publication Date: 2015-04-29
LANGCHAO ELECTRONIC INFORMATION IND CO LTD
View PDF3 Cites 34 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The speed is quite fast, but there are many restrictions, such as the problem of self-contained table space, and the need to consider whether the data encoding needs to be converted in cross-platform migration, and only specific databases can be migrated

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
  • Database large data volume online migration method based on oracle

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0025] A method for online migration of a large amount of data based on oracle database described in this embodiment uses the oracle traditional data pump tool expdp / impdp to migrate the data of a certain SCN point of the database to the target database online, and uses the oracle goldengate one-way synchronization technology to The incremental data is synchronized to the target end to complete the database, and the oracle veridata tool is used to compare the data at the source end and the target end to ensure data integrity.

[0026] The method for online migration of a large amount of data based on the oracle database described in this embodiment, as shown in the attached figure 1 As shown, its specific implementation process is as follows:

[0027] 1) Deploy the Oracle GoldenGate application program on the source and target servers, configure the source capture and delivery process group according to the migration object, use the oracle goldengate one-way synchronization mo...

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 discloses a database large data volume online migration method based on the oracle. A data pump expdp / impdp tool is utilized to achieve original data migration, and data migration is achieved by using the Oracle goldengate synchronous increment data and conducting data comparison through Oracle verdiata. By means of the method, cross-platform cross-version data migration and large data volume zero shutdown migration are achieved, and the problem of too long shutdown time in the large data migration process is solved. The method ensures data safety in the migration process, and achieves zero risk of data migration.

Description

technical field [0001] The invention relates to a large data migration technology based on an Oracle database, specifically a method for online migration of a large amount of data based on an Oracle database. Background technique [0002] In layman's terms, data migration is the transfer of data from one database to another. The main usage scenarios include: building a test environment based on the official system, copying from the internal network to the external network, upgrading the hardware of the database server, etc. There are many factors to be considered in data migration, such as operating system type, database type, version, data structure, data size, minimum allowable downtime, and so on. [0003] The data pump technology is provided by PL / SQL-based DBMS_DATAPUMP and can be used in two ways, one is the command line mode, and the other is the WEB-based enterprise-level image interface management tool to complete data migration. [0004] GoldenGate software provi...

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 Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/214
Inventor 张一可乔鑫杨磊田野刘子瑞李富中
Owner LANGCHAO ELECTRONIC INFORMATION IND CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap