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

CN101266606AInactive Publication Date: 2008-09-17ALIBABA CLOUD COMPUTING LTD
0 Cites 48 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Publication Date
2008-09-17
Estimated Expiration
Not applicable · inactive patent

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

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.
Need to check novelty before this filing date? Find Prior Art

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...

Examples

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...