CN105138603A - Oracle database migration tool for carrying out migration from HP-UX platform to K-UX platform - Google Patents
Oracle database migration tool for carrying out migration from HP-UX platform to K-UX platform Download PDFInfo
- Publication number
- CN105138603A CN105138603A CN201510479782.6A CN201510479782A CN105138603A CN 105138603 A CN105138603 A CN 105138603A CN 201510479782 A CN201510479782 A CN 201510479782A CN 105138603 A CN105138603 A CN 105138603A
- Authority
- CN
- China
- Prior art keywords
- source
- database
- information
- migration
- 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/21—Design, administration or maintenance of databases
- G06F16/214—Database migration support
Abstract
The invention discloses an Oracle database migration tool for carrying out migration from an HP-UX platform to a K-UX platform. The Oracle database migration tool is divided into two parts including a source end and a target end, wherein the source end is installed on the HP-UX server platform, the target end is installed on the K-UX platform, the source end and the target end are communicated through the Ethernet, and the tool can be operated on both the source end and the target end; the source end and the target end scan platform environments where the source end and the target end are independently positioned, and a migration evaluation report and a migration scheme proposal are generated according to a scanning result and a migration algorithm; according to a screening and generation algorithm of the migration scheme proposal by the user, migration wizard is generated, and the cross-platform cross-version semi-automatic migration of the data of the Oracle database from the HP-UX platform to the K-UX platform can be realized through the prompt and the guidance of the migration wizard on the user. Compared with the prior art, the Oracle database migration tool for carrying out the migration from the HP-UX platform to the K-UX platform greatly lowers migration difficulty and workload for migrating the Oracle database to the K-UX platform from the HP-UX platform, provides a guidance function on engineers who implement migration, and has the advantages of being high in practicality and easy in popularization.
Description
Technical field
The present invention relates to communication information technical field, specifically a kind of practical, from HPUX platform to the oracle database Migration tools of KUX platform migration.
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 Hewlett-Packard 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 transplanting difficulty, reduce workload, is the key issue that database cross platform migration needs to solve.
Summary of the invention
Technical assignment of the present invention is for above weak point, provide a kind of practical, from HPUX platform to the oracle database Migration tools of KUX platform migration.
A kind of oracle database Migration tools from HPUX platform to KUX platform migration, be divided into source and destination end two parts, source is installed on HP-UX server platform, destination end is installed on K-UX platform, source and destination end, by ethernet communication, all can operate this instrument in source and destination end; Source and destination end scan respective place platform environment, according to scanning result and migration algorithm, generate migration assessment report and migration scheme proposals; According to user, Migration Wizard is generated to the screening of migration scheme proposals and migration algorithm, by Migration Wizard to the prompting of user and guidance, realize the cross-platform cross version semi automatic migration of oracle database data from hp-ux platform to K-UX platform.
Described source comprises communication module, analysis module, backup module and control desk module, and in this source, the communication port of control desk module connects linking parsing module, backup module and communication module respectively; The communication port of analysis module, backup module all connects above-mentioned communication module;
Described destination end comprises communication module, analysis module, recovery module and control desk module, and in this destination end, the communication port of control desk module connects linking parsing module respectively, recovers module and communication module; The communication port of analysis module, recovery module all connects communication module, and the communication module of this destination end also connects the communication module of above-mentioned source.
Described communication module realizes source by Ethernet and communicates with destination end, and the information that wherein analysis module of this source, backup module, control desk module send by the communication module of source is sent to the communication module of destination end by Ethernet; The information of the analysis module of this destination end, backup module, the transmission of control desk module is sent to the communication module of source by the communication module of destination end by Ethernet.
The analysis module of source collects source platform information and database information, the analysis module of destination end 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 that the database information of source, destination end are recovered includes database version information, data amount information, table information, index information, storing process information, user profile, log information;
The analysis module of source passes through the destination end platform information of the analysis module collection of the communication module receiving target end of source, contrast source platform information and destination end platform information, draws source, control desk module that destination end platform variance analysis table exports source to; The analysis module of destination end receives the source database information of source analysis module collection by the communication module of destination end, contrast source database information and the database information that recovered of destination end, draw source database, destination end Database Consistency Checking table export control desk module to;
Source analysis module is according to the source database information of platform variance analysis table, collection and migration algorithm, formulate the control desk module that migration scheme exports source to, according to the manual intervention information of 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 the communication module of source by source analysis module; Destination end analysis module by destination end platform information, destination end database information, Database Consistency Checking table, be sent to the communication module of destination end.
The manual intervention that the backup module of described source sends according to Migration Wizard, migration algorithm and control desk performs source Oracel Database Backup operations, and the feedback result that often walks operation is to the control desk module of source and communication module; The recovery module of destination end performs the recovery operation of source oracle database according to the manual intervention that Migration Wizard, migration algorithm and control desk send, and the feedback result that often walks operation is to the control desk module of destination end and communication module.
The control desk module of described source and the control desk module of destination end are all for realizing man-machine interaction.
Described 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; Wherein,
Migration Wizard generating algorithm step is as follows:
1) source, destination end platform variance analysis tableau format is formulated;
2) migration scheme proposals corresponding to every bar difference is formulated;
3) according to source database version, different modes is selected to move;
4) estimate transit time according to table information, user profile, storing process information, transit time here comprises DB Backup time, dump file transmission time, database recovery time;
5) analysis module generates migration scheme proposals according to above information, and migration scheme proposals is sent to control desk module and the communication module of source;
6) according to the decision-making of user to migration scheme proposals, Migration Wizard is generated;
Import and export Backup and Restore algorithm steps as follows:
1) backup module performs originating mobile subscriber Database Consistency Checking;
2) backup module backup source client database, generates dump file, feedback result;
3) user is pointed out to transmit dump file;
4) user confirms dump file end of transmission by source control desk module or destination end control desk module;
5) recover module and import user library in destination end, and feedback result;
6) recover module and perform consistency check in target database, feedback check result;
7) destination end analysis module 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 contrasts one by one, generate source database, destination end Database Consistency Checking table, and by source database, destination end Database Consistency Checking table is sent to control desk module for hand inspection, by source database, destination end Database Consistency Checking table is sent to communication module can obtain consensus information to make user equally in source control desk module,
XTTS Backup and Restore algorithm steps is as follows:
1) target database is created;
2) environment checking, namely verifies source database and target database the respective option;
3) initialization, generates migration script, modifying target storehouse system default table space;
4) target database subscriber's meter space is deleted;
5) map user is created;
6) source database metadatabase is derived;
7) the self-contained inspection in subscriber's meter space;
8) source database subscriber's meter spatiality is changed;
9) source database subscriber's meter Metadata is derived;
10) data file of mobile meta data file and format;
11) converting source data database data file syllable sequence;
12) source database subscriber's meter Metadata is imported;
13) restore target database user table space state;
14) source database metadata is imported;
15) target database subsequent treatment, restoring system default table space, invalidated object compiles;
16) reduction source database subscriber's meter spatiality;
17) destination end analysis module 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 contrasts one by one, generate source database, destination end Database Consistency Checking table, and by source database, destination end Database Consistency Checking table is sent to control desk module for hand inspection, by source database, destination end Database Consistency Checking table is sent to communication module, consensus information can be obtained equally in source control desk module to make user,
Data pump Backup and Restore algorithm steps is as follows:
1) at source database derived data to dump file;
2) mobile dump file is to object library;
3) data are imported in dump file to object library;
4) destination end analysis module 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 contrasts one by one, generate source database, destination end Database Consistency Checking table, and by source database, destination end Database Consistency Checking table is sent to control desk module for hand inspection, by source database, destination end Database Consistency Checking table is sent to communication module, consensus information can be obtained equally in source control desk module to make user.
In described Migration Wizard generating algorithm, the detailed process of step 3) is:
If source database version is Oracle9i, then importing/derivation mode is used to move;
If source database version is Oracle10g or Oracle11g, then select different moving methods and different dump files transmission suggestion according to different data volumes and time window:
As data volume <1T, when time window is 8h ~ 12h, adopts and the mode of transmission table space X TTS can perform Data Migration, and adopt FTP to transmit or the mode Mobile data file of NFS transfer server;
As data volume <1T, when time window is 12h ~ 48h, the mode of data pump is adopted to perform Data Migration;
As data volume 1T ~ 5T, when time window is 8h ~ 24h, adopts and the mode of transmission table space X TTS can perform Data Migration, and adopt FTP to transmit or the mode Mobile data file of NFS transfer server;
As data volume 1T ~ 5T, when time window is 24h ~ 48h, the mode of data pump is adopted to perform Data Migration;
As data volume 5T ~ 10T, when time window is 8h ~ 48h, adopts and the mode of transmission table space X TTS can perform Data Migration, and adopt NFS transfer server or store again the mode Mobile data file of carry;
As data volume >10T, when time window is 8h ~ 48h, adopts and the mode of transmission table space X TTS can perform Data Migration, and adopt the mode Mobile data file storing again carry.
In described XTTS Backup and Restore algorithm, adopt the mode of DBCA to create target database, the object library that establishment is gone out is identical with storehouse, source parameters; After target database has created, the option content of environment checking comprises system platform, syllable sequence, character set, time zone version, audiomonitor, TNS.
In described XTTS Backup and Restore algorithm, step 10) adopts following either type to move the data file of meta data file and format:
Adopt the mode of FTP transmission;
Or adopt NFS to do the mode of intermediate server;
Or adopt the mode storing again carry.
A kind of oracle database Migration tools from HPUX platform to KUX platform migration of the present invention, has the following advantages:
A kind of oracle database Migration tools from HPUX platform to KUX platform migration that the present invention proposes, identifiable design hp-ux platform and K-UX platform difference, assessment migration environment, migration scheme proposals is proposed, generate the Migration Wizard possessing very large directive significance, greatly reduce oracle database migrates to K-UX platform migration difficulty and workload from hp-ux platform, directive function is provided to the slip-stick artist implementing migration, fill up domestic blank, reduce and transplant difficulty, reduce workload, practical, be easy to promote.
Accompanying drawing explanation
Accompanying drawing 1 is that entirety of the present invention realizes figure.
Embodiment
Below in conjunction with the drawings and specific embodiments, the invention will be further described.
The invention provides a kind of oracle database Migration tools from HPUX platform to KUX platform migration, as shown in Figure 1, be divided into source and destination end, wherein hp-ux platform is source, K-UX platform is destination end, realize source by Ethernet to communicate with destination end, all can operate instrument in source or destination end.Source and destination end scan respective place platform environment, according to scanning result and migration algorithm, generate migration assessment report and migration scheme proposals; According to user, Migration Wizard is generated to the screening of migration scheme proposals and migration algorithm, by Migration Wizard to the prompting of user and guidance, realize the cross-platform cross version semi automatic migration of oracle database data from other server platforms to K-UX platform.
Migration tools software architecture realizes based on JAVA, and to realize cross-platform characteristic, tool software is divided into source and destination end two parts, and source is installed on other server platforms, and destination end is installed on K-UX platform, and source and destination end pass through ethernet communication.
Source comprises communication module 1, analysis module 2, backup module 3 and control desk module 4, wherein control desk module 4 first communication port is connected with communication module 1 first communication port, control desk module 4 second communication port is connected with analysis module 2 first communication port, control desk module 4 third communication port is connected with backup module 3, communication module 1 second communication port is connected with analysis module 2 second communication port, communication module 1 third communication port is connected with backup module 3 second communication port, communication module 1 the 4th communication port is connected by Ethernet with destination end communication module 5 the 4th port.
Destination end comprises communication module 5, analysis module 6, recover module 7 and control desk module 8, wherein control desk module 8 first communication port is connected with communication module 5 first communication port, control desk module 8 second communication port is connected with analysis module 6 first communication port, control desk module 8 third communication port is connected with recovery module 7, communication module 5 second communication port is connected with analysis module 6 second communication port, communication module 5 third communication port is connected with recovery module 7 second communication port, communication module 5 the 4th communication port is connected by Ethernet with source communications module 1 the 4th port.
Communication module 1 realizes source by Ethernet and communicates with destination end, and the information that analysis module 2, backup module 3, control desk module 4 send is sent to destination end communication module 5 by Ethernet by communication module 1.
Analysis module 2 collects source platform information and database information, 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, log information.The destination end platform information that analysis module 2 is collected by communication module 1 receiving target end analysis module 6, contrast source platform information and destination end platform information, draw source, destination end platform variance analysis table export control desk module 4 to.Analysis module, according to the source database information of platform variance analysis table, collection and migration algorithm, is formulated migration scheme and is exported control desk module 1 to, according to the manual intervention information that control desk module 4 is fed back, generates Migration Wizard and instructs migration.Source platform information, source database information, platform variance analysis table, migration scheme, Migration Wizard are sent to communication module 1 by analysis module 2.
The manual intervention that backup module 3 sends according to Migration Wizard, migration algorithm and control desk performs source Oracel Database Backup operations, and feedback often walks the result of operation to control desk module 4 and communication module 1.
Control desk module 4 is for realizing man-machine interaction.
Communication module 5 is by Ethernet realize target end and source communications, and the information that analysis module 2, backup module 3, control desk module 4 send is sent to source communications module 1 by Ethernet by communication module 5.
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.Analysis module 6 receives the source database information of source analysis module 2 collection by 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 control desk module 8 to.Analysis module 6 by destination end platform information, destination end database information, Database Consistency Checking table, be sent to communication module 5.
Recover module 7 and perform 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 control desk module 8 and communication module 5.
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 step is as follows:
1) source, destination end platform variance analysis tableau format is formulated;
2) migration scheme proposals corresponding to every bar difference is formulated;
3) if source database version is Oracle9i, then importing/derivation mode is used to move;
4) if source database version is Oracle10g or Oracle11g, then different moving methods and different dump files transmission suggestion is selected according to different data volumes and time window;
41) if data volume <1T, time window is 8h ~ 12h, and suggestion adopts XTTS(can transmission table space) mode perform Data Migration, and adopt FTP to transmit or the mode Mobile data file of NFS transfer server;
42) if data volume <1T, time window is 12h ~ 48h, adopts the mode of data pump to perform Data Migration;
43) if data volume 1T ~ 5T, time window is 8h ~ 24h, adopts XTTS(can transmission table space) mode perform Data Migration, and adopt FTP to transmit or the mode Mobile data file of NFS transfer server;
44) if data volume 1T ~ 5T, time window is 24h ~ 48h, adopts the mode of data pump to perform Data Migration;
45) if data volume 5T ~ 10T, time window is 8h ~ 48h, adopts XTTS(can transmission table space) mode perform Data Migration, and adopt NFS transfer server or store again the mode Mobile data file of carry.
46) if data volume >10T, time window is 8h ~ 48h, and suggestion adopts XTTS(can transmission table space) mode perform Data Migration, and adopt the mode Mobile data file storing again carry.
5) estimate transit time according to table information, user profile, storing process information, comprise DB Backup time, dump file transmission time, database recovery time;
6) analysis module 2 generates migration scheme proposals according to above information, and migration scheme proposals is sent to control desk module 4 and communication module 1;
7) according to the decision-making of user to migration scheme proposals, Migration Wizard is generated.
Import and export Backup and Restore algorithm steps as follows:
1) backup module 3 performs originating mobile subscriber Database Consistency Checking;
2) backup module 3 backup source client database, generates dump file, feedback result;
3) user is pointed out to transmit dump file;
4) user confirms dump file end of transmission by source control desk module 4 or destination end control desk module 8;
5) recover module 7 and import user library in destination end, and feedback result;
6) recover module 7 and perform consistency check in target database, feedback check result;
7) 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 source database, destination end Database Consistency Checking table, and by source database, destination end Database Consistency Checking table is sent to control desk module 8 for hand inspection, by source database, destination end Database Consistency Checking table is sent to communication module 5 can obtain consensus information to make user equally in source control desk module 4.
XTTS Backup and Restore algorithm steps is as follows:
1) target database is created:
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;
2) environment checking:
Checking source database and target database the respective option, comprising: system platform, syllable sequence, character set, time zone version, audiomonitor, TNS;
3) initialization:
Generate migration script, modifying target storehouse system default table space;
4) target database subscriber's meter space is deleted;
5) map user is created;
6) source database metadatabase is derived;
7) the self-contained inspection in subscriber's meter space;
8) source database subscriber's meter spatiality is changed;
9) source database subscriber's meter Metadata is derived;
10) data file of a mobile meta data file and format is below adopted;
101) mode of FTP transmission is adopted;
102) NFS is adopted to do the mode of intermediate server;
103) mode storing again carry is adopted;
11) converting source data database data file syllable sequence;
12) source database subscriber's meter Metadata is imported;
13) restore target database user table space state;
14) source database metadata is imported;
15) target database subsequent treatment;
Restoring system default table space, invalidated object compiles;
16) reduction source database subscriber's meter spatiality;
17) 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 source database, destination end Database Consistency Checking table, and by source database, destination end Database Consistency Checking table is sent to control desk module 8 for hand inspection, by source database, destination end Database Consistency Checking table is sent to communication module 5 can obtain consensus information to make user equally in source control desk module 4.
Data pump Backup and Restore algorithm steps is as follows:
1) at source database derived data to dump file, if move to Oracle10g from Oracle11g, derive time, need formulate parameter version.As moved to Oracle10.2.0.1.0 from 11g, deriving statement is:
EXPDPUSERID='test/testorclassysdba'schemas=testdirectory=DATA_PUMP_DIRdumpfile=test.dmplogfile=test.logversion=10.2.0.1.0；
2) mobile dump file is to object library;
3) data are imported in dump file to object library;
4) 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 source database, destination end Database Consistency Checking table, and by source database, destination end Database Consistency Checking table is sent to control desk module 8 for hand inspection, by source database, destination end Database Consistency Checking table is sent to communication module 5 can obtain consensus information to make user equally in source control desk module 4.
Embodiment:
By reference to the accompanying drawings 1, this example specifically comprises the following steps:
1) source and destination end software are connected by Ethernet after all starting.
2) user is mutual by control desk module 4 and instrument in source, or mutual by control desk module 8 and instrument in destination end.
3) user assigns to instrument and starts to analyze order.
4) source analysis module 2 collects source platform information and database information, 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, log information.
5) destination end analysis module 6 collects destination end platform information, and platform information comprises processor architecture information, instruction set information, syllable sequence information, compiler information, operation system information, system variable information and filesystem information.
6) destination end platform information is sent to source analysis module 2 by communication module 5, communication module 1 by destination end analysis module 6.
7) source analysis module 2 contrasts source platform information and destination end platform information, generates source, destination end platform variance analysis table, and platform variance analysis table is sent to control desk module 4 and communication module 1.
8) source analysis module 2 generates Migration Wizard according to platform variance analysis table, source database information, Migration Wizard generating algorithm.
9) backup module 3, recovery module 7, destination end analysis module 6 completes migration operation according to Backup and Restore algorithm.
Above-mentioned embodiment is only concrete case of the present invention; scope of patent protection of the present invention includes but not limited to above-mentioned embodiment; claims of any a kind of oracle database Migration tools from HPUX platform to KUX platform migration according to the invention and the those of ordinary skill of any described technical field to its suitable change done or replacement, all should fall into scope of patent protection of the present invention.
Claims (10)
1. one kind from HPUX platform to the oracle database Migration tools of KUX platform migration, it is characterized in that, be divided into source and destination end two parts, source is installed on HP-UX server platform, destination end is installed on K-UX platform, source and destination end, by ethernet communication, all can operate this instrument in source and destination end; Source and destination end scan respective place platform environment, according to scanning result and migration algorithm, generate migration assessment report and migration scheme proposals; According to user, Migration Wizard is generated to the screening of migration scheme proposals and migration algorithm, by Migration Wizard to the prompting of user and guidance, realize the cross-platform cross version semi automatic migration of oracle database data from hp-ux platform to K-UX platform.
2. a kind of oracle database Migration tools from HPUX platform to KUX platform migration according to claim 1, it is characterized in that, described source comprises communication module, analysis module, backup module and control desk module, in this source, the communication port of control desk module connects linking parsing module, backup module and communication module respectively; The communication port of analysis module, backup module all connects above-mentioned communication module;
Described destination end comprises communication module, analysis module, recovery module and control desk module, and in this destination end, the communication port of control desk module connects linking parsing module respectively, recovers module and communication module; The communication port of analysis module, recovery module all connects communication module, and the communication module of this destination end also connects the communication module of above-mentioned source.
3. a kind of oracle database Migration tools from HPUX platform to KUX platform migration according to claim 2, it is characterized in that, described communication module realizes source by Ethernet and communicates with destination end, and the information that wherein analysis module of this source, backup module, control desk module send by the communication module of source is sent to the communication module of destination end by Ethernet; The information of the analysis module of this destination end, backup module, the transmission of control desk module is sent to the communication module of source by the communication module of destination end by Ethernet.
4. a kind of oracle database Migration tools from HPUX platform to KUX platform migration according to claim 2, it is characterized in that, the analysis module of source collects source platform information and database information, the analysis module of destination end 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, the database information of source, the database information that destination end is recovered includes database version information, data amount information, table information, index information, storing process information, user profile, log information,
The analysis module of source passes through the destination end platform information of the analysis module collection of the communication module receiving target end of source, contrast source platform information and destination end platform information, draws source, control desk module that destination end platform variance analysis table exports source to; The analysis module of destination end receives the source database information of source analysis module collection by the communication module of destination end, contrast source database information and the database information that recovered of destination end, draw source database, destination end Database Consistency Checking table export control desk module to;
Source analysis module is according to the source database information of platform variance analysis table, collection and migration algorithm, formulate the control desk module that migration scheme exports source to, according to the manual intervention information of 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 the communication module of source by source analysis module; Destination end analysis module by destination end platform information, destination end database information, Database Consistency Checking table, be sent to the communication module of destination end.
5. a kind of oracle database Migration tools from HPUX platform to KUX platform migration according to claim 2, it is characterized in that, the manual intervention that the backup module of described source sends according to Migration Wizard, migration algorithm and control desk performs source Oracel Database Backup operations, and the feedback result that often walks operation is to the control desk module of source and communication module; The recovery module of destination end performs the recovery operation of source oracle database according to the manual intervention that Migration Wizard, migration algorithm and control desk send, and the feedback result that often walks operation is to the control desk module of destination end and communication module.
6. a kind of oracle database Migration tools from HPUX platform to KUX platform migration according to claim 2, it is characterized in that, the control desk module of described source and the control desk module of destination end are all for realizing man-machine interaction.
7. a kind of oracle database Migration tools from HPUX platform to KUX platform migration according to claim 4, it is characterized in that, described 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; Wherein,
Migration Wizard generating algorithm step is as follows:
1) source, destination end platform variance analysis tableau format is formulated;
2) migration scheme proposals corresponding to every bar difference is formulated;
3) according to source database version, different modes is selected to move;
4) estimate transit time according to table information, user profile, storing process information, transit time here comprises DB Backup time, dump file transmission time, database recovery time;
5) analysis module generates migration scheme proposals according to above information, and migration scheme proposals is sent to control desk module and the communication module of source;
6) according to the decision-making of user to migration scheme proposals, Migration Wizard is generated;
Import and export Backup and Restore algorithm steps as follows:
1) backup module performs originating mobile subscriber Database Consistency Checking;
2) backup module backup source client database, generates dump file, feedback result;
3) user is pointed out to transmit dump file;
4) user confirms dump file end of transmission by source control desk module or destination end control desk module;
5) recover module and import user library in destination end, and feedback result;
6) recover module and perform consistency check in target database, feedback check result;
7) destination end analysis module 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 contrasts one by one, generate source database, destination end Database Consistency Checking table, and by source database, destination end Database Consistency Checking table is sent to control desk module for hand inspection, by source database, destination end Database Consistency Checking table is sent to communication module can obtain consensus information to make user equally in source control desk module,
XTTS Backup and Restore algorithm steps is as follows:
1) target database is created;
2) environment checking, namely verifies source database and target database the respective option;
3) initialization, generates migration script, modifying target storehouse system default table space;
4) target database subscriber's meter space is deleted;
5) map user is created;
6) source database metadatabase is derived;
7) the self-contained inspection in subscriber's meter space;
8) source database subscriber's meter spatiality is changed;
9) source database subscriber's meter Metadata is derived;
10) data file of mobile meta data file and format;
11) converting source data database data file syllable sequence;
12) source database subscriber's meter Metadata is imported;
13) restore target database user table space state;
14) source database metadata is imported;
15) target database subsequent treatment, restoring system default table space, invalidated object compiles;
16) reduction source database subscriber's meter spatiality;
17) destination end analysis module 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 contrasts one by one, generate source database, destination end Database Consistency Checking table, and by source database, destination end Database Consistency Checking table is sent to control desk module for hand inspection, by source database, destination end Database Consistency Checking table is sent to communication module, consensus information can be obtained equally in source control desk module to make user,
Data pump Backup and Restore algorithm steps is as follows:
1) at source database derived data to dump file;
2) mobile dump file is to object library;
3) data are imported in dump file to object library;
4) destination end analysis module 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 contrasts one by one, generate source database, destination end Database Consistency Checking table, and by source database, destination end Database Consistency Checking table is sent to control desk module for hand inspection, by source database, destination end Database Consistency Checking table is sent to communication module, consensus information can be obtained equally in source control desk module to make user.
8. a kind of oracle database Migration tools from HPUX platform to KUX platform migration according to claim 7, it is characterized in that, in described Migration Wizard generating algorithm, the detailed process of step 3) is:
If source database version is Oracle9i, then importing/derivation mode is used to move;
If source database version is Oracle10g or Oracle11g, then select different moving methods and different dump files transmission suggestion according to different data volumes and time window:
As data volume <1T, when time window is 8h ~ 12h, adopts and the mode of transmission table space X TTS can perform Data Migration, and adopt FTP to transmit or the mode Mobile data file of NFS transfer server;
As data volume <1T, when time window is 12h ~ 48h, the mode of data pump is adopted to perform Data Migration;
As data volume 1T ~ 5T, when time window is 8h ~ 24h, adopts and the mode of transmission table space X TTS can perform Data Migration, and adopt FTP to transmit or the mode Mobile data file of NFS transfer server;
As data volume 1T ~ 5T, when time window is 24h ~ 48h, the mode of data pump is adopted to perform Data Migration;
As data volume 5T ~ 10T, when time window is 8h ~ 48h, adopts and the mode of transmission table space X TTS can perform Data Migration, and adopt NFS transfer server or store again the mode Mobile data file of carry;
As data volume >10T, when time window is 8h ~ 48h, adopts and the mode of transmission table space X TTS can perform Data Migration, and adopt the mode Mobile data file storing again carry.
9. a kind of oracle database Migration tools from HPUX platform to KUX platform migration according to claim 7, it is characterized in that, in described XTTS Backup and Restore algorithm, adopt the mode of DBCA to create target database, the object library that establishment is gone out is identical with storehouse, source parameters; After target database has created, the option content of environment checking comprises system platform, syllable sequence, character set, time zone version, audiomonitor, TNS.
10. a kind of oracle database Migration tools from HPUX platform to KUX platform migration according to claim 7, it is characterized in that, in described XTTS Backup and Restore algorithm, step 10) adopts following either type to move the data file of meta data file and format:
Adopt the mode of FTP transmission;
Or adopt NFS to do the mode of intermediate server;
Or adopt the mode storing again carry.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510479782.6A CN105138603A (en) | 2015-08-07 | 2015-08-07 | Oracle database migration tool for carrying out migration from HP-UX platform to K-UX platform |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510479782.6A CN105138603A (en) | 2015-08-07 | 2015-08-07 | Oracle database migration tool for carrying out migration from HP-UX platform to K-UX platform |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105138603A true CN105138603A (en) | 2015-12-09 |
Family
ID=54723951
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510479782.6A Pending CN105138603A (en) | 2015-08-07 | 2015-08-07 | Oracle database migration tool for carrying out migration from HP-UX platform to K-UX platform |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105138603A (en) |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106484842A (en) * | 2016-09-29 | 2017-03-08 | 郑州云海信息技术有限公司 | A kind of method that oracle database changes character set |
| CN106934045A (en) * | 2017-03-16 | 2017-07-07 | 郑州云海信息技术有限公司 | A kind of system and method for database migration assessment |
| CN107193943A (en) * | 2017-05-19 | 2017-09-22 | 郑州云海信息技术有限公司 | A kind of method and apparatus of RDBMS online datas migration |
| CN108959470A (en) * | 2018-06-20 | 2018-12-07 | 郑州云海信息技术有限公司 | A kind of database data cross-platform migration method and device |
| CN109299072A (en) * | 2018-10-16 | 2019-02-01 | 郑州云海信息技术有限公司 | A kind of method and device that database migrates online |
| CN109933416A (en) * | 2019-02-01 | 2019-06-25 | 广东安可云科技有限公司 | A kind of moving method, device and storage medium using data |
| CN110019138A (en) * | 2017-12-29 | 2019-07-16 | 中国移动通信集团公司 | A kind of transmission table space Autonomic Migration Framework method and system based on Zabbix |
| CN110059075A (en) * | 2019-03-26 | 2019-07-26 | 阿里巴巴集团控股有限公司 | A kind of method, apparatus of database migration, equipment and computer-readable medium |
| CN111241070A (en) * | 2020-02-14 | 2020-06-05 | 苏州浪潮智能科技有限公司 | Data migration device, method, system and storage medium of cross-CPU architecture |
| CN111522798A (en) * | 2020-06-18 | 2020-08-11 | 腾讯科技（深圳）有限公司 | Data synchronization method, device, equipment and readable storage medium |
| CN112256670A (en) * | 2020-10-10 | 2021-01-22 | 中国农业银行股份有限公司河北省分行 | Data migration method, terminal device and readable storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104573122A (en) * | 2015-02-09 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | Oracle database migration tool migrating from AIX platform to K-UX platform |
| CN104573123A (en) * | 2015-02-09 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | Sybase database migration tool migrating from AIX platform to K-UX platform |
| CN104573121A (en) * | 2015-02-09 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | DB2 database migration tool migrating from AIX platform to K-UX platform |
-
2015
- 2015-08-07 CN CN201510479782.6A patent/CN105138603A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104573122A (en) * | 2015-02-09 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | Oracle database migration tool migrating from AIX platform to K-UX platform |
| CN104573123A (en) * | 2015-02-09 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | Sybase database migration tool migrating from AIX platform to K-UX platform |
| CN104573121A (en) * | 2015-02-09 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | DB2 database migration tool migrating from AIX platform to K-UX platform |
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106484842A (en) * | 2016-09-29 | 2017-03-08 | 郑州云海信息技术有限公司 | A kind of method that oracle database changes character set |
| CN106934045B (en) * | 2017-03-16 | 2020-10-20 | 苏州浪潮智能科技有限公司 | System and method for migration evaluation of database |
| CN106934045A (en) * | 2017-03-16 | 2017-07-07 | 郑州云海信息技术有限公司 | A kind of system and method for database migration assessment |
| 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 |
| CN108959470A (en) * | 2018-06-20 | 2018-12-07 | 郑州云海信息技术有限公司 | A kind of database data cross-platform migration method and device |
| CN109299072A (en) * | 2018-10-16 | 2019-02-01 | 郑州云海信息技术有限公司 | A kind of method and device that database migrates online |
| CN109299072B (en) * | 2018-10-16 | 2022-06-10 | 郑州云海信息技术有限公司 | Method and device for online migration of database |
| CN109933416A (en) * | 2019-02-01 | 2019-06-25 | 广东安可云科技有限公司 | A kind of moving method, device and storage medium using data |
| CN109933416B (en) * | 2019-02-01 | 2023-09-05 | 广东安可云科技有限公司 | Application data migration method and device and storage medium |
| TWI754837B (en) * | 2019-03-26 | 2022-02-11 | 大陸商螞蟻金服（杭州）網絡技術有限公司 | Method, apparatus, device and computer-readable medium for database migration |
| US11308048B2 (en) | 2019-03-26 | 2022-04-19 | Beijing Oceanbase Technology Co., Ltd. | Database migration method, apparatus, device, and computer-readable medium |
| CN110059075A (en) * | 2019-03-26 | 2019-07-26 | 阿里巴巴集团控股有限公司 | A kind of method, apparatus of database migration, equipment and computer-readable medium |
| CN111241070A (en) * | 2020-02-14 | 2020-06-05 | 苏州浪潮智能科技有限公司 | Data migration device, method, system and storage medium of cross-CPU architecture |
| CN111241070B (en) * | 2020-02-14 | 2023-01-10 | 苏州浪潮智能科技有限公司 | Data migration device, method, system and storage medium of cross-CPU architecture |
| CN111522798A (en) * | 2020-06-18 | 2020-08-11 | 腾讯科技（深圳）有限公司 | Data synchronization method, device, equipment and readable storage medium |
| CN112256670A (en) * | 2020-10-10 | 2021-01-22 | 中国农业银行股份有限公司河北省分行 | Data migration method, terminal device and readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105138603A (en) | Oracle database migration tool for carrying out migration from HP-UX platform to K-UX platform | |
| CN104573122A (en) | Oracle database migration tool migrating from AIX platform to K-UX platform | |
| CN104899333A (en) | Cross-platform migrating method and system for Oracle database | |
| CN104573121A (en) | DB2 database migration tool migrating from AIX platform to K-UX platform | |
| CN101763064B (en) | Numerical control machining process design system and method of aircraft complex components facing process object | |
| CN104573123A (en) | Sybase database migration tool migrating from AIX platform to K-UX platform | |
| CN104899332A (en) | Cross-platform migrating method and system for Sybase database | |
| CN108959470A (en) | A kind of database data cross-platform migration method and device | |
| CN102054217B (en) | Entity morphing in metamodel-based tools | |
| CN101841515A (en) | Target variable protocol data unit codec code automatic generation implementation method | |
| CN102053911A (en) | Automated testing method and system based on Android and mobile terminal | |
| CN105786912A (en) | Data acquisition and transformation method and device | |
| CN103927385A (en) | Unifying method and device of data model | |
| CN103605660A (en) | Graphic processing method for SCD (Substation Configuration Description) file | |
| CN109933416A (en) | A kind of moving method, device and storage medium using data | |
| CN104598233A (en) | Code generation method | |
| CN103440279A (en) | Data adapter and data adaptation method thereof in data acquisition process | |
| CN102541282B (en) | Utilize icon moving to the method, the Apparatus and system that complete vocabulary and edit again | |
| CN102521008B (en) | Program compiling device and method for compiling program | |
| CN103473173B (en) | A kind of method and device iOS system being carried out to assembly level dynamic debugging | |
| Nour | Performance of different (BIM/IFC) exchange formats within private collaborative workspace for collaborative work | |
| CN104572102A (en) | Method for solving Chinese messy codes in JAVA | |
| CN105550176A (en) | Basic mapping method for relational database and XML | |
| CN101794240A (en) | Method and system for aggregating data content | |
| CN106682275A (en) | Load processing method and device for industrial plant structural modeling |
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 | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20151209 |