CN104573122B - It is a kind of from AIX platforms to the oracle database Migration tools of K UX platform migrations - Google Patents
It is a kind of from AIX platforms to the oracle database Migration tools of K UX platform migrations Download PDFInfo
- Publication number
- CN104573122B CN104573122B CN201510065707.5A CN201510065707A CN104573122B CN 104573122 B CN104573122 B CN 104573122B CN 201510065707 A CN201510065707 A CN 201510065707A CN 104573122 B CN104573122 B CN 104573122B
- Authority
- CN
- China
- Prior art keywords
- module
- migration
- database
- information
- source
- 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.)
- Active
Links
- 238000013508 migration Methods 0.000 title claims abstract description 147
- 230000005012 migration Effects 0.000 title claims abstract description 147
- 238000004891 communication Methods 0.000 claims description 67
- 238000004422 calculation algorithm Methods 0.000 claims description 61
- 238000004458 analytical method Methods 0.000 claims description 60
- 230000005540 biological transmission Effects 0.000 claims description 27
- 238000011084 recovery Methods 0.000 claims description 27
- 101000746134 Homo sapiens DNA endonuclease RBBP8 Proteins 0.000 claims description 21
- 101000969031 Homo sapiens Nuclear protein 1 Proteins 0.000 claims description 21
- 102100021133 Nuclear protein 1 Human genes 0.000 claims description 21
- 238000000034 method Methods 0.000 claims description 11
- 238000012546 transfer Methods 0.000 claims description 9
- 238000003860 storage Methods 0.000 claims description 7
- 230000008676 import Effects 0.000 claims description 6
- 230000008569 process Effects 0.000 claims description 6
- 230000008859 change Effects 0.000 claims description 4
- 238000007689 inspection Methods 0.000 claims description 3
- 230000003993 interaction Effects 0.000 claims description 3
- 238000005457 optimization Methods 0.000 claims description 3
- 230000009467 reduction Effects 0.000 claims description 3
- 238000012216 screening Methods 0.000 claims description 3
- 238000000151 deposition Methods 0.000 claims 1
- 238000012360 testing method Methods 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
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 present invention is more particularly directed to a kind of from AIX platforms to the oracle database Migration tools of K UX platform migrations.This is from AIX platforms to the oracle database Migration tools of K UX platform migrations, the software architecture of the Migration tools is based on JAVA platforms, is divided into source and destination end, wherein AIX platforms are source, K UX platforms are destination end, realize that source communicates with destination end by Ethernet.This is simple and reasonable from AIX platforms to the oracle database Migration tools of K UX platform migrations, realizes oracle database from AIX platforms to the migration of K UX platforms, significantly reduce database migration difficulty, workload is reduced, the working time is shortened, operating efficiency is improved.
Description
Technical field
The present invention relates to the cross-platform migrating technology field of database, more particularly to one kind is from AIX platforms to K-UX platforms
The oracle database Migration tools of migration.
Background technology
High-end server carries the core application of industry, and being widely used in the key such as finance, telecommunications, the energy, traffic should
With field, it, which runs, is directly connected to society, economic normal operation.For a long time, due to lack high-end server design and
Manufacturing capacity, China's high-end server markets hold for foreign vendor always, and wherein Hewlett-Packard occupies more than 20% domestic city 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, availability reaches 99.999%, and system Transaction Processing ability reaches that the world first intakes
It is flat.To improve the autonomous controllability of informatization Grand Equipments, increasing information system 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, specific information system
Build and practice level, increasing cross-platform migration work is presented as, wherein there is suitable migration work to be from AIX platforms
To tide K-UX platforms.
Database is the kernel software of IT system, and database migration is also a part particularly important during IT system is built.
Due to cpu instruction collection difference, operating system difference and the compiler difference of heterogeneous server platforms so that database cross platform
Migrate difficulty high, workload is big.Transplanting difficulty how is reduced, workload is reduced, is that database cross platform migration needs to solve
Key issue.
The content of the invention
The present invention is brief, efficient from AIX platforms to K-UX platforms there is provided one kind for the defect for making up prior art
The oracle database Migration tools of migration.
The present invention is achieved through the following technical solutions：
A kind of oracle database Migration tools from AIX platforms to K-UX platform migrations, it is characterised in that：The migration
The software architecture of instrument is based on JAVA platforms, is divided into source and destination end, wherein AIX platforms are source, and K-UX platforms are target
End, realizes that source communicates with destination end by Ethernet；The source and destination end are scanned to each place platform environment,
According to scanning result and migration algorithm, generation migration assessment report is advised with migration scheme；Migration scheme is advised according to user
Screening and migration algorithm generation Migration Wizard, oracle database is realized in prompting and guidance by Migration Wizard to user
Cross-platform cross version semi automatic migration of the data from other server platforms to K-UX platforms.
The migration algorithm includes Migration Wizard generating algorithm, importing/export Backup and Restore algorithm, the calculation of XTTS Backup and Restores
Method and data pump Backup and Restore algorithm.
The Migration Wizard generating algorithm step is as follows：
1）Formulate source, destination end platform variance analysis tableau format and the corresponding migration scheme suggestion of each difference；
2）When source database version is Oracle 9i, then migrated using importing/export Backup and Restore algorithm；
3）When source database version is Oracle 10g or Oracle 11g, then according to different data volumes and time
The different moving method of window selection and different dump file transmission suggestions；
Work as data volume<1T, when time window is 8h ~ 12h, using XTTS Backup and Restore algorithm performs Data Migrations, and is adopted
With FTP transmission or the mode mobile data file of NFS transfer servers；
Work as data volume<1T, when time window is 12h ~ 48h, using data pump Backup and Restore algorithm performs Data Migration；
As data volume 1T ~ 5T, when time window is 8h ~ 24h, using XTTS Backup and Restore algorithm performs Data Migrations, and
The mobile data file by the way of FTP transmission or NFS transfer servers；
As data volume 1T ~ 5T, when time window is 24h ~ 48h, using data pump Backup and Restore algorithm performs Data Migration；
As data volume 5T ~ 10T, when time window is 8h ~ 48h, using XTTS Backup and Restore algorithm performs Data Migrations, and
The mobile data file by the way of NFS transfer servers or storage again carry；
Work as data volume>10T, when time window is 8h ~ 48h, using XTTS Backup and Restore algorithm performs Data Migrations, and is adopted
With the mode mobile data file of storage again carry；
5）Transit time is estimated according to table information, user profile, storing process information, including the DB Backup time, turned
Store up file transmission time, database recovery time；
6）Analysis module a（2）Migration scheme suggestion is generated according to information above, and migration scheme suggestion transmission is extremely controlled
Platform module a（4）With communication module a（1）；
7）The decision-making advised finally according to user to migration scheme, generates Migration Wizard.
The source includes communication module a（1）, analysis module a（2）, backup module（3）With console module a（4）, institute
Stating destination end includes communication module b（5）, analysis module b（6）, recovery module（7）With console module b（8）；The console
Module（4,8）For realizing man-machine interaction, console module（4,8）First COM1 and communication module（1,5）First communication
Port is connected, console module（4,8）Second COM1 and analysis module（2,6）First COM1 is connected, console mould
Block a（4）Third communication port and backup module（3）It is connected, console module b（8）Third communication port and recovery module（7）Phase
Even, communication module（1,5）Second COM1 and analysis module（2,6）Second COM1 is connected, communication module a（1）3rd
COM1 and backup module（3）Second COM1 is connected, communication module b（5）Third communication port and recovery module（7）The
Two COM1s are connected, source communications module a（1）Fourth communication port and destination end communication module b（5）4th port by with
Net very much and be connected；The communication module（1,5）By analysis module a（2）, backup module（3）With console module a（4）Information with
Analysis module b（6）, recovery module（7）With console module b（8）Information by Ethernet realize interact, realize source and mesh
Mark end communication and control.
The analysis module a（2）Collect source platform information and database information, analysis module a（2）Pass through communication module
a（1）Receive analysis module b（6）The destination end platform information of collection, contrast source platform information and destination end platform information, are obtained
Go out source, destination end platform variance analysis table to export to console module a（4）；Analysis module is according to platform variance analysis table, receipts
The source database information and migration algorithm of collection, formulate migration scheme and export to console module（1）, according to console module
a（4）The manual intervention information of feedback, generation Migration Wizard instructs migration；Analysis module a（2）By source platform information, source number
Sent according to storehouse information, platform variance analysis table, migration scheme, Migration Wizard to communication module a（1）；The analysis module b（6）
Collect destination end platform information and the database information recovered；Analysis module b（6）Pass through communication module b（5）Receive source point
Analyse module a（2）The source database information of collection, the database information that contrast source database information has recovered with destination end,
Show that source database, destination end Database Consistency Checking table are exported to console module b（8）；Analysis module b（6）By mesh
Mark holds station information, destination end database information, Database Consistency Checking table, transmission to communication module b level with both hands（5）.
The platform information includes processor architecture information, instruction set information, syllable sequence information, compiler information, operation
System information, system variable information and filesystem information, the database information and the database information recovered include number
According to storehouse version information, data amount information, table information, index information, storing process information, user profile, log information.
The backup module（3）According to Migration Wizard, migration algorithm and console module a（4）The manual intervention letter of transmission
Breath performs source oracle database backup operation, and feeds back and often walk the result of operation to console module a（4）With communication module
a（1）；The recovery module（7）According to Migration Wizard, migration algorithm and console module b（8）The manual intervention information of transmission is held
Row source oracle database recovery operation, and feed back and often walk the result of operation to console module b（8）With communication module b
（5）.
The importing/export Backup and Restore algorithm steps are as follows：
1）Backup module（3）Perform originating mobile subscriber Database Consistency Checking；
2）Backup module（3）Backup source client database, generates dump file, feedback result；
3）Point out user transmission dump file；
4）User passes through source console module a（4）Or destination end console module b（8）Confirm that dump file is transferred
Finish；
5）Recovery module（7）User library, and feedback result are imported in destination end；
6）Recovery module（7）Consistency check is performed in target database, inspection result is fed back.
The XTTS Backup and Restores algorithm steps are as follows：
1）Create target database
The template establishment target database generated when being created by the way of DBCA using source storehouse, the target being created that with this
Storehouse and source storehouse parameters are identicals, reduce the manual interventions such as succeeding target storehouse optimization；
2）Environment is verified
Source database and target database the respective option are verified, including：System platform, syllable sequence, character set, time zone version
Sheet, monitor, TNS；
3）Initialization, generation migration script, changes object library system default table space；
4）Delete target database user table space；
5）Create map user；
6）Export source database metadatabase；
7）User's table space is self-contained to be checked；
8）Change source database user's table space state；
9）Export source database user's table space metadata；
10）By the way of FTP is transmitted, NFS does the mode of intermediate server or the mode of storage carry again moves member
The data file of data file and format；
11）Converting source data storehouse data file syllable sequence；
12）Import source database user's table space metadata；
13）Reduce target database user's table space state；
14）Import source database metadata；
15）Target database subsequent treatment, including reduction system default table space and invalidated object compiling；
16）Reduce source database user's table space state.
The data pump Backup and Restore algorithm steps are as follows：
1）Data are exported to dump files in source database；
2）Dump files are moved to object library；
3）Data are imported in dump files to object library.
The beneficial effects of the invention are as follows：This is from AIX platforms to the oracle database Migration tools of K-UX platform migrations, knot
Structure advantages of simple, realizes oracle database from AIX platforms to the migration of K-UX platforms, significantly reduces database migration
Difficulty, reduces workload, shortens the working time, improves operating efficiency.
Brief description of the drawings
Accompanying drawing 1 is invention oracle database Migration tools configuration diagram.
Embodiment
The present invention will be described in detail below in conjunction with the accompanying drawings.
This is from AIX platforms to the oracle database Migration tools of K-UX platform migrations, and its software architecture is flat based on JAVA
Platform, is divided into source and destination end, wherein AIX platforms are source, and K-UX platforms are destination end, and source and mesh are realized by Ethernet
Mark end communication；The source and destination end are scanned to each place platform environment, raw according to scanning result and migration algorithm
Advise into migration assessment report with migration scheme；The screening advised according to user to migration scheme and migration algorithm generation migration to
Lead, prompting and guidance by Migration Wizard to user realize oracle database data from other server platforms to K-UX
The cross-platform cross version semi automatic migration of platform.
The migration algorithm includes Migration Wizard generating algorithm, importing/export Backup and Restore algorithm, the calculation of XTTS Backup and Restores
Method and data pump Backup and Restore algorithm.
The Migration Wizard generating algorithm step is as follows：
1）Formulate source, destination end platform variance analysis tableau format and the corresponding migration scheme suggestion of each difference；
2）When source database version is Oracle 9i, then migrated using importing/export Backup and Restore algorithm；
3）When source database version is Oracle 10g or Oracle 11g, then according to different data volumes and time
The different moving method of window selection and different dump file transmission suggestions；
Work as data volume<1T, when time window is 8h ~ 12h, using XTTS Backup and Restore algorithm performs Data Migrations, and is adopted
With FTP transmission or the mode mobile data file of NFS transfer servers；
Work as data volume<1T, when time window is 12h ~ 48h, using data pump Backup and Restore algorithm performs Data Migration；
As data volume 1T ~ 5T, when time window is 8h ~ 24h, using XTTS Backup and Restore algorithm performs Data Migrations, and
The mobile data file by the way of FTP transmission or NFS transfer servers；
As data volume 1T ~ 5T, when time window is 24h ~ 48h, using data pump Backup and Restore algorithm performs Data Migration；
As data volume 5T ~ 10T, when time window is 8h ~ 48h, using XTTS Backup and Restore algorithm performs Data Migrations, and
The mobile data file by the way of NFS transfer servers or storage again carry；
Work as data volume>10T, when time window is 8h ~ 48h, using XTTS Backup and Restore algorithm performs Data Migrations, and is adopted
With the mode mobile data file of storage again carry；
5）Transit time is estimated according to table information, user profile, storing process information, including the DB Backup time, turned
Store up file transmission time, database recovery time；
6）Analysis module a（2）Migration scheme suggestion is generated according to information above, and migration scheme suggestion transmission is extremely controlled
Platform module a（4）With communication module a（1）；
7）The decision-making advised finally according to user to migration scheme, generates Migration Wizard.
The source includes communication module a（1）, analysis module a（2）, backup module（3）With console module a（4）, institute
Stating destination end includes communication module b（5）, analysis module b（6）, recovery module（7）With console module b（8）；The console
Module（4,8）For realizing man-machine interaction, console module（4,8）First COM1 and communication module（1,5）First communication
Port is connected, console module（4,8）Second COM1 and analysis module（2,6）First COM1 is connected, console mould
Block a（4）Third communication port and backup module（3）It is connected, console module b（8）Third communication port and recovery module（7）Phase
Even, communication module（1,5）Second COM1 and analysis module（2,6）Second COM1 is connected, communication module a（1）3rd
COM1 and backup module（3）Second COM1 is connected, communication module b（5）Third communication port and recovery module（7）The
Two COM1s are connected, source communications module a（1）Fourth communication port and destination end communication module b（5）4th port by with
Net very much and be connected；The communication module（1,5）By analysis module a（2）, backup module（3）With console module a（4）Information with
Analysis module b（6）, recovery module（7）With console module b（8）Information by Ethernet realize interact, realize source and mesh
Mark end communication and control.
The analysis module a（2）Collect source platform information and database information, analysis module a（2）Pass through communication module
a（1）Receive analysis module b（6）The destination end platform information of collection, contrast source platform information and destination end platform information, are obtained
Go out source, destination end platform variance analysis table to export to console module a（4）；Analysis module is according to platform variance analysis table, receipts
The source database information and migration algorithm of collection, formulate migration scheme and export to console module（1）, according to console module
a（4）The manual intervention information of feedback, generation Migration Wizard instructs migration；Analysis module a（2）By source platform information, source number
Sent according to storehouse information, platform variance analysis table, migration scheme, Migration Wizard to communication module a（1）；The analysis module b（6）
Collect destination end platform information and the database information recovered；Analysis module b（6）Pass through communication module b（5）Receive source point
Analyse module a（2）The source database information of collection, the database information that contrast source database information has recovered with destination end,
Show that source database, destination end Database Consistency Checking table are exported to console module b（8）；Analysis module b（6）By mesh
Mark holds station information, destination end database information, Database Consistency Checking table, transmission to communication module b level with both hands（5）.
The platform information includes processor architecture information, instruction set information, syllable sequence information, compiler information, operation
System information, system variable information and filesystem information, the database information and the database information recovered include number
According to storehouse version information, data amount information, table information, index information, storing process information, user profile, log information.
The backup module（3）According to Migration Wizard, migration algorithm and console module a（4）The manual intervention letter of transmission
Breath performs source oracle database backup operation, and feeds back and often walk the result of operation to console module a（4）With communication module
a（1）；The recovery module（7）According to Migration Wizard, migration algorithm and console module b（8）The manual intervention information of transmission is held
Row source oracle database recovery operation, and feed back and often walk the result of operation to console module b（8）With communication module b
（5）.
The importing/export Backup and Restore algorithm steps are as follows：
1）Backup module（3）Perform originating mobile subscriber Database Consistency Checking；
2）Backup module（3）Backup source client database, generates dump file, feedback result；
3）Point out user transmission dump file；
4）User passes through source console module a（4）Or destination end console module b（8）Confirm that dump file is transferred
Finish；
5）Recovery module（7）User library, and feedback result are imported in destination end；
6）Recovery module（7）Consistency check is performed in target database, inspection result is fed back.
The XTTS Backup and Restores algorithm steps are as follows：
1）Create target database
The template establishment target database generated when being created by the way of DBCA using source storehouse, the target being created that with this
Storehouse and source storehouse parameters are identicals, reduce the manual interventions such as succeeding target storehouse optimization；
2）Environment is verified
Source database and target database the respective option are verified, including：System platform, syllable sequence, character set, time zone version
Sheet, monitor, TNS；
3）Initialization, generation migration script, changes object library system default table space；
4）Delete target database user table space；
5）Create map user；
6）Export source database metadatabase；
7）User's table space is self-contained to be checked；
8）Change source database user's table space state；
9）Export source database user's table space metadata；
10）By the way of FTP is transmitted, NFS does the mode of intermediate server or the mode of storage carry again moves member
The data file of data file and format；
11）Converting source data storehouse data file syllable sequence；
12）Import source database user's table space metadata；
13）Reduce target database user's table space state；
14）Import source database metadata；
15）Target database subsequent treatment, including reduction system default table space and invalidated object compiling；
16）Reduce source database user's table space state.
The data pump Backup and Restore algorithm steps are as follows：
1）Data are exported to dump files in source database, when moving to Oracle 10g from Oracle 11g, in export
When, it is necessary to formulate parameter version, such as move to Oracle 10.2.0.1.0 from 11g, export sentence is：
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）Dump files are moved to object library；
3）Data are imported in dump files to object library.
Claims (8)
1. a kind of oracle database Migration tools from AIX platforms to K-UX platform migrations, it is characterised in that：The migration work
The software architecture of tool is based on JAVA platforms, is divided into source and destination end, wherein AIX platforms are source, and K-UX platforms are destination end,
Realize that source communicates with destination end by Ethernet；The source and destination end are scanned to each place platform environment, root
According to scanning result and migration algorithm, generation migration assessment report is advised with migration scheme；Migration scheme is advised according to user
Screening and migration algorithm generate Migration Wizard, and oracle database number is realized in prompting and guidance by Migration Wizard to user
According to the cross-platform cross version semi automatic migration from other server platforms to K-UX platforms；
The migration algorithm include Migration Wizard generating algorithm, importing/export Backup and Restore algorithm, XTTS Backup and Restores algorithm and
Data pump Backup and Restore algorithm；
The Migration Wizard generating algorithm step is as follows：
1）Formulate source, destination end platform variance analysis tableau format and the corresponding migration scheme suggestion of each difference；
2）When source database version is Oracle 9i, then migrated using importing/export Backup and Restore algorithm；
3）When source database version is Oracle 10g or Oracle 11g, then according to different data volume and time window
The different moving method of selection and different dump file transmission suggestions；
Work as data volume<1T, when time window is 8h ~ 12h, using XTTS Backup and Restore algorithm performs Data Migrations, and uses FTP
Transmission or the mode mobile data file of NFS transfer servers；
Work as data volume<1T, when time window is 12h ~ 48h, using data pump Backup and Restore algorithm performs Data Migration；
As data volume 1T ~ 5T, when time window is 8h ~ 24h, using XTTS Backup and Restore algorithm performs Data Migrations, and use
FTP transmission or the mode mobile data file of NFS transfer servers；
As data volume 1T ~ 5T, when time window is 24h ~ 48h, using data pump Backup and Restore algorithm performs Data Migration；
As data volume 5T ~ 10T, when time window is 8h ~ 48h, using XTTS Backup and Restore algorithm performs Data Migrations, and use
NFS transfer servers or the mode mobile data file for storing again carry；
Work as data volume>10T, when time window is 8h ~ 48h, using XTTS Backup and Restore algorithm performs Data Migrations, and using depositing
Store up again the mode mobile data file of carry；
5）Transit time, including DB Backup time, dump text are estimated according to table information, user profile, storing process information
Part transmission time, database recovery time；
6）Analysis module a（2）Migration scheme suggestion is generated according to information above, and migration scheme suggestion is sent to console mould
Block a（4）With communication module a（1）；
7）The decision-making advised finally according to user to migration scheme, generates Migration Wizard.
2. the oracle database Migration tools according to claim 1 from AIX platforms to K-UX platform migrations, its feature
It is：The source includes communication module a（1）, analysis module a（2）, backup module（3）With console module a（4）, the mesh
Marking end includes communication module b（5）, analysis module b（6）, recovery module（7）With console module b（8）；The console module
（4,8）For realizing man-machine interaction, console module（4,8）First COM1 and communication module（1,5）First COM1
It is connected, console module（4,8）Second COM1 and analysis module（2,6）First COM1 is connected, console module a
（4）Third communication port and backup module（3）It is connected, console module b（8）Third communication port and recovery module（7）It is connected,
Communication module（1,5）Second COM1 and analysis module（2,6）Second COM1 is connected, communication module a（1）The third communication
Port and backup module（3）Second COM1 is connected, communication module b（5）Third communication port and recovery module（7）Second leads to
Believe that port is connected, source communications module a（1）Fourth communication port and destination end communication module b（5）4th port passes through Ethernet
It is connected；The communication module（1,5）By analysis module a（2）, backup module（3）With console module a（4）Information and analysis
Module b（6）, recovery module（7）With console module b（8）Information by Ethernet realize interact, realize source and destination end
Communication and control.
3. according to the oracle database Migration tools from AIX platforms to K-UX platform migrations described in claim 2, its feature exists
In：The analysis module a（2）Collect source platform information and database information, analysis module a（2）Pass through communication module a（1）
Receive analysis module b（6）The destination end platform information of collection, contrast source platform information and destination end platform information, draw source
End, destination end platform variance analysis table are exported to console module a（4）；Analysis module according to platform variance analysis table, collect
Source database information and migration algorithm, formulate migration scheme and export to console module（1）, according to console module a（4）
The manual intervention information of feedback, generation Migration Wizard instructs migration；Analysis module a（2）By source platform information, source database
Information, platform variance analysis table, migration scheme, Migration Wizard are sent to communication module a（1）；The analysis module b（6）Collect
Destination end platform information and the database information recovered；Analysis module b（6）Pass through communication module b（5）Receive source analysis mould
Block a（2）The source database information of collection, the database information that contrast source database information has recovered with destination end, draws
Source database, destination end Database Consistency Checking table are exported to console module b（8）；Analysis module b（6）By destination end
Platform information, destination end database information, Database Consistency Checking table, transmission to communication module b（5）.
4. according to the oracle database Migration tools from AIX platforms to K-UX platform migrations described in claim 3, its feature exists
In：The platform information includes processor architecture information, instruction set information, syllable sequence information, compiler information, operating system letter
Breath, system variable information and filesystem information, the database information and the database information recovered include version database
This 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 platforms to K-UX platform migrations described in claim 2, its feature exists
In：The backup module（3）According to Migration Wizard, migration algorithm and console module a（4）The manual intervention information of transmission is performed
Source oracle database backup operation, and feed back and often walk the result of operation to console module a（4）With communication module a（1）；
The recovery module（7）According to Migration Wizard, migration algorithm and console module b（8）The manual intervention information of transmission performs source
Oracle database recovery operation is held, and feeds back and often walks the result of operation to console module b（8）With communication module b（5）.
6. the oracle database Migration tools according to claim 1 from AIX platforms to K-UX platform migrations, its feature
It is：The importing/export Backup and Restore algorithm steps are as follows：
1）Backup module（3）Perform originating mobile subscriber Database Consistency Checking；
2）Backup module（3）Backup source client database, generates dump file, feedback result；
3）Point out user transmission dump file；
4）User passes through source console module a（4）Or destination end console module b（8）Confirm dump file end of transmission；
5）Recovery module（7）User library, and feedback result are imported in destination end；
6）Recovery module（7）Consistency check is performed in target database, inspection result is fed back.
7. the oracle database Migration tools according to claim 1 from AIX platforms to K-UX platform migrations, its feature
It is：The XTTS Backup and Restores algorithm steps are as follows：
1）Create target database
The template establishment target database generated when being created by the way of DBCA using source storehouse, the object library being created that with this with
Source storehouse parameters are identicals, reduce the manual interventions such as succeeding target storehouse optimization；
2）Environment is verified
Source database and target database the respective option are verified, including：System platform, syllable sequence, character set, time zone version, prison
Listen device, TNS；
3）Initialization, generation migration script, changes object library system default table space；
4）Delete target database user table space；
5）Create map user；
6）Export source database metadatabase；
7）User's table space is self-contained to be checked；
8）Change source database user's table space state；
9）Export source database user's table space metadata；
10）By the way of FTP is transmitted, NFS does the mode of intermediate server or the mode of storage carry again moves metadata
The data file of file and format；
11）Converting source data storehouse data file syllable sequence；
12）Import source database user's table space metadata；
13）Reduce target database user's table space state；
14）Import source database metadata；
15）Target database subsequent treatment, including reduction system default table space and invalidated object compiling；
16）Reduce source database user's table space state.
8. the oracle database Migration tools according to claim 1 from AIX platforms to K-UX platform migrations, its feature
It is：The data pump Backup and Restore algorithm steps are as follows：
1）Data are exported to dump files in source database；
2）Dump files are moved to object library；
3）Data are imported in dump files 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 CN104573122A (en) | 2015-04-29 |
| CN104573122B true 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 (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 |
Families Citing this family (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 |
| 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 |
| CN105095505A (en) * | 2015-08-31 | 2015-11-25 | 浪潮(北京)电子信息产业有限公司 | HP-UK platform-to-K-UX platform database migration method and apparatus |
| CN105095507A (en) * | 2015-08-31 | 2015-11-25 | 浪潮(北京)电子信息产业有限公司 | DB2 database migration method, device and system |
| 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 |
| CN110019138B (en) * | 2017-12-29 | 2022-06-03 | 中国移动通信集团公司 | Automatic transfer table space migration 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 |
| 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 |
| CN109299072B (en) * | 2018-10-16 | 2022-06-10 | 郑州云海信息技术有限公司 | Method and device for online migration of database |
| CN115905167B (en) * | 2022-11-10 | 2023-11-21 | 上海威固信息技术股份有限公司 | Intelligent data storage method and system capable of rapidly migrating data |
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数据库迁移系统的设计与实现;吴伟平;《中国优秀博硕士学位论文全文数据库 (硕士) 信息科技辑》;20060915(第9期);第I138-344页 * |
| "ORACLE数据库跨平台迁移的方法";陈新;《医学信息》;20050815;第18卷(第8期);第886-888页 * |
Cited By (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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104573122A (en) | 2015-04-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104573122B (en) | It is a kind of from AIX platforms to the oracle database Migration tools of K UX platform migrations | |
| 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 | |
| CN105955208B (en) | Network robot data control system based on cloud platform | |
| CN104573121A (en) | DB2 database migration tool migrating from AIX platform to K-UX platform | |
| Zheng et al. | Real-time big data processing framework: challenges and solutions | |
| Brown et al. | Implementation patterns for microservices architectures | |
| US9009173B2 (en) | Using views of subsets of nodes of a schema to generate data transformation jobs to transform input files in first data formats to output files in second data formats | |
| Zhang et al. | Research on lightweight MVC framework based on spring MVC and mybatis | |
| CN108959470A (en) | A kind of database data cross-platform migration method and device | |
| CN104572895A (en) | MPP (Massively Parallel Processor) database and Hadoop cluster data intercommunication method, tool and realization method | |
| CN104933160B (en) | A kind of ETL frame design method towards safety monitoring business diagnosis | |
| CN101887410B (en) | File conversion device, file conversion method, and file conversion program | |
| CN102741811A (en) | Improving performance of template based JavaScript widgets | |
| CN106164867A (en) | The increment parallel processing of data | |
| CN104573123A (en) | Sybase database migration tool migrating from AIX platform to K-UX platform | |
| CN105700478A (en) | System and method for generating processing control data of numerical control machine tool | |
| CN106100880A (en) | A kind of cloud data resource is disposed and visual management method | |
| CN107480202B (en) | Data processing method and device for multiple parallel processing frameworks | |
| CN104899332A (en) | Cross-platform migrating method and system for Sybase database | |
| US20150089021A1 (en) | Project data management | |
| CN111061739A (en) | Method and device for warehousing massive medical data, electronic equipment and storage medium | |
| CN105022631A (en) | Scientific calculation-orientated floating-point data parallel lossless compression method | |
| CN101201833A (en) | System and method for filling PDF document data | |
| CN102508916B (en) | File fingerprint analyzing method for massive data |
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 |