On-line data migration method based on Oracle database

A database and data technology, applied in the field of database applications, can solve problems such as difficult to determine the SCN point, long downtime, etc., to achieve the effect of reducing downtime switching time and improving efficiency

Inactive Publication Date: 2008-09-17
ALIBABA CLOUD COMPUTING LTD
View PDF0 Cites 48 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, some of the above-mentioned migration methods have too long downtime, some are difficult to determine the SCN point at the start of full synchronization, and some cannot perform data migration across platforms, versions and character sets

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
  • On-line data migration method based on Oracle database
  • On-line data migration method based on Oracle database
  • On-line data migration method based on Oracle database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0046] The specific implementation manners of the present invention will be described in further detail below with reference to the accompanying drawings.

[0047] figure 1It shows several data migration methods commonly used in the prior art, among which, the methods that can perform online data migration include standby, stream and related tools; the methods that require a long downtime to complete data migration include exp / imp Or expdp / impdp under Oracle 10g version, using the command insert / ＊ +append ＊ / into...from db_link+nologging dblink mode and table space transfer. refer to figure 1 , the above several commonly used data migration methods can be divided into the following processes according to whether online migration is supported:

[0048] (1) Data migration preparation 100;

[0049] (2) Judgment 102 of whether to migrate online;

[0050] (3) If online migration is not performed, perform downtime maintenance 104;

[0051] (4) Commonly used migration methods...

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 method for realizing online data migration based on Oracle database, comprising: prebuilt mv,trigger+procedure and trigger+sql*loader+ programs. The three modes comprise using operation log, total refreshment log and incremental refreshment log, and migration change to complete the data migration. By using the prebuilt mv and trigger+procedure programs according to the invention, the cross-platform, and cross-version data migration can be realized; by using the trigger+sql*loader+ program, the conversion among databases of different character sets can be realized by the text file or communication among process, in order to realize cross-character set migration.

Description

technical field [0001] The invention relates to database application technology, in particular to the application technology of Oracle database. Background technique [0002] With the speed of upgrading database management systems and operating system platforms, database engineers often need to migrate data between two different databases or between two different operating system platforms. Data migration refers to the migration of data from one machine to another, or data from one database to another, and the data (including structure definitions) can function normally after the transfer. [0003] In the prior art, commonly used data migration methods mainly include: using export / import (export / import) or the export / import (expdp / impdp) method provided by Oracle 10g version, insert / import ＊ +append ＊ / into...from db_link+nologging, standby migration, data migration using stream and related tools, table space-based transmission and Oracle 10g cross-platform data file conve...

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
Inventor 陈吉平
Owner ALIBABA CLOUD COMPUTING 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