CN104573122A - Oracle database migration tool migrating from AIX platform to K-UX platform - Google Patents
Oracle database migration tool migrating from AIX platform to K-UX platform Download PDFInfo
- Publication number
- CN104573122A CN104573122A CN201510065707.5A CN201510065707A CN104573122A CN 104573122 A CN104573122 A CN 104573122A CN 201510065707 A CN201510065707 A CN 201510065707A CN 104573122 A CN104573122 A CN 104573122A
- Authority
- CN
- China
- Prior art keywords
- migration
- module
- platform
- database
- information
- 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.)
- Granted
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
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 particularly relates to an Oracle database migration tool migrating from an AIX platform to a K-UX platform. According to the Oracle database migration tool migrating from the AIX platform to the K-UX platform, the software architecture of the migration tool based on a JAVA platform is divided into a source end and a target end, wherein the AIX platform is the source end while the K-UX platform is the target end, and the source end is communicated with the target end by virtue of the Ethernet. The Oracle database migration tool migrating from the AIX platform to the K-UX platform is simple and reasonable in structure and realizes migration of the Oracle database from the AIX platform to the K-UX platform, so that the database migration difficulty is extremely reduced, the workload is extremely reduced, the working time is extremely shortened and the work efficiency is extremely improved.
Description
Technical field
The present invention relates to the cross-platform migrating technology field of database, particularly a kind of oracle database Migration tools from AIX platform to K-UX 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 AIX 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
The present invention, in order to make up the defect of prior art, provides a kind of brief, efficient from AIX platform to the oracle database Migration tools of K-UX platform migration.
The present invention is achieved through the following technical solutions:
A kind of oracle database Migration tools from AIX platform to K-UX platform migration, it is characterized in that: the software architecture of described Migration tools is based on JAVA platform, be divided into source and destination end, wherein AIX platform is source, K-UX platform is destination end, realizes source communicate with destination end by Ethernet; Described 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.
Described source comprises communication module a(1), analysis module a(2), backup module (3) and control desk module a(4), described destination end comprises communication module b(5), analysis module b(6), recover module (7) and control desk module b(8), described control desk module (4, 8) for realizing man-machine interaction, control desk module (4, 8) the first communication port and communication module (1, 5) the first communication port is connected, control desk module (4, 8) second communication port and analysis module (2, 6) the first communication port is connected, control desk module a(4) third communication port is connected with backup module (3), control desk module b(8) third communication port with recovery module (7) be connected, communication module (1, 5) second communication port and analysis module (2, 6) second communication port is connected, communication module a(1) third communication port is connected with backup module (3) second communication port, communication module b(5) third communication port with recovery module (7) second communication port be connected, source communications module a(1) the 4th communication port and destination end communication module b(5) the 4th port is connected by Ethernet, described communication module (1,5) by analysis module a(2), backup module (3) and control desk module a(4) information and analysis module b(6), recover module (7) and control desk module b(8) information realize alternately, realizing source and destination end communication and control by Ethernet.
Described analysis module a(2) collect source platform information and database information, analysis module a(2) by communication module a(1) receiving and analyzing module b(6) the destination end platform information collected, contrast source platform information and destination end platform information, draws source, destination end platform variance analysis table exports control desk module a(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 control desk module a(4) the manual intervention information fed back, generate Migration Wizard and instruct migration; Analysis module a(2) source platform information, source database information, platform variance analysis table, migration scheme, Migration Wizard are sent to communication module a(1); Described analysis module b(6) collect destination end platform information and the database information recovered; Analysis module b(6) by communication module b(5) receive source analysis module a(2) the source database information collected, 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 b(8 to); Analysis module b(6) by destination end platform information, destination end database information, Database Consistency Checking table, be sent to communication module b(5).
Described platform information comprises processor architecture information, instruction set information, syllable sequence information, compiler information, operation system information, system variable information and filesystem information, and described database information and the database information recovered comprise database version information, data amount information, table information, index information, storing process information, user profile, log information.
Described backup module (3) is according to Migration Wizard, migration algorithm and control desk module a(4) the manual intervention information and executing source oracle database backup operation that sends, and feedback often walks the result of operation to control desk module a(4) with communication module a(1); Described recovery module (7) is according to Migration Wizard, migration algorithm and control desk module b(8) the manual intervention information and executing source oracle database recovery operation that sends, and feedback often walks the result of operation to control desk module b(8) with communication module b(5).
Described migration algorithm comprises Migration Wizard generating algorithm, importing/derivation Backup and Restore algorithm, XTTS Backup and Restore algorithm and data pump Backup and Restore algorithm.
Described Migration Wizard generating algorithm step is as follows:
1) migration scheme proposals corresponding to source, destination end platform variance analysis tableau format and each difference is formulated;
2) when source database version is Oracle 9i, then importing/derivation Backup and Restore algorithm is used to move;
3) when source database version is Oracle 10g or Oracle 11g, then different moving methods and different dump files transmission suggestion is selected according to different data volumes and time window;
As data volume <1T, when time window is 8h ~ 12h, adopts XTTS Backup and Restore algorithm to perform Data Migration, and adopt the mode Mobile data file of FTP transmission or NFS transfer server;
As data volume <1T, when time window is 12h ~ 48h, data pump Backup and Restore algorithm is adopted to perform Data Migration;
As data volume 1T ~ 5T, when time window is 8h ~ 24h, adopts XTTS Backup and Restore algorithm to perform Data Migration, and adopt the mode Mobile data file of FTP transmission or NFS transfer server;
As data volume 1T ~ 5T, when time window is 24h ~ 48h, data pump Backup and Restore algorithm is adopted to perform Data Migration;
As data volume 5T ~ 10T, when time window is 8h ~ 48h, adopt XTTS Backup and Restore algorithm to 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 XTTS Backup and Restore algorithm to 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 a(2) generate migration scheme proposals according to above information, and migration scheme proposals is sent to control desk module a(4) and communication module a(1);
7) finally according to the decision-making of user to migration scheme proposals, Migration Wizard is generated.
Described importing/derivation Backup and Restore algorithm steps is 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 is by source control desk module a(4) or destination end control desk module b(8) confirm dump file end of transmission;
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.
Described XTTS Backup and Restore algorithm steps is as follows:
1) target database is created
The template establishment target database generated when adopting the mode of DBCA to use storehouse, source to create, the object library created out with this is identical with storehouse, source parameters, decreases 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, 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) adopt the mode of FTP transmission, the mode that NFS does intermediate server or the mode storing again carry move the data file of 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, comprises restoring system default table space and invalidated object compiling;
16) reduction source database subscriber's meter spatiality.
Described 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.
The invention has the beneficial effects as follows: be somebody's turn to do the oracle database Migration tools from AIX platform to K-UX platform migration, simple and reasonable, achieve oracle database from AIX platform to the migration of K-UX platform, significantly reduce database migration difficulty, decrease workload, shorten the working time, improve work efficiency.
Accompanying drawing explanation
Accompanying drawing 1 is invention oracle database Migration tools configuration diagram.
Embodiment
Below in conjunction with accompanying drawing, the present invention will be described in detail.
Be somebody's turn to do the oracle database Migration tools from AIX platform to K-UX platform migration, its software architecture, based on JAVA platform, is divided into source and destination end, and wherein AIX platform is source, and K-UX platform is destination end, realizes source communicate with destination end by Ethernet; Described 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.
Described source comprises communication module a(1), analysis module a(2), backup module (3) and control desk module a(4), described destination end comprises communication module b(5), analysis module b(6), recover module (7) and control desk module b(8), described control desk module (4, 8) for realizing man-machine interaction, control desk module (4, 8) the first communication port and communication module (1, 5) the first communication port is connected, control desk module (4, 8) second communication port and analysis module (2, 6) the first communication port is connected, control desk module a(4) third communication port is connected with backup module (3), control desk module b(8) third communication port with recovery module (7) be connected, communication module (1, 5) second communication port and analysis module (2, 6) second communication port is connected, communication module a(1) third communication port is connected with backup module (3) second communication port, communication module b(5) third communication port with recovery module (7) second communication port be connected, source communications module a(1) the 4th communication port and destination end communication module b(5) the 4th port is connected by Ethernet, described communication module (1,5) by analysis module a(2), backup module (3) and control desk module a(4) information and analysis module b(6), recover module (7) and control desk module b(8) information realize alternately, realizing source and destination end communication and control by Ethernet.
Described analysis module a(2) collect source platform information and database information, analysis module a(2) by communication module a(1) receiving and analyzing module b(6) the destination end platform information collected, contrast source platform information and destination end platform information, draws source, destination end platform variance analysis table exports control desk module a(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 control desk module a(4) the manual intervention information fed back, generate Migration Wizard and instruct migration; Analysis module a(2) source platform information, source database information, platform variance analysis table, migration scheme, Migration Wizard are sent to communication module a(1); Described analysis module b(6) collect destination end platform information and the database information recovered; Analysis module b(6) by communication module b(5) receive source analysis module a(2) the source database information collected, 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 b(8 to); Analysis module b(6) by destination end platform information, destination end database information, Database Consistency Checking table, be sent to communication module b(5).
Described platform information comprises processor architecture information, instruction set information, syllable sequence information, compiler information, operation system information, system variable information and filesystem information, and described database information and the database information recovered comprise database version information, data amount information, table information, index information, storing process information, user profile, log information.
Described backup module (3) is according to Migration Wizard, migration algorithm and control desk module a(4) the manual intervention information and executing source oracle database backup operation that sends, and feedback often walks the result of operation to control desk module a(4) with communication module a(1); Described recovery module (7) is according to Migration Wizard, migration algorithm and control desk module b(8) the manual intervention information and executing source oracle database recovery operation that sends, and feedback often walks the result of operation to control desk module b(8) with communication module b(5).
Described migration algorithm comprises Migration Wizard generating algorithm, importing/derivation Backup and Restore algorithm, XTTS Backup and Restore algorithm and data pump Backup and Restore algorithm.
Described Migration Wizard generating algorithm step is as follows:
1) migration scheme proposals corresponding to source, destination end platform variance analysis tableau format and each difference is formulated;
2) when source database version is Oracle 9i, then importing/derivation Backup and Restore algorithm is used to move;
3) when source database version is Oracle 10g or Oracle 11g, then different moving methods and different dump files transmission suggestion is selected according to different data volumes and time window;
As data volume <1T, when time window is 8h ~ 12h, adopts XTTS Backup and Restore algorithm to perform Data Migration, and adopt the mode Mobile data file of FTP transmission or NFS transfer server;
As data volume <1T, when time window is 12h ~ 48h, data pump Backup and Restore algorithm is adopted to perform Data Migration;
As data volume 1T ~ 5T, when time window is 8h ~ 24h, adopts XTTS Backup and Restore algorithm to perform Data Migration, and adopt the mode Mobile data file of FTP transmission or NFS transfer server;
As data volume 1T ~ 5T, when time window is 24h ~ 48h, data pump Backup and Restore algorithm is adopted to perform Data Migration;
As data volume 5T ~ 10T, when time window is 8h ~ 48h, adopt XTTS Backup and Restore algorithm to 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 XTTS Backup and Restore algorithm to 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 a(2) generate migration scheme proposals according to above information, and migration scheme proposals is sent to control desk module a(4) and communication module a(1);
7) finally according to the decision-making of user to migration scheme proposals, Migration Wizard is generated.
Described importing/derivation Backup and Restore algorithm steps is 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 is by source control desk module a(4) or destination end control desk module b(8) confirm dump file end of transmission;
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.
Described XTTS Backup and Restore algorithm steps is as follows:
1) target database is created
The template establishment target database generated when adopting the mode of DBCA to use storehouse, source to create, the object library created out with this is identical with storehouse, source parameters, decreases 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, 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) adopt the mode of FTP transmission, the mode that NFS does intermediate server or the mode storing again carry move the data file of 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, comprises restoring system default table space and invalidated object compiling;
16) reduction source database subscriber's meter spatiality.
Described data pump Backup and Restore algorithm steps is as follows:
1) at source database derived data to dump file, when moving to Oracle 10g from Oracle 11g, derive time, need formulate parameter version, as moved to Oracle 10.2.0.1.0 from 11g, derive statement be:
EXPDP USERID='test/test@orcl as sysdba' schemas=test directory=DATA_PUMP_DIR dumpfile=test.dmp logfile=test.log version=10.2.0.1.0
2) mobile dump file is to object library;
3) data are imported in dump file to object library.
Claims (10)
1. one kind from AIX platform to the oracle database Migration tools of K-UX platform migration, it is characterized in that: the software architecture of described Migration tools is based on JAVA platform, be divided into source and destination end, wherein AIX platform is source, K-UX platform is destination end, realizes source communicate with destination end by Ethernet; Described 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.
2. the oracle database Migration tools from AIX platform to K-UX platform migration according to claim 1, it is characterized in that: described source comprises communication module a(1), analysis module a(2), backup module (3) and control desk module a(4), described destination end comprises communication module b(5), analysis module b(6), recover module (7) and control desk module b(8), described control desk module (4, 8) for realizing man-machine interaction, control desk module (4, 8) the first communication port and communication module (1, 5) the first communication port is connected, control desk module (4, 8) second communication port and analysis module (2, 6) the first communication port is connected, control desk module a(4) third communication port is connected with backup module (3), control desk module b(8) third communication port with recovery module (7) be connected, communication module (1, 5) second communication port and analysis module (2, 6) second communication port is connected, communication module a(1) third communication port is connected with backup module (3) second communication port, communication module b(5) third communication port with recovery module (7) second communication port be connected, source communications module a(1) the 4th communication port and destination end communication module b(5) the 4th port is connected by Ethernet, described communication module (1,5) by analysis module a(2), backup module (3) and control desk module a(4) information and analysis module b(6), recover module (7) and control desk module b(8) information realize alternately, realizing source and destination end communication and control by Ethernet.
3. according to the oracle database Migration tools from AIX platform to K-UX platform migration according to claim 2, it is characterized in that: described analysis module a(2) collect source platform information and database information, analysis module a(2) by communication module a(1) receiving and analyzing module b(6) the destination end platform information collected, contrast source platform information and destination end platform information, draws source, destination end platform variance analysis table exports control desk module a(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 control desk module a(4) the manual intervention information fed back, generate Migration Wizard and instruct migration; Analysis module a(2) source platform information, source database information, platform variance analysis table, migration scheme, Migration Wizard are sent to communication module a(1); Described analysis module b(6) collect destination end platform information and the database information recovered; Analysis module b(6) by communication module b(5) receive source analysis module a(2) the source database information collected, 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 b(8 to); Analysis module b(6) by destination end platform information, destination end database information, Database Consistency Checking table, be sent to communication module b(5).
4. according to the oracle database Migration tools from AIX platform to K-UX platform migration according to claim 3, it is characterized in that: described 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 and the database information recovered comprise database version information, data amount information, table information, index information, storing process information, user profile, log information.
5. according to the oracle database Migration tools from AIX platform to K-UX platform migration according to claim 2, it is characterized in that: described backup module (3) is according to Migration Wizard, migration algorithm and control desk module a(4) the manual intervention information and executing source oracle database backup operation that sends, and feedback often walks the result of operation to control desk module a(4) with communication module a(1); Described recovery module (7) is according to Migration Wizard, migration algorithm and control desk module b(8) the manual intervention information and executing source oracle database recovery operation that sends, and feedback often walks the result of operation to control desk module b(8) with communication module b(5).
6. the oracle database Migration tools from AIX platform to K-UX platform migration according to claim 1 or 3 or 5, is characterized in that: described migration algorithm comprises Migration Wizard generating algorithm, importing/derivation Backup and Restore algorithm, XTTS Backup and Restore algorithm and data pump Backup and Restore algorithm.
7. the oracle database Migration tools from AIX platform to K-UX platform migration according to claim 3 or 6, is characterized in that: described Migration Wizard generating algorithm step is as follows:
1) migration scheme proposals corresponding to source, destination end platform variance analysis tableau format and each difference is formulated;
2) when source database version is Oracle 9i, then importing/derivation Backup and Restore algorithm is used to move;
3) when source database version is Oracle 10g or Oracle 11g, then different moving methods and different dump files transmission suggestion is selected according to different data volumes and time window;
As data volume <1T, when time window is 8h ~ 12h, adopts XTTS Backup and Restore algorithm to perform Data Migration, and adopt the mode Mobile data file of FTP transmission or NFS transfer server;
As data volume <1T, when time window is 12h ~ 48h, data pump Backup and Restore algorithm is adopted to perform Data Migration;
As data volume 1T ~ 5T, when time window is 8h ~ 24h, adopts XTTS Backup and Restore algorithm to perform Data Migration, and adopt the mode Mobile data file of FTP transmission or NFS transfer server;
As data volume 1T ~ 5T, when time window is 24h ~ 48h, data pump Backup and Restore algorithm is adopted to perform Data Migration;
As data volume 5T ~ 10T, when time window is 8h ~ 48h, adopt XTTS Backup and Restore algorithm to 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 XTTS Backup and Restore algorithm to 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 a(2) generate migration scheme proposals according to above information, and migration scheme proposals is sent to control desk module a(4) and communication module a(1);
7) finally according to the decision-making of user to migration scheme proposals, Migration Wizard is generated.
8. the oracle database Migration tools from AIX platform to K-UX platform migration according to claim 5 or 6 or 7, is characterized in that: described importing/derivation Backup and Restore algorithm steps is 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 is by source control desk module a(4) or destination end control desk module b(8) confirm dump file end of transmission;
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.
9. the oracle database Migration tools from AIX platform to K-UX platform migration according to claim 5 or 6 or 7, is characterized in that: described XTTS Backup and Restore algorithm steps is as follows:
1) target database is created
The template establishment target database generated when adopting the mode of DBCA to use storehouse, source to create, the object library created out with this is identical with storehouse, source parameters, decreases 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, 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) adopt the mode of FTP transmission, the mode that NFS does intermediate server or the mode storing again carry move the data file of 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, comprises restoring system default table space and invalidated object compiling;
16) reduction source database subscriber's meter spatiality.
10. the oracle database Migration tools from AIX platform to K-UX platform migration according to claim 5 or 6 or 7, is characterized in that: described 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.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510065707.5A CN104573122B (en) | 2015-02-09 | 2015-02-09 | It is a kind of from AIX platforms to the oracle database Migration tools of K UX platform migrations |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510065707.5A CN104573122B (en) | 2015-02-09 | 2015-02-09 | It is a kind of from AIX platforms to the oracle database Migration tools of K UX platform migrations |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104573122A true CN104573122A (en) | 2015-04-29 |
| CN104573122B CN104573122B (en) | 2017-10-13 |
Family
ID=53089184
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510065707.5A Active CN104573122B (en) | 2015-02-09 | 2015-02-09 | It is a kind of from AIX platforms to the oracle database Migration tools of K UX platform migrations |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104573122B (en) |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104899333A (en) * | 2015-06-24 | 2015-09-09 | 浪潮(北京)电子信息产业有限公司 | Cross-platform migrating method and system for Oracle database |
| CN105095506A (en) * | 2015-08-31 | 2015-11-25 | 浪潮(北京)电子信息产业有限公司 | Sybase database migration method and system |
| CN105095507A (en) * | 2015-08-31 | 2015-11-25 | 浪潮(北京)电子信息产业有限公司 | DB2 database migration method, device and system |
| CN105095505A (en) * | 2015-08-31 | 2015-11-25 | 浪潮(北京)电子信息产业有限公司 | HP-UK platform-to-K-UX platform database migration method and apparatus |
| CN105138603A (en) * | 2015-08-07 | 2015-12-09 | 浪潮电子信息产业股份有限公司 | Oracle database migration tool for carrying out migration from HP-UX platform to K-UX platform |
| CN105550258A (en) * | 2015-12-09 | 2016-05-04 | 浪潮电子信息产业股份有限公司 | DB2 database migration tool for migration between platforms |
| CN106484842A (en) * | 2016-09-29 | 2017-03-08 | 郑州云海信息技术有限公司 | A kind of method that oracle database changes character set |
| CN106777345A (en) * | 2017-01-16 | 2017-05-31 | 山东浪潮商用系统有限公司 | A kind of data pick-up loading method based on mass data migration |
| CN108763419A (en) * | 2018-05-24 | 2018-11-06 | 郑州云海信息技术有限公司 | A kind of method, apparatus and computer storage media of migration process |
| CN108848154A (en) * | 2018-06-08 | 2018-11-20 | 珠海市微半导体有限公司 | A kind of method of mobile terminal Overpassing Platform by Using |
| 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 |
| CN109165260A (en) * | 2018-09-25 | 2019-01-08 | 安徽信息工程学院 | Method of data transfer based on ORACLE data basd link |
| CN109299072A (en) * | 2018-10-16 | 2019-02-01 | 郑州云海信息技术有限公司 | A kind of method and device that database migrates online |
| CN110019138A (en) * | 2017-12-29 | 2019-07-16 | 中国移动通信集团公司 | A kind of transmission table space Autonomic Migration Framework method and system based on Zabbix |
| CN115905167A (en) * | 2022-11-10 | 2023-04-04 | 上海威固信息技术股份有限公司 | Intelligent data storage method and system capable of rapidly migrating data |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
|---|---|---|---|---|
| US6996589B1 (en) * | 2002-01-16 | 2006-02-07 | Convergys Cmg Utah, Inc. | System and method for database conversion |
| CN101266606A (en) * | 2007-03-15 | 2008-09-17 | 阿里巴巴公司 | On-line data migration method based on Oracle database |
| CN101650744A (en) * | 2009-09-16 | 2010-02-17 | 中兴通讯股份有限公司 | System and method for processing great data amount based on transport tablespace |
| CN102262662A (en) * | 2011-07-22 | 2011-11-30 | 浪潮(北京)电子信息产业有限公司 | System, device and method for realizing database data migration in heterogeneous platform |
| CN103440273A (en) * | 2013-08-06 | 2013-12-11 | 北京航空航天大学 | Data cross-platform migration method and device |
-
2015
- 2015-02-09 CN CN201510065707.5A patent/CN104573122B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6996589B1 (en) * | 2002-01-16 | 2006-02-07 | Convergys Cmg Utah, Inc. | System and method for database conversion |
| CN101266606A (en) * | 2007-03-15 | 2008-09-17 | 阿里巴巴公司 | On-line data migration method based on Oracle database |
| CN101650744A (en) * | 2009-09-16 | 2010-02-17 | 中兴通讯股份有限公司 | System and method for processing great data amount based on transport tablespace |
| CN102262662A (en) * | 2011-07-22 | 2011-11-30 | 浪潮(北京)电子信息产业有限公司 | System, device and method for realizing database data migration in heterogeneous platform |
| CN103440273A (en) * | 2013-08-06 | 2013-12-11 | 北京航空航天大学 | Data cross-platform migration method and device |
Non-Patent Citations (2)
| Title |
|---|
| 吴伟平: ""GBase数据库迁移系统的设计与实现", 《中国优秀博硕士学位论文全文数据库 (硕士) 信息科技辑》 * |
| 陈新: ""ORACLE数据库跨平台迁移的方法"", 《医学信息》 * |
Cited By (20)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104899333A (en) * | 2015-06-24 | 2015-09-09 | 浪潮(北京)电子信息产业有限公司 | Cross-platform migrating method and system for Oracle database |
| CN105138603A (en) * | 2015-08-07 | 2015-12-09 | 浪潮电子信息产业股份有限公司 | Oracle database migration tool for carrying out migration from HP-UX platform to K-UX platform |
| CN105095506A (en) * | 2015-08-31 | 2015-11-25 | 浪潮(北京)电子信息产业有限公司 | Sybase database migration method and system |
| CN105095507A (en) * | 2015-08-31 | 2015-11-25 | 浪潮(北京)电子信息产业有限公司 | DB2 database migration method, device and system |
| CN105095505A (en) * | 2015-08-31 | 2015-11-25 | 浪潮(北京)电子信息产业有限公司 | HP-UK platform-to-K-UX platform database migration method and apparatus |
| CN105550258A (en) * | 2015-12-09 | 2016-05-04 | 浪潮电子信息产业股份有限公司 | DB2 database migration tool for migration between platforms |
| CN106484842A (en) * | 2016-09-29 | 2017-03-08 | 郑州云海信息技术有限公司 | A kind of method that oracle database changes character set |
| CN106777345B (en) * | 2017-01-16 | 2020-07-28 | 浪潮软件科技有限公司 | Data extraction loading method based on mass data migration |
| CN106777345A (en) * | 2017-01-16 | 2017-05-31 | 山东浪潮商用系统有限公司 | A kind of data pick-up loading method based on mass data migration |
| CN110019138A (en) * | 2017-12-29 | 2019-07-16 | 中国移动通信集团公司 | A kind of transmission table space Autonomic Migration Framework method and system based on Zabbix |
| CN108763419A (en) * | 2018-05-24 | 2018-11-06 | 郑州云海信息技术有限公司 | A kind of method, apparatus and computer storage media of migration process |
| CN108848154A (en) * | 2018-06-08 | 2018-11-20 | 珠海市微半导体有限公司 | A kind of method of mobile terminal Overpassing Platform by Using |
| 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 |
| CN109165260A (en) * | 2018-09-25 | 2019-01-08 | 安徽信息工程学院 | Method of data transfer based on ORACLE data basd link |
| 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 |
| CN115905167A (en) * | 2022-11-10 | 2023-04-04 | 上海威固信息技术股份有限公司 | Intelligent data storage method and system capable of rapidly migrating data |
| CN115905167B (en) * | 2022-11-10 | 2023-11-21 | 上海威固信息技术股份有限公司 | Intelligent data storage method and system capable of rapidly migrating data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104573122B (en) | 2017-10-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| 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 | |
| CN105138603A (en) | Oracle database migration tool for carrying out migration from HP-UX platform to K-UX platform | |
| CN104573121A (en) | DB2 database migration tool migrating from AIX platform to K-UX platform | |
| JP6416194B2 (en) | Scalable analytic platform for semi-structured data | |
| CN104573123A (en) | Sybase database migration tool migrating from AIX platform to K-UX platform | |
| CN108959470A (en) | A kind of database data cross-platform migration method and device | |
| CN104899332A (en) | Cross-platform migrating method and system for Sybase database | |
| CN101841515B (en) | Target variable protocol data unit codec code automatic generation implementation method | |
| CN104572895A (en) | MPP (Massively Parallel Processor) database and Hadoop cluster data intercommunication method, tool and realization method | |
| CN109933416A (en) | A kind of moving method, device and storage medium using data | |
| CN111061739A (en) | Method and device for warehousing massive medical data, electronic equipment and storage medium | |
| CN104598233A (en) | Code generation method | |
| KR101357135B1 (en) | Apparatus for Collecting Log Information | |
| CN106227397A (en) | Computing cluster job management system based on application virtualization technology and method | |
| CN114556317A (en) | Document tracking through version hash link graphs | |
| CN104572471A (en) | Index-based Java software code clone detection method | |
| CN103473173B (en) | A kind of method and device iOS system being carried out to assembly level dynamic debugging | |
| CN110674109B (en) | Data importing method, system, computer equipment and computer readable storage medium | |
| CN114048188A (en) | Cross-database data migration system and method | |
| CN111984745B (en) | Database field dynamic expansion method, device, equipment and storage medium | |
| CN102508916A (en) | File fingerprint analyzing method for massive data | |
| CN202364244U (en) | Processing device of distributed log analysis system | |
| CN103927384A (en) | Multi-hierarchy data synchronism method and system between heterogeneous systems through HTML script analysis | |
| 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |