CN104899333A - Cross-platform migrating method and system for Oracle database - Google Patents
Cross-platform migrating method and system for Oracle database Download PDFInfo
- Publication number
- CN104899333A CN104899333A CN201510355802.9A CN201510355802A CN104899333A CN 104899333 A CN104899333 A CN 104899333A CN 201510355802 A CN201510355802 A CN 201510355802A CN 104899333 A CN104899333 A CN 104899333A
- Authority
- CN
- China
- Prior art keywords
- information
- source
- database
- destination end
- module
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/214—Database migration support
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a cross-platform migrating method and a system for an Oracle database. The method comprises the following steps: collecting source end platform information and database information at a source end, and collecting target end platform information at a target end; comparing the target end platform information with the source end platform information at the source end, and generating a platform difference analysis list between the source end and the target end; employing a migration algorithm to generate a migration guide based on the platform difference analysis list and the source end database information by the source end, and migrating data based on the migration guide; collecting database information recovered in the target end by the target end, comparing the source end database information with the database information recovered in the target end, generating a consistency checking list, determining that the source end database is in consistency with the target end database based on the consistency checking list, then finishing the migration. The cross-platform migrating method for the Oracle database can reduce the workload of the migration and reduce the difficulty of migration.
Description
Technical field
The present invention relates to database migration technical field, espespecially a kind of oracle database cross-platform migration method and system.
Background technology
High-end server carries the core application of industry, is widely used in the crucial applications such as finance, telecommunications, the energy, traffic, and it runs and is directly connected to society, economic normal operation.For a long time, owing to lacking high-end server Design and manufacture ability, China's high-end server markets holds for foreign vendor always, and wherein the inscriptions on bones or tortoise shells occupies the home market of more than 20% for a long time.Under the support of Department of Science and Technology's Eleventh Five-Year Plan 863 Program, relevant departments, R&D institution actively coordinate, and tide successfully have developed 32 tunnel high-end fault-tolerant computer systems, and availability reaches 99.999%, and system Transaction Processing ability reaches world-class levels.For improving the autonomous controllability of informatization Grand Equipments, increasing infosystem is tended to use from major product.Therefore, within following long period of time, domestic IT system construction is faced with the change of production domesticization, concrete Information System configuration and practice level, be presented as increasing cross-platform migration work, wherein have suitable migration work to be from hp-ux platform to tide K-UX platform.
Database is the kernel software of IT system, and database migration is also a part very important during IT system is built.Due to the cpu instruction collection difference of heterogeneous server platforms, operating system difference and compiler difference, make database cross platform migration difficulty high, workload is large.How reducing migration difficulty, reduce workload, is the key issue that platform database migration needs to solve.
Summary of the invention
In order to solve the problems of the technologies described above, the invention provides a kind of oracle database cross-platform migration method and system, can from extendible processor architecture (SPARC, Scalable Processor ARChitecture) platform is in the process of K-UX platform migration, and reduction migration difficulty also reduces workload.
In order to reach the object of the invention, the invention provides a kind of oracle database cross-platform migration method, the method is applied to and is connected source and destination end by Ethernet, and source and destination end are mutual with oracle database respectively; The method comprises: when needs carry out database migration, and source collects source platform information and database information, and destination end collects destination end platform information; Source receives the destination end platform information from described destination end, contrast destination end platform information and source platform information, generates the platform variance analysis table of source and destination end; Source, according to platform variance analysis table and source database information, adopts the migration algorithm pre-set to generate Migration Wizard, carries out Data Migration according to Migration Wizard; Destination end collects the database information that destination end is recovered, the database information that contrast source database information and destination end are recovered, generate the consistency check table of source database and destination end database, consistent with destination end database according to consistency check table determination source database, then the cross-platform migration of oracle database completes.
Present invention also offers the cross-platform migratory system of a kind of oracle database, comprising: source and destination end, realize source by Ethernet and communicate with destination end, and source and destination end are mutual with oracle database respectively; Described source, for collecting source platform information and database information; Receive the destination end platform information from destination end, contrast destination end platform information and source platform information, generate the platform variance analysis table of source and destination end; According to platform variance analysis table and source database information, adopt the migration algorithm pre-set to generate Migration Wizard, carry out Data Migration according to Migration Wizard; Described destination end, for collecting the database information of destination end platform information and recovery, the database information that contrast source database information and destination end are recovered, generate the consistency check table of source database and destination end database, consistent with destination end database according to consistency check table determination source database, then the cross-platform migration of oracle database completes.
In oracle database cross-platform migration method of the present invention and system, greatly can reduce oracle database from SPARC platform to the workload of K-UX platform migration, reduce migration difficulty.
Other features and advantages of the present invention will be set forth in the following description, and, partly become apparent from instructions, or understand by implementing the present invention.Object of the present invention and other advantages realize by structure specifically noted in instructions, claims and accompanying drawing and obtain.
Accompanying drawing explanation
Accompanying drawing is used to provide the further understanding to technical solution of the present invention, and forms a part for instructions, is used from and explains technical scheme of the present invention, do not form the restriction to technical solution of the present invention with the embodiment one of the application.
Fig. 1 is the schematic flow sheet of oracle database cross-platform migration method in a kind of embodiment of the present invention.
Fig. 2 is the configuration diagram of the cross-platform migratory system of oracle database in a kind of embodiment of the present invention.
Embodiment
For making the object, technical solutions and advantages of the present invention clearly understand, hereinafter will be described in detail to embodiments of the invention by reference to the accompanying drawings.It should be noted that, when not conflicting, the embodiment in the application and the feature in embodiment can combination in any mutually.
Can perform in the computer system of such as one group of computer executable instructions in the step shown in the process flow diagram of accompanying drawing.Further, although show logical order in flow charts, in some cases, can be different from the step shown or described by order execution herein.
Oracle database is that database is the relational database management system of core in a distributed manner, and each oracle database run is associated with an Oracle example, and an Oracle example is access and the software mechanism controlling a database; When starting a database each time on database server, be called that a memory field (being called for short SGA) of system cleanout (SYSTEM GLOBAL AREA) is assigned with, have one or more Oracle process to be activated.The combination of this SGA and Oracle process is called an oracle database example, and the SGA of an example and process are management data database data, are this database one or more user service and working; In Oracle system, be first that example starts, then assemble a database by example.In loosely coupled system, when having Oracle Parallel server tab, individual data storehouse can be assembled by Multi-instance, and namely Multi-instance shares Same Physical database.
SPARC platform, it is one of risc microcontroller framework, for various enterprise application provides the performance of setting the world record, only need the sub-fraction of large scale computer cost, impayable mission-critical reliability can be obtained, uniquely to comprise on sheet the solution that the platform of encryption and Oracle Solaris security framework and oracle database, business application, middleware software and Oracle optimize fully-integrated, and utilize comprehensive, built-in zero cost virtualization raising system availability.
K-UX platform is a kind of UNIX operating system of tide independent development.
Fig. 1 is the schematic flow sheet of oracle database cross-platform migration method in a kind of embodiment of the present invention.In specific embodiment of the invention, oracle database needs from SPARC platform to K-UX platform migration, and wherein setting SPARC platform is source, and K-UX platform is destination end, realizes source communicate with destination end by Ethernet.
As shown in Figure 1, oracle database cross-platform migration method of the present invention, comprising:
Step 11, connected, and source and destination end is mutual with oracle database respectively after source and destination end start by Ethernet.
In this step, source and destination end framework realize based on JAVA, to realize cross-platform characteristic, source is installed on other server platforms, such as SPARC platform, destination end is installed on K-UX platform, and source and destination end are by ethernet communication, and source and destination end are mutual with oracle database respectively.
Step 12, when needs carry out database migration, source collects source platform information and database information, and destination end collects destination end platform information.
In this step, source platform information comprises processor architecture information, instruction set information, syllable sequence information, compiler information, operation system information, system variable information and filesystem information;
Database information comprises database version information, data amount information, table information, index information, storing process information, user profile and log information;
Destination end platform information comprises processor architecture information, instruction set information, syllable sequence information, compiler information, operation system information, system variable information and filesystem information.
Step 13, source receives the destination end platform information from described destination end, contrast destination end platform information and source platform information, generates the platform variance analysis table of source and destination end.
In this step, how to carry out contrast and be well known to those skilled in the art, therefore be not repeated herein.
Step 14, source, according to platform variance analysis table and source database information, adopts the migration algorithm pre-set to generate Migration Wizard, carries out Data Migration according to Migration Wizard.
In this step, source, according to platform variance analysis table and source database information, adopts migration algorithm to generate Migration Wizard; In addition, if there is manual intervention information, can also, according to platform variance analysis table, source database information and manual intervention information, migration algorithm be adopted to generate Migration Wizard.
Step 15, the database information that destination end contrast source database information and destination end are recovered, generate the consistency check table of source database and destination end database, consistent with destination end database according to consistency check table determination source database, then the cross-platform migration of oracle database completes.
In this step, oracle database recovery operation is performed according to Migration Wizard, migration algorithm and manual intervention.
Destination end collects the database information recovered, and the database information of recovery, comprises database version information, data amount information, table information, index information, storing process information, user profile and log information.
The database information that contrast source database information and destination end are recovered, generates the consistency check table of source database and destination end database, if consistent with destination end database according to consistency check table determination source database, has then moved.
Migration algorithm comprises Migration Wizard generating algorithm, imports and exports Backup and Restore algorithm, can transmission table space (XTTS) Backup and Restore algorithm and data pump Backup and Restore algorithm.The detailed description generating Migration Wizard will be carried out below for different migration algorithm.
Adopt Migration Wizard generating algorithm to generate Migration Wizard, be specially:
The platform variance analysis tableau format of A, formulation source and destination end;
B, formulate migration scheme proposals corresponding to every bar difference;
C, determine the migration pattern of applicable source database version;
Particularly, if source database version is Oracle 9i, then importing/derivation mode is used to move;
If source database version is Oracle 10g or Oracle 11g, then select different moving methods and different dump files transmission suggestion according to different data volumes and time window: if data volume <1T, time window is 8h ~ 12h, suggestion adopts the mode of XTTS to perform Data Migration, and adopts the mode Mobile data file of FTP transmission or NFS transfer server; If data volume <1T, time window is 12h ~ 48h, adopts the mode of data pump to perform Data Migration; If data volume 1T ~ 5T, time window is 8h ~ 24h, adopts the mode of XTTS to perform Data Migration, and adopts the mode Mobile data file of FTP transmission or NFS transfer server; If data volume 1T ~ 5T, time window is 24h ~ 48h, adopts the mode of data pump to perform Data Migration; If data volume 5T ~ 10T, time window is 8h ~ 48h, adopts the mode of XTTS (can transmission table space) to perform Data Migration, and adopts NFS transfer server or store again the mode Mobile data file of carry; If data volume >10T, time window is 8h ~ 48h, and suggestion adopts the mode of XTTS to perform Data Migration, and adopts the mode Mobile data file storing again carry.
D, estimate transit time, this transit time comprises DB Backup time, dump file transmission time and database recovery time;
Particularly, transit time can be estimated according to platform variance analysis table information, user profile, storing process information.
E, generate Migration Wizard according to the information of A ~ D;
Particularly, this stage mainly carries out Data Migration backup according to Migration Wizard.
Moving according to importing and exporting Backup and Restore algorithm, comprising:
A, execution originating mobile subscriber Database Consistency Checking;
B, backup source client database, generate dump file, feedback result;
C, prompting user transmit dump file and confirm dump file end of transmission;
D, import user library in destination end, and feedback result;
E, target database perform consistency check, feedback check result;
The target data library information that F, collection have recovered, comprise database version information, data amount information, table information, index information, storing process information, user profile, log information, contrast one by one with source database information, generate the consistency check table of source database and destination end database, and check according to consistency check table, determine that source database is consistent with destination end database, then the cross-platform migration of oracle database completes.
Move according to XTTS Backup and Restore algorithm, comprising:
A, establishment target database;
Particularly, adopt the mode of DBCA to create target database, because the template generated when storehouse, source can be used like this to create, so the object library created out is identical with storehouse, source parameters, decrease the manual intervention such as succeeding target storehouse optimization.
B, environment are verified;
Particularly, checking source database and target database the respective option, comprising: system platform, syllable sequence, character set, time zone version, audiomonitor, TNS etc.
C, initialization;
Particularly, migration script is generated, modifying target storehouse system default table space.
D, deletion target database subscriber's meter space;
E, establishment map user;
F, derivation source database metadatabase;
G, the self-contained inspection in subscriber's meter space;
H, change source database subscriber's meter spatiality;
I, derivation source database subscriber's meter Metadata;
G, employing a kind of mobile meta data file below and the data file of format: adopt the mode of FTP transmission, adopt NFS to do the mode of intermediate server, or adopt the mode storing again carry;
K, converting source data database data file syllable sequence;
L, importing source database subscriber's meter Metadata;
M, restore target database user table space state;
N, importing source database metadata;
O, target database subsequent treatment;
P, restoring system default table space, invalidated object compiles;
Q, reduction source database subscriber's meter spatiality;
The target data library information that R, collection have recovered, comprise database version information, data amount information, table information, index information, storing process information, user profile, log information, contrast one by one with source database information, generate the consistency check table of source database and destination end database, and check according to consistency check table, determine that source database is consistent with destination end database, then the cross-platform migration of oracle database completes.
Move according to data pump Backup and Restore algorithm, comprising:
A, at source database derived data to dump file, if move to Oracle10g from Oracle 11g, when deriving, need to formulate parameter version.
Such as move to Oracle 10.2.0.1.0 from 11g, deriving statement is:
EXPDP USERID＝'test/testorcl as sysdba'schemas＝test directory＝DATA_PUMP_DIR dumpfile＝test.dmp logfile＝test.log version＝10.2.0.1.0。
B, mobile dump file are to object library.
In C, importing dump file, data are to object library.
The target data library information that D, collection have recovered, comprise database version information, data amount information, table information, index information, storing process information, user profile, log information, contrast one by one with source database information, generate the consistency check table of source database and destination end database, and check according to consistency check table, determine that source database is consistent with destination end database, then the cross-platform migration of oracle database completes.
Fig. 2 is the configuration diagram of the cross-platform migratory system of oracle database in a kind of embodiment of the present invention.As shown in Figure 2, the cross-platform migratory system of this oracle database comprises source and destination end, and wherein SPARC platform is source, and K-UX platform is destination end, realize source by Ethernet to communicate with destination end, and source and destination end are mutual with oracle database respectively.
Source, for collecting source platform information and database information; Receive the destination end platform information from destination end, contrast destination end platform information and source platform information, generate the platform variance analysis table of source and destination end; According to platform variance analysis table and source database information, adopt the migration algorithm pre-set to generate Migration Wizard, carry out Data Migration according to Migration Wizard;
Destination end, for collecting the database information of destination end platform information and recovery, the database information that contrast source database information and destination end are recovered, generate the consistency check table of source database and destination end database, consistent with destination end database according to consistency check table determination source database, then the cross-platform migration of oracle database completes.
The concrete structure of source and destination end as shown in Figure 2.
Source comprises source communications module 1, source analysis module 2, source backup module 3 and source control desk module 4, wherein the first communication port of source control desk module 4 is connected with the first communication port of source communications module 1, the second communication port of source control desk module 4 is connected with the first communication port of source analysis module 2, the third communication port of source control desk module 4 is connected with backup module 3, the second communication port of source communications module 1 is connected with the second communication port of source analysis module 2, the third communication port of source communications module 1 is connected with the second communication port of source backup module 3, 4th communication port of source communications module 1 is connected by Ethernet with the 4th communication port of destination end communication module 5.
Destination end comprises destination end communication module 5, destination end analysis module 6, destination end recovers module 7 and destination end control desk module 8, wherein the first communication port of destination end control desk module 8 is connected with the first communication port of destination end communication module 5, the second communication port of destination end control desk module 8 is connected with the first communication port of destination end analysis module 6, third communication port and the destination end of destination end control desk module 8 are recovered module 7 and are connected, the second communication port of destination end communication module 5 is connected with the second communication port of destination end analysis module 6, the second communication port that third communication port and the destination end of destination end communication module 5 recover module 7 is connected, 5 the 4th communication port of the communication module of destination end are connected by Ethernet with the 4th port of source communications module 1.
Source communications module 1 realizes source by Ethernet and communicates with destination end, and the information that source analysis module 2, source backup module 3, source control desk module 4 send is sent to destination end communication module 5 by Ethernet by source communications module 1.
Source analysis module 2 collects source platform information and database information, source platform information comprises processor architecture information, instruction set information, syllable sequence information, compiler information, operation system information, system variable information and filesystem information, and database information comprises database version information, data amount information, table information, index information, storing process information, user profile and log information.
In addition, the destination end platform information that source analysis module 2 is collected by source communications module 1 receiving target end analysis module 6, contrast source platform information and destination end platform information, show that source and destination end Deping platform variance analysis table export source control desk module 4 to.Source analysis module, according to the source database information of platform variance analysis table, collection and migration algorithm, is formulated migration scheme and is exported source control desk module 4 to, according to the manual intervention information of source control desk module 4 feedback, generates Migration Wizard and instructs migration.Source platform information, source database information, platform variance analysis table, migration scheme, Migration Wizard are sent to source communications module 1 by source analysis module 2.
Source backup module 3 performs source oracle database backup operation according to the manual intervention that Migration Wizard, migration algorithm and control desk send, and feedback often walks the result of operation to source control desk module 4 and source communications module 1.
Source control desk module 4 is for realizing man-machine interaction.
Destination end communication module 5 is by Ethernet realize target end and source communications, and the information that destination end analysis module 6, destination end recovery module 7, destination end control desk module 8 send is sent to source communications module 1 by Ethernet by destination end communication module 5.
Destination end analysis module 6 collects the database information of destination end platform information and recovery, platform information comprises processor architecture information, instruction set information, syllable sequence information, compiler information, operation system information, system variable information and filesystem information, and the database information of recovery comprises database version information, data amount information, table information, index information, storing process information, user profile, log information.
In addition, destination end analysis module 6 receives the source database information of source analysis module 2 collection by destination end communication module 5, contrast source database information and destination end, with the database information recovered, draw source database, destination end Database Consistency Checking table export destination end control desk module 8 to.Destination end analysis module 6 by destination end platform information, destination end database information, Database Consistency Checking table, be sent to destination end communication module 5.
Destination end is recovered module 7 and is performed the recovery operation of source oracle database according to the manual intervention that Migration Wizard, migration algorithm and control desk send, and feedback often walks the result of operation to destination end control desk module 8 and destination end communication module 5.
Destination end control desk module 8 is for realizing man-machine interaction.
Source control desk module 4 and destination end control desk module 8 are exchanged information by source communications module 1 and destination end communication module 5, realize all to control described Data Migration Tools in source and destination end.
Migration algorithm comprises Migration Wizard generating algorithm, imports and exports Backup and Restore algorithm, XTTS Backup and Restore algorithm and data pump Backup and Restore algorithm.
Migration Wizard generating algorithm, is specially:
The platform variance analysis tableau format of A, formulation source and destination end;
B, formulate migration scheme proposals corresponding to every bar difference;
C, determine the migration pattern of applicable source database version;
Particularly, if source database version is Oracle 9i, then importing/derivation mode is used to move;
If source database version is Oracle 10g or Oracle 11g, then select different moving methods and different dump files transmission suggestion according to different data volumes and time window: if data volume <1T, time window is 8h ~ 12h, suggestion adopts the mode of XTTS to perform Data Migration, and adopts the mode Mobile data file of FTP transmission or NFS transfer server; If data volume <1T, time window is 12h ~ 48h, adopts the mode of data pump to perform Data Migration; If data volume 1T ~ 5T, time window is 8h ~ 24h, adopts the mode of XTTS to perform Data Migration, and adopts the mode Mobile data file of FTP transmission or NFS transfer server; If data volume 1T ~ 5T, time window is 24h ~ 48h, adopts the mode of data pump to perform Data Migration; If data volume 5T ~ 10T, time window is 8h ~ 48h, adopts the mode of XTTS to perform Data Migration, and adopts NFS transfer server or store again the mode Mobile data file of carry; If data volume >10T, time window is 8h ~ 48h, and suggestion adopts the mode of XTTS to perform Data Migration, and adopts the mode Mobile data file storing again carry.
D, estimate transit time, this transit time comprises DB Backup time, dump file transmission time and database recovery time;
Particularly, transit time can be estimated according to platform variance analysis table information, user profile, storing process information.
E, source analysis module 2 generate Migration Wizard according to the information of A ~ D.
Particularly, this stage mainly carries out Data Migration backup according to Migration Wizard.Source analysis module 2 generates migration scheme proposals according to the information in A ~ D, and migration scheme proposals is sent to source control desk module 4 and source communications module 1, according to the decision-making to migration scheme proposals, generates Migration Wizard.
Employing imports and exports Backup and Restore algorithm, is specially:
A, source backup module 3 perform originating mobile subscriber Database Consistency Checking;
B, source backup module 3 backup source client database, generate dump file, feedback result;
C, prompting user transmit dump file;
D, confirm dump file end of transmission by source control desk module 4 or destination end control desk module 8;
E, destination end are recovered module 7 and are imported user library in destination end, and feedback result;
F, destination end are recovered module 7 and are performed consistency check in target database, feedback check result;
G, destination end analysis module 6 collects the target data library information recovered, comprise database version information, data amount information, table information, index information, storing process information, user profile, log information, the source database information collected with source analysis module 2 contrasts one by one, generate the consistency check table of source database and destination end database, and consistency check table is sent to destination end control desk module 8 for checking, consistency check table is sent to destination end communication module 5 and can obtains consensus information to make user in source control desk module 4, destination end control desk module checks according to consistency check table, determines that source database is consistent with destination end database, then the cross-platform migration of oracle database completes.
Adopt XTTS Backup and Restore algorithm, be specially:
A, establishment target database;
Particularly, adopt the mode of DBCA to create target database, because the template generated when storehouse, source can be used like this to create, so the object library created out is identical with storehouse, source parameters, decrease the manual intervention such as succeeding target storehouse optimization.
B, environment are verified;
Particularly, checking source database and target database the respective option, comprising: system platform, syllable sequence, character set, time zone version, audiomonitor, TNS etc.
C, initialization;
Particularly, migration script is generated, modifying target storehouse system default table space.
D, deletion target database subscriber's meter space;
E, establishment map user;
F, derivation source database metadatabase;
G, the self-contained inspection in subscriber's meter space;
H, change source database subscriber's meter spatiality;
I, derivation source database subscriber's meter Metadata;
G, employing a kind of mobile meta data file below and the data file of format: adopt the mode of FTP transmission, adopt NFS to do the mode of intermediate server, or adopt the mode storing again carry;
K, converting source data database data file syllable sequence;
L, importing source database subscriber's meter Metadata;
M, restore target database user table space state;
N, importing source database metadata;
O, target database subsequent treatment;
P, restoring system default table space, invalidated object compiles;
Q, reduction source database subscriber's meter spatiality;
R, destination end analysis module 6 collect the target data library information recovered, comprise database version information, data amount information, table information, index information, storing process information, user profile, log information, the source database information collected with source analysis module 2 contrasts one by one, generate the consistency check table of source database and destination end database, and consistency check table is sent to destination end control desk module 8 and checks, consistency check table is sent to destination end communication module 5 and can obtains consensus information to make user in source control desk module 4; Destination end control desk module checks according to consistency check table, determines that source database is consistent with destination end database, then the cross-platform migration of oracle database completes.
Adopt data pump Backup and Restore algorithm, be specially:
A, at source database derived data to dump file, if move to Oracle10g from Oracle 11g, when deriving, need to formulate parameter version;
B, mobile dump file are to object library;
In C, importing dump file, data are to object library;
D, destination end analysis module 6 collect the target data library information recovered, comprise database version information, data amount information, table information, index information, storing process information, user profile, log information, the source database information collected with source analysis module 2 contrasts one by one, generate the consistency check table of source database and destination end database, and consistency check table is sent to destination end control desk module 8 and checks, consistency check table is sent to destination end communication module 5 and can obtains consensus information to make user in source control desk module 4; Destination end control desk module checks according to consistency check table, determines that source database is consistent with destination end database, then the cross-platform migration of oracle database completes.
In oracle database cross-platform migration method of the present invention and system, greatly can reduce oracle database from SPARC platform to the workload of K-UX platform migration, reduce migration difficulty.
Although the embodiment disclosed by the present invention is as above, the embodiment that described content only adopts for ease of understanding the present invention, and be not used to limit the present invention.Those of skill in the art belonging to any the present invention; under the prerequisite not departing from the spirit and scope disclosed by the present invention; any amendment and change can be carried out in the form implemented and details; but scope of patent protection of the present invention, the scope that still must define with appending claims is as the criterion.
Claims (19)
1. an oracle database cross-platform migration method, is characterized in that, the method is applied to and is connected source and destination end by Ethernet, and source and destination end are mutual with oracle database respectively;
The method comprises:
When needs carry out database migration, source collects source platform information and database information, and destination end collects destination end platform information;
Source receives the destination end platform information from described destination end, contrast destination end platform information and source platform information, generates the platform variance analysis table of source and destination end;
Source, according to platform variance analysis table and source database information, adopts the migration algorithm pre-set to generate Migration Wizard, carries out Data Migration according to Migration Wizard;
Destination end collects the database information that destination end is recovered, the database information that contrast source database information and destination end are recovered, generate the consistency check table of source database and destination end database, consistent with destination end database according to consistency check table determination source database, then the cross-platform migration of oracle database completes.
2. method according to claim 1, is characterized in that, described source and destination end framework realize based on JAVA, and source is installed on SPARC platform, and destination end is installed on K-UX platform.
3. method according to claim 1, is characterized in that, described source platform information comprises processor architecture information, instruction set information, syllable sequence information, compiler information, operation system information, system variable information and filesystem information;
Described database information comprises database version information, data amount information, table information, index information, storing process information, user profile and log information;
Described destination end platform information comprises processor architecture information, instruction set information, syllable sequence information, compiler information, operation system information, system variable information and filesystem information;
The database information of described recovery, comprises database version information, data amount information, table information, index information, storing process information, user profile and log information.
4. the method according to any one of claims 1 to 3, is characterized in that, described migration algorithm comprise import and export Backup and Restore algorithm, can transmission table space X TTS Backup and Restore algorithm and data pump Backup and Restore algorithm.
5. method according to claim 4, is characterized in that, described generation Migration Wizard, comprising:
The platform variance analysis tableau format of A, formulation source and destination end;
B, formulate migration scheme proposals corresponding to every bar difference;
C, determine the migration pattern of applicable source database version: if source database version is Oracle 9i, then use importing/derivation mode to move; If source database version is Oracle 10g or Oracle 11g, then select different moving methods and different dump files transmission suggestion according to different data volumes and time window: if data volume <1T, time window is 8h ~ 12h, suggestion adopts the mode of XTTS to perform Data Migration, and adopts the mode Mobile data file of FTP transmission or NFS transfer server; If data volume <1T, time window is 12h ~ 48h, adopts the mode of data pump to perform Data Migration; If data volume 1T ~ 5T, time window is 8h ~ 24h, adopts the mode of XTTS to perform Data Migration, and adopts the mode Mobile data file of FTP transmission or NFS transfer server; If data volume 1T ~ 5T, time window is 24h ~ 48h, adopts the mode of data pump to perform Data Migration; If data volume 5T ~ 10T, time window is 8h ~ 48h, adopts the mode of XTTS to perform Data Migration, and adopts NFS transfer server or store again the mode Mobile data file of carry; If data volume >10T, time window is 8h ~ 48h, and suggestion adopts the mode of XTTS to perform Data Migration, and adopts the mode Mobile data file storing again carry;
D, estimate transit time, this transit time comprises DB Backup time, dump file transmission time and database recovery time;
E, generate Migration Wizard according to the information of A ~ D.
6. method according to claim 4, is characterized in that, moves, comprising according to the described Backup and Restore algorithm that imports and exports:
Perform originating mobile subscriber Database Consistency Checking;
Backup source client database, generates dump file, feedback result;
Prompting user is transmitted dump file and confirms dump file end of transmission;
User library is imported in destination end, and feedback result;
Consistency check is performed, feedback check result in target database;
Collect the target data library information recovered, contrast one by one with source database information, generate the consistency check table of source database and destination end database, and check according to consistency check table.
7. method according to claim 4, is characterized in that, performs Data Migration, comprising according to described XTTS Backup and Restore algorithm:
A, establishment target database;
B, environment are verified;
C, initialization;
D, deletion target database subscriber's meter space;
E, establishment map user;
F, derivation source database metadatabase;
G, the self-contained inspection in subscriber's meter space;
H, change source database subscriber's meter spatiality;
I, derivation source database subscriber's meter Metadata;
G, employing a kind of mobile meta data file below and the data file of format: adopt the mode of FTP transmission, adopt NFS to do the mode of intermediate server, or adopt the mode storing again carry;
K, converting source data database data file syllable sequence;
L, importing source database subscriber's meter Metadata;
M, restore target database user table space state;
N, importing source database metadata;
O, target database subsequent treatment;
P, restoring system default table space, invalidated object compiles;
Q, reduction source database subscriber's meter spatiality;
The target data library information that R, collection have recovered, comprise database version information, data amount information, table information, index information, storing process information, user profile, log information, contrast one by one with source database information, generate the consistency check table of source database and destination end database, and check according to consistency check table, determine that source database is consistent with destination end database, then the cross-platform migration of oracle database completes.
8. method according to claim 4, is characterized in that, performs Data Migration, comprising according to described data pump Backup and Restore algorithm:
A, at source database derived data to dump file, if move to Oracle10g from Oracle 11g, when deriving, need to formulate parameter version;
B, mobile dump file are to object library;
In C, importing dump file, data are to object library;
The target data library information that D, collection have recovered, comprise database version information, data amount information, table information, index information, storing process information, user profile, log information, contrast one by one with source database information, generate the consistency check table of source database and destination end database, and check according to consistency check table, determine that source database is consistent with destination end database, then the cross-platform migration of oracle database completes.
9. the cross-platform migratory system of oracle database, is characterized in that, comprises source and destination end, realizes source communicate with destination end by Ethernet, and source and destination end are mutual with oracle database respectively;
Described source, for collecting source platform information and database information; Receive the destination end platform information from destination end, contrast destination end platform information and source platform information, generate the platform variance analysis table of source and destination end; According to platform variance analysis table and source database information, adopt the migration algorithm pre-set to generate Migration Wizard, carry out Data Migration according to Migration Wizard;
Described destination end, for collecting the database information of destination end platform information and recovery, the database information that contrast source database information and destination end are recovered, generate the consistency check table of source database and destination end database, consistent with destination end database according to consistency check table determination source database, then the cross-platform migration of oracle database completes.
10. system according to claim 9, is characterized in that, described source and destination end framework realize based on JAVA, and source is installed on SPARC platform, and destination end is installed on K-UX platform;
11. systems according to claim 9, is characterized in that, described source comprises: source communications module, source analysis module, source backup module and source control desk module, wherein,
First communication port of source control desk module is connected with the first communication port of source communications module, the second communication port of source control desk module is connected with the first communication port of source analysis module, the third communication port of source control desk module is connected with backup module, the second communication port of source communications module is connected with the second communication port of source analysis module, the third communication port of source communications module is connected with the second communication port of source backup module, 4th communication port of source communications module is connected by Ethernet with the 4th communication port of destination end communication module.
12. systems according to claim 11, is characterized in that, described destination end comprises: destination end communication module, destination end analysis module, destination end recover module and destination end control desk module, wherein,
First communication port of destination end control desk module is connected with the first communication port of destination end communication module, the second communication port of destination end control desk module is connected with the first communication port of destination end analysis module, third communication port and the destination end of destination end control desk module are recovered module and are connected, the second communication port of destination end communication module is connected with the second communication port of destination end analysis module, the second communication port that third communication port and the destination end of destination end communication module recover module is connected, 4th communication port of the communication module of destination end is connected by Ethernet with the 4th port of source communications module.
13. systems according to claim 12, it is characterized in that, described source communications module realizes source by Ethernet and communicates with destination end, and the information that source analysis module, source backup module, source control desk module send is sent to destination end communication module by Ethernet by source communications module;
Described source analysis module collects source platform information and database information, and source platform information comprises processor architecture information, instruction set information, syllable sequence information, compiler information, operation system information, system variable information and filesystem information; Database information comprises database version information, data amount information, table information, index information, storing process information, user profile and log information; The destination end platform information that source analysis module is collected by source communications module receiving target end analysis module, contrast source platform information and destination end platform information, show that source and destination end Deping platform variance analysis table export source control desk module to; According to source database information and the migration algorithm of platform variance analysis table, collection, formulate migration scheme and export source control desk module to, according to the manual intervention information of source control desk module feedback, generate Migration Wizard and instruct migration; Source platform information, source database information, platform variance analysis table, migration scheme, Migration Wizard are sent to source communications module;
Described source backup module performs source oracle database backup operation according to the manual intervention that Migration Wizard, migration algorithm and control desk send, and feedback often walks the result of operation to source control desk module and source communications module.
Described source control desk module is used for realizing man-machine interaction.
14. systems according to claim 13, it is characterized in that, described destination end communication module is by Ethernet realize target end and source communications, and the information that destination end analysis module, destination end recovery module, destination end control desk module send is sent to source communications module by Ethernet by destination end communication module;
Described destination end analysis module collects the database information of destination end platform information and recovery, and destination end platform information comprises processor architecture information, instruction set information, syllable sequence information, compiler information, operation system information, system variable information and filesystem information; The database information recovered comprises database version information, data amount information, table information, index information, storing process information, user profile and log information; Destination end analysis module receives the source database information of source analysis module collection by destination end communication module, contrast source database information and destination end, with the database information recovered, draw source database, destination end Database Consistency Checking table export destination end control desk module to; By destination end platform information, destination end database information, Database Consistency Checking table, be sent to destination end communication module;
Described destination end is recovered module and is performed the recovery operation of source oracle database according to the manual intervention that Migration Wizard, migration algorithm and control desk send, and feedback often walks the result of operation to destination end control desk module and destination end communication module;
Destination end control desk module is used for realizing man-machine interaction.
15. systems according to any one in claim 9 ~ 14, is characterized in that, described migration algorithm comprises Migration Wizard generating algorithm, imports and exports Backup and Restore algorithm, can transmission table space X TTS Backup and Restore algorithm and data pump Backup and Restore algorithm.
16. systems according to claim 15, is characterized in that, described Migration Wizard generating algorithm, is specially:
The platform variance analysis tableau format of A, formulation source and destination end;
B, formulate migration scheme proposals corresponding to every bar difference;
C, determine the migration pattern of applicable source database version: if source database version is Oracle 9i, then use importing/derivation mode to move; If source database version is Oracle 10g or Oracle 11g, then select different moving methods and different dump files transmission suggestion according to different data volumes and time window: if data volume <1T, time window is 8h ~ 12h, suggestion adopts the mode of XTTS to perform Data Migration, and adopts the mode Mobile data file of FTP transmission or NFS transfer server; If data volume <1T, time window is 12h ~ 48h, adopts the mode of data pump to perform Data Migration; If data volume 1T ~ 5T, time window is 8h ~ 24h, adopts the mode of XTTS to perform Data Migration, and adopts the mode Mobile data file of FTP transmission or NFS transfer server; If data volume 1T ~ 5T, time window is 24h ~ 48h, adopts the mode of data pump to perform Data Migration; If data volume 5T ~ 10T, time window is 8h ~ 48h, adopts the mode of XTTS to perform Data Migration, and adopts NFS transfer server or store again the mode Mobile data file of carry; If data volume >10T, time window is 8h ~ 48h, and suggestion adopts the mode of XTTS to perform Data Migration, and adopts the mode Mobile data file storing again carry;
D, estimate transit time, this transit time comprises DB Backup time, dump file transmission time and database recovery time;
E, source analysis module generate migration scheme proposals according to the information in A ~ E, and migration scheme proposals is sent to source control desk module and source communications module, according to the decision-making to migration scheme proposals, generate Migration Wizard.
17. systems according to claim 15, is characterized in that, described in import and export Backup and Restore algorithm, be specially:
A, source backup module perform originating mobile subscriber Database Consistency Checking;
B, source backup module backup source client database, generate dump file, feedback result;
C, prompting user transmit dump file;
D, confirm dump file end of transmission by source control desk module or destination end control desk module;
E, destination end are recovered module and are imported user library in destination end, and feedback result;
F, destination end are recovered module and are performed consistency check in target database, feedback check result;
G, destination end analysis module collect the target data library information recovered, comprise database version information, data amount information, table information, index information, storing process information, user profile, log information, the source database information collected with source analysis module contrasts one by one, generate the consistency check table of source database and destination end database, and consistency check table is sent to destination end control desk module for checking, consistency check table is sent to destination end communication module and obtains consensus information to enable user in source control desk module; Destination end control desk module checks according to consistency check table, determines that source database is consistent with destination end database, then the cross-platform migration of oracle database completes.
18. systems according to claim 15, is characterized in that, described XTTS Backup and Restore algorithm, is specially:
A, establishment target database;
B, environment are verified;
C, initialization;
D, deletion target database subscriber's meter space;
E, establishment map user;
F, derivation source database metadatabase;
G, the self-contained inspection in subscriber's meter space;
H, change source database subscriber's meter spatiality;
I, derivation source database subscriber's meter Metadata;
G, employing a kind of mobile meta data file below and the data file of format: adopt the mode of FTP transmission, adopt NFS to do the mode of intermediate server, or adopt the mode storing again carry;
K, converting source data database data file syllable sequence;
L, importing source database subscriber's meter Metadata;
M, restore target database user table space state;
N, importing source database metadata;
O, target database subsequent treatment;
P, restoring system default table space, invalidated object compiles;
Q, reduction source database subscriber's meter spatiality;
R, destination end analysis module collect the target data library information recovered, comprise database version information, data amount information, table information, index information, storing process information, user profile, log information, the source database information collected with source analysis module contrasts one by one, generate the consistency check table of source database and destination end database, and consistency check table is sent to destination end control desk module and checks, consistency check table is sent to destination end communication module and obtains consensus information to enable user in source control desk module; Destination end control desk module checks according to consistency check table, determines that source database is consistent with destination end database, then the cross-platform migration of oracle database completes.
19. systems according to claim 15, is characterized in that, described data pump Backup and Restore algorithm, is specially:
A, at source database derived data to dump file, if move to Oracle 10g from Oracle 11g, when deriving, need to formulate parameter version;
B, mobile dump file are to object library;
In C, importing dump file, data are to object library;
D, destination end analysis module collect the target data library information recovered, comprise database version information, data amount information, table information, index information, storing process information, user profile, log information, the source database information collected with source analysis module contrasts one by one, generate the consistency check table of source database and destination end database, and consistency check table is sent to destination end control desk module and checks, consistency check table is sent to destination end communication module and obtains consensus information to enable user in source control desk module; Destination end control desk module checks according to consistency check table, determines that source database is consistent with destination end database, then the cross-platform migration of oracle database completes.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510355802.9A CN104899333A (en) | 2015-06-24 | 2015-06-24 | Cross-platform migrating method and system for Oracle database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510355802.9A CN104899333A (en) | 2015-06-24 | 2015-06-24 | Cross-platform migrating method and system for Oracle database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104899333A true CN104899333A (en) | 2015-09-09 |
Family
ID=54031995
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510355802.9A Pending CN104899333A (en) | 2015-06-24 | 2015-06-24 | Cross-platform migrating method and system for Oracle database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104899333A (en) |
Cited By (24)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105279280A (en) * | 2015-11-16 | 2016-01-27 | 天津南大通用数据技术股份有限公司 | Method and tool for quickly migrating oracle data to MPP database |
| CN106407306A (en) * | 2016-08-31 | 2017-02-15 | 天津南大通用数据技术股份有限公司 | Data persistence distribution method and device |
| CN106445742A (en) * | 2016-09-28 | 2017-02-22 | 郑州云海信息技术有限公司 | Method for recovering database files mistakenly deleted under K-UX operation system |
| CN106649419A (en) * | 2015-12-31 | 2017-05-10 | 国网河北省电力公司 | Electricity information acquisition system-based cross-platform database data migration method |
| CN106776997A (en) * | 2016-12-02 | 2017-05-31 | 国家电网公司 | A kind of moving method of database |
| CN106776688A (en) * | 2016-11-10 | 2017-05-31 | 国云科技股份有限公司 | A kind of cross-platform physical migration network system realization of oracle database |
| CN106874403A (en) * | 2017-01-18 | 2017-06-20 | 武汉天喻教育科技有限公司 | The system and method for differential synchronization is carried out to compressed file |
| CN107193943A (en) * | 2017-05-19 | 2017-09-22 | 郑州云海信息技术有限公司 | A kind of method and apparatus of RDBMS online datas migration |
| CN108763419A (en) * | 2018-05-24 | 2018-11-06 | 郑州云海信息技术有限公司 | A kind of method, apparatus and computer storage media of migration process |
| CN108763358A (en) * | 2018-05-16 | 2018-11-06 | 阿里巴巴集团控股有限公司 | A kind of data verification method and device |
| CN108959470A (en) * | 2018-06-20 | 2018-12-07 | 郑州云海信息技术有限公司 | A kind of database data cross-platform migration method and device |
| CN109033186A (en) * | 2018-06-27 | 2018-12-18 | 东软集团股份有限公司 | Data consistency detection, device, storage medium and electronic equipment |
| CN109063005A (en) * | 2018-07-10 | 2018-12-21 | 阿里巴巴集团控股有限公司 | A kind of data migration method and system, storage medium, electronic equipment |
| CN109299063A (en) * | 2018-07-02 | 2019-02-01 | 北京市天元网络技术股份有限公司 | A kind of platform database moving method and system |
| CN109684298A (en) * | 2018-09-07 | 2019-04-26 | 平安科技（深圳）有限公司 | Database migration method, apparatus, equipment and storage medium |
| CN110019138A (en) * | 2017-12-29 | 2019-07-16 | ***通信集团公司 | A kind of transmission table space Autonomic Migration Framework method and system based on Zabbix |
| CN110494849A (en) * | 2017-03-31 | 2019-11-22 | 甲骨文国际公司 | For determining the successful system and method for cross-platform migration |
| CN111367895A (en) * | 2020-03-31 | 2020-07-03 | 中国建设银行股份有限公司 | Data migration method and device |
| CN111580862A (en) * | 2020-05-15 | 2020-08-25 | 中国邮政储蓄银行股份有限公司 | Data migration method and device |
| CN112256670A (en) * | 2020-10-10 | 2021-01-22 | 中国农业银行股份有限公司河北省分行 | Data migration method, terminal device and readable storage medium |
| CN112347189A (en) * | 2020-11-05 | 2021-02-09 | 江苏电力信息技术有限公司 | Cloud computing-based financial data consistency failure discovery and recovery method |
| CN113297182A (en) * | 2021-06-16 | 2021-08-24 | 中国农业银行股份有限公司 | Data migration method, device, storage medium and program product |
| CN114153660A (en) * | 2021-11-29 | 2022-03-08 | 平安壹账通云科技(深圳)有限公司 | Database backup method, device, server and medium |
| US11853327B2 (en) | 2020-10-14 | 2023-12-26 | International Business Machines Corporation | Seamlessly containerizing a database |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2004077215A2 (en) * | 2003-01-30 | 2004-09-10 | Vaman Technologies (R & D) Limited | System and method for data migration and conversion |
| US20050278432A1 (en) * | 2004-06-14 | 2005-12-15 | Feinleib David A | System and method for automated migration from windows to linux |
| CN104462119A (en) * | 2013-09-18 | 2015-03-25 | 腾讯科技（深圳）有限公司 | Data migration method and device |
| CN104573056A (en) * | 2015-01-22 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | Database large data volume online migration method based on oracle |
| CN104573122A (en) * | 2015-02-09 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | Oracle database migration tool migrating from AIX platform to K-UX platform |
-
2015
- 2015-06-24 CN CN201510355802.9A patent/CN104899333A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2004077215A2 (en) * | 2003-01-30 | 2004-09-10 | Vaman Technologies (R & D) Limited | System and method for data migration and conversion |
| US20050278432A1 (en) * | 2004-06-14 | 2005-12-15 | Feinleib David A | System and method for automated migration from windows to linux |
| CN104462119A (en) * | 2013-09-18 | 2015-03-25 | 腾讯科技（深圳）有限公司 | Data migration method and device |
| CN104573056A (en) * | 2015-01-22 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | Database large data volume online migration method based on oracle |
| CN104573122A (en) * | 2015-02-09 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | Oracle database migration tool migrating from AIX platform to K-UX platform |
Non-Patent Citations (1)
| Title |
|---|
| 楼宏良等: "海量数据库迁移与升级", 《计算机时代》 * |
Cited By (31)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105279280A (en) * | 2015-11-16 | 2016-01-27 | 天津南大通用数据技术股份有限公司 | Method and tool for quickly migrating oracle data to MPP database |
| CN106649419A (en) * | 2015-12-31 | 2017-05-10 | 国网河北省电力公司 | Electricity information acquisition system-based cross-platform database data migration method |
| CN106407306A (en) * | 2016-08-31 | 2017-02-15 | 天津南大通用数据技术股份有限公司 | Data persistence distribution method and device |
| CN106445742A (en) * | 2016-09-28 | 2017-02-22 | 郑州云海信息技术有限公司 | Method for recovering database files mistakenly deleted under K-UX operation system |
| CN106776688A (en) * | 2016-11-10 | 2017-05-31 | 国云科技股份有限公司 | A kind of cross-platform physical migration network system realization of oracle database |
| CN106776997A (en) * | 2016-12-02 | 2017-05-31 | 国家电网公司 | A kind of moving method of database |
| CN106874403A (en) * | 2017-01-18 | 2017-06-20 | 武汉天喻教育科技有限公司 | The system and method for differential synchronization is carried out to compressed file |
| CN110494849B (en) * | 2017-03-31 | 2023-05-26 | 甲骨文国际公司 | System and method for determining success of cross-platform application migration |
| CN110494849A (en) * | 2017-03-31 | 2019-11-22 | 甲骨文国际公司 | For determining the successful system and method for cross-platform migration |
| CN107193943A (en) * | 2017-05-19 | 2017-09-22 | 郑州云海信息技术有限公司 | A kind of method and apparatus of RDBMS online datas migration |
| CN110019138A (en) * | 2017-12-29 | 2019-07-16 | ***通信集团公司 | A kind of transmission table space Autonomic Migration Framework method and system based on Zabbix |
| CN110019138B (en) * | 2017-12-29 | 2022-06-03 | ***通信集团公司 | Automatic transfer table space migration method and system based on Zabbix |
| CN108763358A (en) * | 2018-05-16 | 2018-11-06 | 阿里巴巴集团控股有限公司 | A kind of data verification method and device |
| CN108763419A (en) * | 2018-05-24 | 2018-11-06 | 郑州云海信息技术有限公司 | A kind of method, apparatus and computer storage media of migration process |
| CN108959470A (en) * | 2018-06-20 | 2018-12-07 | 郑州云海信息技术有限公司 | A kind of database data cross-platform migration method and device |
| CN109033186A (en) * | 2018-06-27 | 2018-12-18 | 东软集团股份有限公司 | Data consistency detection, device, storage medium and electronic equipment |
| CN109033186B (en) * | 2018-06-27 | 2020-11-27 | 东软集团股份有限公司 | Data consistency detection method and device, storage medium and electronic equipment |
| CN109299063A (en) * | 2018-07-02 | 2019-02-01 | 北京市天元网络技术股份有限公司 | A kind of platform database moving method and system |
| CN109063005A (en) * | 2018-07-10 | 2018-12-21 | 阿里巴巴集团控股有限公司 | A kind of data migration method and system, storage medium, electronic equipment |
| CN109063005B (en) * | 2018-07-10 | 2021-05-25 | 创新先进技术有限公司 | Data migration method and system, storage medium and electronic device |
| CN109684298A (en) * | 2018-09-07 | 2019-04-26 | 平安科技（深圳）有限公司 | Database migration method, apparatus, equipment and storage medium |
| CN109684298B (en) * | 2018-09-07 | 2024-02-20 | 平安科技（深圳）有限公司 | Database migration method, device, equipment and storage medium |
| CN111367895A (en) * | 2020-03-31 | 2020-07-03 | 中国建设银行股份有限公司 | Data migration method and device |
| CN111367895B (en) * | 2020-03-31 | 2023-11-24 | 中国建设银行股份有限公司 | Data migration method and device |
| CN111580862A (en) * | 2020-05-15 | 2020-08-25 | 中国邮政储蓄银行股份有限公司 | Data migration method and device |
| CN112256670A (en) * | 2020-10-10 | 2021-01-22 | 中国农业银行股份有限公司河北省分行 | Data migration method, terminal device and readable storage medium |
| US11853327B2 (en) | 2020-10-14 | 2023-12-26 | International Business Machines Corporation | Seamlessly containerizing a database |
| CN112347189A (en) * | 2020-11-05 | 2021-02-09 | 江苏电力信息技术有限公司 | Cloud computing-based financial data consistency failure discovery and recovery method |
| CN113297182A (en) * | 2021-06-16 | 2021-08-24 | 中国农业银行股份有限公司 | Data migration method, device, storage medium and program product |
| CN113297182B (en) * | 2021-06-16 | 2024-01-30 | 中国农业银行股份有限公司 | Data migration method, device, storage medium and program product |
| CN114153660A (en) * | 2021-11-29 | 2022-03-08 | 平安壹账通云科技(深圳)有限公司 | Database backup method, device, server and medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104899333A (en) | Cross-platform migrating method and system for Oracle database | |
| CN104573122A (en) | Oracle database migration tool migrating from AIX platform to K-UX platform | |
| CN105138603A (en) | Oracle database migration tool for carrying out migration from HP-UX platform to K-UX platform | |
| US7610314B2 (en) | Online tablespace recovery for export | |
| CN104573121A (en) | DB2 database migration tool migrating from AIX platform to K-UX platform | |
| US10509696B1 (en) | Error detection and mitigation during data migrations | |
| CN104899332A (en) | Cross-platform migrating method and system for Sybase database | |
| JP2017539000A (en) | Dynamic scaling of storage volume for storage client file system | |
| CN108959470A (en) | A kind of database data cross-platform migration method and device | |
| CN104239166A (en) | Method for realizing file backup for running virtual machine | |
| JP2017509990A (en) | Reduced data volume durability status for block-based storage | |
| US7702641B2 (en) | Method and system for comparing and updating file trees | |
| CN109933416A (en) | A kind of moving method, device and storage medium using data | |
| CN103473287A (en) | Method and system for automatically distributing, running and updating executable programs | |
| Srinivasa et al. | Guide to high performance distributed computing | |
| CN102508916B (en) | File fingerprint analyzing method for massive data | |
| CN114556317A (en) | Document tracking through version hash link graphs | |
| CN111736762A (en) | Synchronous updating method, device, equipment and storage medium of data storage network | |
| WO2014182867A1 (en) | Techniques to recover files in a storage network | |
| CN104572102A (en) | Method for solving Chinese messy codes in JAVA | |
| Shi et al. | Research on cloud computing and services framework of marine environmental information management | |
| CN106776689A (en) | A kind of host information querying method, device and main frame | |
| CN117999551A (en) | Query and transactional consumption of result changes | |
| He et al. | The high-activity parallel implementation of data preprocessing based on MapReduce | |
| CN105095507A (en) | DB2 database migration method, device and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20150909 |
|
| WD01 | Invention patent application deemed withdrawn after publication |