CN108268341A - A kind of Data Migration, backup and restoration methods and device - Google Patents
A kind of Data Migration, backup and restoration methods and device Download PDFInfo
- Publication number
- CN108268341A CN108268341A CN201611259632.5A CN201611259632A CN108268341A CN 108268341 A CN108268341 A CN 108268341A CN 201611259632 A CN201611259632 A CN 201611259632A CN 108268341 A CN108268341 A CN 108268341A
- Authority
- CN
- China
- Prior art keywords
- partition
- data
- subregion
- backup
- target
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1458—Management of the backup or restore process
- G06F11/1469—Backup restoration techniques
-
- 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)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention discloses a kind of Data Migration, backup and restoration methods and device, method includes：The characteristic parameter of several partition tables is recorded, obtains partition information allocation list；Table space is established, each subregion in each partition table is mapped into corresponding table space, obtains subregion relation mapping table；Characteristic parameter in the partition information allocation list determines target partition, and the corresponding target table space of the target partition is determined, and carry out Data Migration, backup or recovery to the data file in the target table space according to the subregion relation mapping table；Wherein, each table space corresponds at least one data file.The embodiment of the present invention by table by carrying out fine-grained subregion, subregion is established respectively on corresponding table space, support Data Migration, backup and the recovery of random time, it is adapted to various databases, and Data Migration, backup and the data granularity of recovery can be effectively controlled, improve Data Migration, backup and the speed of recovery.
Description
Technical field
The present embodiments relate to field of computer technology, and in particular to a kind of Data Migration, backup and restoration methods and
Device.
Background technology
Any need uses the application of database to be required for storing various data, and data generally have different life
Period.Some data just need to move in another Database Systems after a period of time.Meanwhile data be also required to periodically into
Row backup, because may occur damaging due to storage medium or caused by personnel's maloperation, operating system failure itself
Data are not seen, can not read, lose.Once loss of data, it is necessary to be restored using data backup.Traditional data are moved
It moves, the granularity of backup can only be fine to table level, and migration is slow, backup is slow, restores also slow.
Data Migration, backup and the recovery of traditional Oracle is broadly divided into two major class：It Backup and Restore physically and patrols
Importing and exporting on volume；Wherein, backup physically is divided into as cold standby and Hot Spare.
Cold standby is happened at database in the case of normal switching-off, cold standby be by key file (data file,
Control file redoes log file, Parameter File) integrally copy other position to, can just it reach in this way
Another location carries out current backup target database completely constant duplication and reaches the purpose for restoring target database.But
The database level that the current Oracle prior arts scheme of above cold standby mode can only provide " sometime on point " is other
Restore (database full recovery, can not be directed to part be operated), can not by table, by user or according to business datum come into
The customization of row differentiated restores.Cold standby can only be directed to entire database and carry out Backup and Restore operation, therefore in addition to applying data
Except simultaneously also comprising the configuration control files such as daily record database in itself, and the backup of service application data cannot be provided solely for
Restore.
Hot Spare is in the case where database is run, using the method for Archivelog mode mode backup databases.
So if the cold standby of last night and having the Hot Spare file of today again, when problem occurs, it is possible to utilize
These data restore more information.Hot Spare requirement database operates, and need a large amount of shelves under Archivelog modes
Case space.Once database is operated under Archivelog states, it is possible to it backups, it can be in table space or database file grade
Backup.But Hot Spare can not also be provided from service layer as cold standby described above and be considered just for business datum
Customize redundancy technique and scheme.Hot Spare relies primarily on the archive log (Archivelog) when database is run to complete
Corresponding Backup and Restore, but restore according to being all record contents in specified archive log, and can not customised regions wherein
Point which data, which need which restores, does not need to restore, and the premise of Hot Spare is the filing function of needing to open database.
Export/importing (Export/Import) refers to pass through execution using the database management tools that Oracle is provided
Export orders extract data from database, can then the data extracted be sent back to Oracle using import
In database, support data library grade, table space grade, user class and the other Data Migration of table level, backup and recovery.Logic
The dump for being only applicable to toy data base, the backup of database logic structure etc. are imported and exported, although being capable of providing enough spirits
Activity and the effect that can be customized, but the efficiency of data transmission in export and importing process is constrained to, in face of large and medium-sized number
According to library scene when efficiency can not meet the requirements.
Current oracle provide technology in reply Backup and Restore and Data Migration can support level be：Database
Grade, table space grade, user class and table level are other；Such granularity level limited flexibility degree or bigger, alternative ratio
It is poor.
During the embodiment of the present invention is realized, inventor has found existing method either cold standby or Hot Spare
Mode, can only all provide backup and recovery of the database to upper total data is put in those years, and logic imports and exports only
Suitable for toy data base, and carry out Data Migration, backup and can only support that table level is other when restoring, data granularity rank
It is alternative poor.
Invention content
Due to existing method either cold standby or Hot Spare mode, database can only be all provided to certain a period of time in the past
Between put the backup and recovery of upper total data, importing and exporting for logic is only applicable to toy data base, and carries out Data Migration, standby
Part and restore when can only support that table level is other, data granularity rank alternative it is poor the problem of, the embodiment of the present invention carries
Go out a kind of Data Migration, backup and restoration methods and device.
In a first aspect, the embodiment of the present invention proposes a kind of Data Migration, backup and restoration methods, including：
The characteristic parameter of several partition tables is recorded, obtains partition information allocation list；
Table space is established, each subregion in each partition table is mapped into corresponding table space, subregion relationship is obtained and reflects
Firing table；
Characteristic parameter in the partition information allocation list determines target partition, according to the subregion relation mapping table
Determine the corresponding target table space of the target partition, and the data file in the target table space is carried out Data Migration,
Backup restores；
Wherein, each table space corresponds at least one data file.
Optionally, several described partition tables obtain after carrying out subregion to pending data according to target partition mode.
Optionally, the table space of establishing specifically includes：
According to the corresponding number of partitions of the target partition mode, the table space of the number of partitions is established.
Optionally, the data file in the target table space carries out Data Migration, backup or recovery, specific to wrap
It includes：
Data Migration, backup or recovery are carried out to the data file in the target table space according to predetermined period.
Optionally, the target partition mode includes range partition, list partition, hash partition, referred partitions and interval
Subregion.
Second aspect, the embodiment of the present invention also propose a kind of Data Migration, backup and recovery device, including：
Allocation list acquisition module for recording the characteristic parameter of several partition tables, obtains partition information allocation list；
Each subregion in each partition table for establishing table space, is mapped to corresponding table by mapping table acquisition module
Space obtains subregion relation mapping table；
Data processing module determines target partition for the characteristic parameter in the partition information allocation list, according to
The subregion relation mapping table determines the corresponding target table space of the target partition, and to the data in the target table space
File carries out Data Migration, backup or recovery；
Wherein, each table space corresponds at least one data file.
Optionally, several partition tables described in the allocation list acquisition module according to target partition mode to pending number
According to carry out subregion after obtain.
Optionally, table space is established described in the mapping table acquisition module to specifically include：
According to the corresponding number of partitions of the target partition mode, the table space of the number of partitions is established.
Optionally, Data Migration, standby is carried out to the data file in the target table space in the data processing module
Part is restored, and is specifically included：
Data Migration, backup or recovery are carried out to the data file in the target table space according to predetermined period.
Optionally, the target partition mode includes range partition, list partition, hash partition, referred partitions and interval
Subregion.
As shown from the above technical solution, the embodiment of the present invention is built subregion by the way that table is carried out fine-grained subregion respectively
It stands on corresponding table space, supports Data Migration, backup and the recovery of random time, be adapted to various databases, and can
Effectively control Data Migration, backup and the data granularity of recovery, improve Data Migration, backup and the speed of recovery.
Description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, to embodiment or will show below
There is attached drawing needed in technology description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
Some embodiments of invention, for those of ordinary skill in the art, without creative efforts, can be with
Other attached drawings are obtained according to these figures.
Fig. 1 is the flow diagram of a kind of Data Migration, backup and restoration methods that one embodiment of the invention provides；
Fig. 2 is the schematic diagram of a kind of subregion relationship map that one embodiment of the invention provides；
Fig. 3 is the structure diagram of a kind of Data Migration, backup and recovery device that one embodiment of the invention provides.
Specific embodiment
Below in conjunction with the accompanying drawings, the specific embodiment of the present invention is further described.Following embodiment is only used for more
Technical scheme of the present invention is clearly demonstrated, and is not intended to limit the protection scope of the present invention and limits the scope of the invention.
Term of the present invention is illustrated first below：
Table space：The logical partitioning of database, for combining the logic unit of accessed data, separation is related to data visit
The I/O asked, a table space are made of one or more data files.
Data file：The file of database stores truthful data, includes the data needed for user data and system.
Data Migration：Data are transferred to another place from a place.
Data backup：Operation error or the system failure occur for anti-locking system leads to loss of data, and will be all or part of
Data acquisition system copies to the process of other storage mediums from the hard disk or array of applied host machine.
Data are restored：When storage medium occurs damaging or caused by personnel's maloperation, operating system failure itself
Data are not seen, can not read, lose.It must be read by special means and measure invisible, no in normal state
Data that are readable, can not reading.
Fig. 1 shows the flow diagram of a kind of Data Migration provided in this embodiment, backup and restoration methods, including：
S101, the characteristic parameter for recording several partition tables, obtain partition information allocation list.
Wherein, the partition table is to obtain table after carrying out subregion to pending data according to target partition mode.
The characteristic parameter includes table name, partitioned mode, subregion expanded period and subregion retention time.
The partition information allocation list is the allocation list for the characteristic parameter for recording each partition table, is matched the following table is partition information
Put the content that table includes：
| Field | Meaning | Remarks |
| P_TABLE_NAME | The table name of partition table | |
| P_SPLIT_TYPE | Partitioned mode | R represents range partition, and L represents list partition |
| P_EXT_PERIOD | Subregion expanded period | |
| P_SAVE_PERIOD | Subregion retention time |
S102, table space is established, each subregion in each partition table is mapped into corresponding table space, obtain subregion pass
It is mapping table.
The table space is the concept of a logic, and data file corresponding with table space is exactly then the data in table space
The finally file on be stored in physical disk can need a table space being mapped on a disk according to business
Physical data files.
Wherein, each table space corresponds at least one data file.
Specifically, a kind of table space can be mapped in same data file, data file can be saved, but simultaneously
Sacrifice the flexibility of Backup and Restore.
Specific subregion relationship map is as shown in Fig. 2, wherein, partition table A to partition table M is with identical partitions mode
Partition table, therefore, partition table A to partition table M include N number of subregion, and each subregion accordingly maps to respective table space (altogether
N number of table space), each table space corresponds to a data file (can also correspond to multiple data files), is deposited in each data file
Store up specific data.
Content in specific subregion relation mapping table is as shown in the table：
S103, the characteristic parameter in the partition information allocation list determine target partition, according to the subregion relationship
Mapping table determines the corresponding target table space of the target partition, and carries out data to the data file in the target table space
Migration, backup restore.
Specifically, would know that the partitioned mode of each subregion from partition information allocation list, subregion expanded period and point
Area's retention time, such as take the partitioned mode of list partition, according to " my god " carry out subregion (i.e. subregion expanded period be " my god "),
Totally 365 days (i.e. subregion retention time is " 356 "), it is the 35-50 days to determine target partition；Then from subregion relation mapping table
The corresponding target table space of subregion that subregion is the 35-50 days is obtained, target data text is further obtained according to target table space
Part, and Data Migration, backup or recovery can be carried out to target data file.
Combination of the present embodiment using " table space "+" partition table " and the migrating technology using table space, either to small
Type database processing or large database processing can provide maximum flexibility and most efficient performance in application.
It supports that user class, table space rank, table level are other, the other data granularity migration of partition level, back up and restore, while support to customize
Change the subregion range of setting：The data of time range (such as year granularity, moon granularity, day granularity, hour granularity, 15 minutes granularities)
Rank；The data-level of regional extent (such as national granularity, province's granularity, city's granularity, region granularity).
The present embodiment is established by the way that table is carried out fine-grained subregion, by subregion on corresponding table space respectively, is supported
Data Migration, backup and the recovery of random time are adapted to various databases, and can effectively control Data Migration, backup and
The data granularity of recovery improves Data Migration, backup and the speed of recovery.
Further, on the basis of above method embodiment, several described partition tables are according to target partition mode pair
Pending data obtains after carrying out subregion.
Specifically, the target partition mode of table is set first, i.e., planning and designing traffic table is according to what condition or scene
Carry out data partition, when Backup and Restore below of the judgment condition of subregion, which plays, which type of standard to screen needs with
The target data of Backup and Restore does not consider data base configuration file, control file and Parameter File etc. and applied business
Unrelated data and the Backup and Restore problem of file.
There can be following alternative condition in tables of data subregion according to Oracle technical specifications：
Range partition：Mainly it is commonly used for carrying out subregion according to time granularity；
List partition：Subregion is carried out according to the specific type of field, such as：Man, female；
Other subregions include hash partition, referred partitions and space partition.
The selection of target partition mode specifically adapts to and meets the requirement of business.
Further, on the basis of above method embodiment, the table space of establishing specifically includes：
According to the corresponding number of partitions of the target partition mode, the table space of the number of partitions is established.
Specifically, database is mapped to by what subregion held water to determine how according to the division of partition table and subregion
When on table space, according to the corresponding number of partitions of target partition mode, the quantity of table space is determined.
Such as in Fig. 2, partition table A to partition table M includes N number of subregion, then the quantity of its corresponding table space is also N.
It is identical with number of partitions by the quantity for setting table space, it is convenient to map one by one, it can be according to subregion fast mapping
To corresponding table space.
Specifically, after establishing partition information allocation list and subregion relation mapping table, it is possible to according to the backup of practical application
With the demand of Restoration Mechanism, periodically complete to resume work for the backup of specific data and the data under special scenes.
The work mainly completed during backup is exactly that the configuration management information of table space in logic is carried out backup preservation, by physics
On corresponding data file carry out backup preservation；It is only needed during recovery by the configuration management information of table space and corresponding data
File completes to restore on certain database and file copy.
Further, on the basis of above method embodiment, the data file in the target table space into
Row Data Migration, backup or recovery, specifically include：
Data Migration, backup or recovery are carried out to the data file in the target table space according to predetermined period.
Wherein, the predetermined period according to specific Data Migration, backup or restores requirement setting.
By periodically being migrated, being backed up or being restored to data, can guarantee data security and complete premise
Under, save memory space.
Specific Data Migration, backup and restoration methods are illustrated below：
A1, partition information allocation list is established
Field in partition information allocation list includes：
The table name (Table_A ... Table_N) of partition table；
The subregion key (i.e. literary name section) of partition table；
Partitioned mode (such as R represents range partition, and L represents list partition)；
Subregion expanded period is (such as：Y represents an annual subregion, and monthly a subregion, D represent daily one point for M representatives
Area)；
Subregion retention time is (if year subregion, unit：Year；If day subregion, unit：My god；If moon subregion,
Unit：Month).
A2, subregion relation mapping table is established
Field in subregion relation mapping table includes：
Partition name；
The table name (Table_A ... Table_N in corresponding partition information allocation list) of partition table；
Table space title；
Data file name.
A3, form management
It specifically includes：
Initialize partition table；
It is corresponded to according to zoning requirements to complete the maintenance of table subregion (increasing or remove subregion newly according to rule) and table subregion
The establishment of table space and the configuration of data file；
The mapping relations of table subregion, table space and data file in management service " subregion relation mapping table ".
A4, increase information
Create the division table Table_A, and comprising " name (NAME) ", " age (AGE) ", " open an account the time (CREATE_
DATE) ", " telephone number (PHONE) " four fields, will daily carry out subregion, then according to information above according to " opening an account the time "
It is as follows to fill in partition information allocation list：
| P_TABLE_NAME | P_SPLIT_TYPE | P_EXT_PERIOD | P_SAVE_PERIOD |
| Table_A | R | D | 365 |
The advance initial configuration subregion of three days, then it is as follows accordingly to increase information in subregion relation mapping table：
Specific mapping relations in upper table can refer to Fig. 2, provides the planning signal of wider scene domain, is also covered by simultaneously
By the situations (being accepted or rejected according to practical business) of multiple table block plannings to same table space.
A5, Data Migration, backup and recovery
Perform Data Migration, backup and restore when target be exactly " partition information allocation list ", " subregion relation mapping table ",
Form manager packet, data file (such as：Datafile_1).
For example, it can carry out individually backing up for Datafile_1, Datafile_2, Datafile_3 and extensive
It is multiple, and first day, second day, the application data in third day are stored in these three data files respectively, provide a kind of spirit
The approach of selection living, which allows, can select the data of independent some day to be backed up or be restored；And in the backup of data file,
It can be by the very thin of the granularity division of subregion.On the one hand it is more flexible in this way, it on the other hand can effectively reduce individual data
The size of file, the backup simultaneously for data file are only needed to can be completed by the copy command of operating system, greatly be carried
Backup and the efficiency restored are risen.
Be in above citing in a manner that subregion is in day, it is specific for different business it is also an option that the moon of bigger or
Person's smaller hour, minute are subregion granularity；May also select according to gender subregion (man, female), according to region subregion (by save,
City, county)；Under more complicated scene, additionally it is possible to use mixing subregion.No matter which kind of mode used, it is only necessary to according to we
Design planning is set in case, is capable of providing flexible and efficient data backup and resume function.
The present embodiment is migrated using table space by the combination of table space and partition table, a kind of controlled particle size of realization
Data Migration and Backup and Restore scheme.It can be used for the scene of the mass data migration under a variety of and complex scene.Coding is real
The dynamic table space of existing tables of data, data file and table subregion maintenance and management, realize automation to a certain extent, reduce
The maloperation risk that artificial participation introduces.Complete independent Data Migration, backup and a restoration methods are provided, for magnanimity
Migration, backup and the recovery of data provide an efficient quick implementation, meet the analysis of different data grain size statistics
Demand scene.The design of memory utilization structure can cover various Data Migrations, backup and the demand of recovery scene, and can
Independent extension is carried out according to demand.
Fig. 3 shows the structure diagram of a kind of Data Migration provided in this embodiment, backup and recovery device, the dress
Put including：Allocation list acquisition module 301, mapping table acquisition module 302 and data processing module 303, wherein：
The allocation list acquisition module 301 for recording the characteristic parameter of several partition tables, obtains partition information configuration
Table；
For establishing table space, each subregion in each partition table is mapped to pair for the mapping table acquisition module 302
The table space answered obtains subregion relation mapping table；
The data processing module 303 determines target point for the characteristic parameter in the partition information allocation list
Area determines the corresponding target table space of the target partition, and to the target table space according to the subregion relation mapping table
In data file carry out Data Migration, backup or recovery；
Wherein, each table space corresponds at least one data file.
The present embodiment is established by the way that table is carried out fine-grained subregion, by subregion on corresponding table space respectively, is supported
Data Migration, backup and the recovery of random time are adapted to various databases, and can effectively control Data Migration, backup and
The data granularity of recovery improves Data Migration, backup and the speed of recovery.
Further, on the basis of above device embodiment, several points described in the allocation list acquisition module 301
Area's table obtains after carrying out subregion to pending data according to target partition mode.
Further, on the basis of above device embodiment, table sky is established described in the mapping table acquisition module 302
Between specifically include：
According to the corresponding number of partitions of the target partition mode, the table space of the number of partitions is established.
Further, on the basis of above device embodiment, to object table sky in the data processing module 303
Between in data file carry out Data Migration, backup or recovery, specifically include：
Data Migration, backup or recovery are carried out to the data file in the target table space according to predetermined period.
Further, on the basis of above device embodiment, the target partition mode includes range partition, list point
Area, hash partition, referred partitions and space partition.
Data Migration, backup and recovery device described in the present embodiment can be used for performing above method embodiment, former
Reason is similar with technique effect, and details are not described herein again.
The apparatus embodiments described above are merely exemplary, wherein the unit illustrated as separating component can
To be or may not be physically separate, the component shown as unit may or may not be physics list
Member, you can be located at a place or can also be distributed in multiple network element.It can be selected according to the actual needs
In some or all of module realize the purpose of this embodiment scheme.Those of ordinary skill in the art are not paying creativeness
Labour in the case of, you can to understand and implement.
Through the above description of the embodiments, those skilled in the art can be understood that each embodiment can
It is realized by the mode of software plus required general hardware platform, naturally it is also possible to pass through hardware.Based on such understanding, on
Technical solution is stated substantially in other words to embody the part that the prior art contributes in the form of software product, it should
Computer software product can store in a computer-readable storage medium, such as ROM/RAM, magnetic disc, CD, including several fingers
It enables and (can be personal computer, server or the network equipment etc.) so that computer equipment is used to perform each implementation
Method described in certain parts of example or embodiment.
It should be noted that：The above embodiments are merely illustrative of the technical solutions of the present invention, rather than its limitations；Although reference
The present invention is described in detail in previous embodiment, it will be understood by those of ordinary skill in the art that：It still can be right
Technical solution recorded in foregoing embodiments modifies or carries out equivalent replacement to which part technical characteristic；And this
A little modifications are replaced, the spirit and model of various embodiments of the present invention technical solution that it does not separate the essence of the corresponding technical solution
It encloses.
Claims (10)
1. a kind of Data Migration, backup and restoration methods, which is characterized in that including：
The characteristic parameter of several partition tables is recorded, obtains partition information allocation list；
Table space is established, each subregion in each partition table is mapped into corresponding table space, obtains subregion relation mapping table；
Characteristic parameter in the partition information allocation list determines target partition, is determined according to the subregion relation mapping table
The corresponding target table space of the target partition, and Data Migration, backup are carried out to the data file in the target table space
Or restore；
Wherein, each table space corresponds at least one data file.
2. according to the method described in claim 1, it is characterized in that, several described partition tables are treated according to target partition mode
Processing data obtain after carrying out subregion.
3. according to the method described in claim 2, it is characterized in that, the table space of establishing specifically includes：
According to the corresponding number of partitions of the target partition mode, the table space of the number of partitions is established.
4. according to the method described in claim 1, it is characterized in that, the data file in the target table space carries out
Data Migration, backup or recovery, specifically include：
Data Migration, backup or recovery are carried out to the data file in the target table space according to predetermined period.
5. according to the method in claim 2 or 3, which is characterized in that the target partition mode includes range partition, list
Subregion, hash partition, referred partitions and space partition.
6. a kind of Data Migration, backup and recovery device, which is characterized in that including：
Allocation list acquisition module for recording the characteristic parameter of several partition tables, obtains partition information allocation list；
Each subregion in each partition table for establishing table space, is mapped to corresponding table space by mapping table acquisition module,
Obtain subregion relation mapping table；
Data processing module determines target partition, according to described for the characteristic parameter in the partition information allocation list
Subregion relation mapping table determines the corresponding target table space of the target partition, and to the data file in the target table space
Carry out Data Migration, backup or recovery；
Wherein, each table space corresponds at least one data file.
7. device according to claim 6, which is characterized in that several partition tables described in the allocation list acquisition module
It is obtained after carrying out subregion to pending data according to target partition mode.
8. device according to claim 7, which is characterized in that table space tool is established described in the mapping table acquisition module
Body includes：
According to the corresponding number of partitions of the target partition mode, the table space of the number of partitions is established.
9. device according to claim 6, which is characterized in that in the target table space in the data processing module
Data file carry out Data Migration, backup or recovery, specifically include：
Data Migration, backup or recovery are carried out to the data file in the target table space according to predetermined period.
10. device according to claim 7 or 8, which is characterized in that the target partition mode includes range partition, row
Table subregion, hash partition, referred partitions and space partition.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611259632.5A CN108268341A (en) | 2016-12-30 | 2016-12-30 | A kind of Data Migration, backup and restoration methods and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611259632.5A CN108268341A (en) | 2016-12-30 | 2016-12-30 | A kind of Data Migration, backup and restoration methods and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108268341A true CN108268341A (en) | 2018-07-10 |
Family
ID=62754854
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611259632.5A Pending CN108268341A (en) | 2016-12-30 | 2016-12-30 | A kind of Data Migration, backup and restoration methods and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108268341A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110543520A (en) * | 2019-08-30 | 2019-12-06 | 京东数字科技控股有限公司 | data migration method and device |
| CN111104404A (en) * | 2019-12-04 | 2020-05-05 | 星辰天合（北京）数据科技有限公司 | Data storage method and device based on distributed objects |
| CN113190379A (en) * | 2021-04-12 | 2021-07-30 | 山东英信计算机技术有限公司 | Method, system and medium for reducing backup set of database backup |
| CN117170942A (en) * | 2023-11-03 | 2023-12-05 | 腾讯科技（深圳）有限公司 | Database backup method based on file system snapshot and related equipment |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103106271A (en) * | 2013-02-05 | 2013-05-15 | 广东全通教育股份有限公司 | Database backup and recovery method and system based on mass data |
| CN103279582A (en) * | 2013-06-24 | 2013-09-04 | 浙江宇天科技股份有限公司 | Oracle partition based data storing method and device |
-
2016
- 2016-12-30 CN CN201611259632.5A patent/CN108268341A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103106271A (en) * | 2013-02-05 | 2013-05-15 | 广东全通教育股份有限公司 | Database backup and recovery method and system based on mass data |
| CN103279582A (en) * | 2013-06-24 | 2013-09-04 | 浙江宇天科技股份有限公司 | Oracle partition based data storing method and device |
Non-Patent Citations (1)
| Title |
|---|
| 申辉: "基于MQ中间件的气象数据库共享系统的设计与实现", 《中国优秀硕士学位论文全文数据库信息科技辑》 * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110543520A (en) * | 2019-08-30 | 2019-12-06 | 京东数字科技控股有限公司 | data migration method and device |
| CN110543520B (en) * | 2019-08-30 | 2022-02-01 | 京东科技控股股份有限公司 | Data migration method and device |
| CN111104404A (en) * | 2019-12-04 | 2020-05-05 | 星辰天合（北京）数据科技有限公司 | Data storage method and device based on distributed objects |
| CN111104404B (en) * | 2019-12-04 | 2021-10-01 | 星辰天合（北京）数据科技有限公司 | Data storage method and device based on distributed objects |
| CN113190379A (en) * | 2021-04-12 | 2021-07-30 | 山东英信计算机技术有限公司 | Method, system and medium for reducing backup set of database backup |
| CN117170942A (en) * | 2023-11-03 | 2023-12-05 | 腾讯科技（深圳）有限公司 | Database backup method based on file system snapshot and related equipment |
| CN117170942B (en) * | 2023-11-03 | 2024-02-13 | 腾讯科技（深圳）有限公司 | Database backup method based on file system snapshot and related equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN100419664C (en) | Incremental backup operations in storage networks | |
| US8352429B1 (en) | Systems and methods for managing portions of files in multi-tier storage systems | |
| CN101777016B (en) | Snapshot storage and data recovery method of continuous data protection system | |
| CN103761190B (en) | Data processing method and apparatus | |
| CN108268341A (en) | A kind of Data Migration, backup and restoration methods and device | |
| CN106407040A (en) | Remote data copy method and system | |
| CN103605588B (en) | A kind of disk backup method of virtue machine | |
| CN100524235C (en) | Recovery operations in storage networks | |
| DE112020003423T5 (en) | ARCHITECTURE OF VIRTUAL STORAGE SYSTEM | |
| CN104298681B (en) | A kind of date storage method and device | |
| CN106662981A (en) | Storage device, program, and information processing method | |
| CN105339903A (en) | Restoring a file system object | |
| CN103034592B (en) | Data processing method and device | |
| CN102929748A (en) | Method and device for data backup | |
| CN102200936A (en) | Intelligent configuration storage backup method suitable for cloud storage | |
| CN101276300A (en) | Storage system and storage control method | |
| CN101008886A (en) | Storage virtual computer system and management data snapshot image method in storage system | |
| CN103019890A (en) | Block-level disk data protection system and method thereof | |
| CN104281717B (en) | A kind of method for setting up magnanimity ID mapping relations | |
| CN104462389A (en) | Method for implementing distributed file systems on basis of hierarchical storage | |
| US20140019698A1 (en) | Systems and methods for replication of data utilizing delta volumes | |
| CN106227731A (en) | A kind of data processing method, device and distributed file system | |
| CN110083490A (en) | A kind of database backup method, restoring method and storage medium | |
| CN106776147A (en) | A kind of variance data backup method and variance data back-up device | |
| US9251020B1 (en) | Systems and methods for file-level replication |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180710 |