Data migration, backup and recovery method and apparatus

Abstract

Embodiments of the present invention disclose a data migration, backup and recovery method and apparatus. The method comprises: recording feature parameters of a plurality of partition tables to obtain a partition information configuration table; establishing a table space, and mapping each partition in each partition table to a corresponding table space to obtain a partition relationship mappingtable; and determining a target partition according to the feature parameters in the partition information configuration table, determining a target table space corresponding to the target partition according to the partition relationship mapping table, and carrying out data migration, backup or recovery on a data file in the target table space, wherein each table space corresponds to at least onedata file. According to the technical scheme of the embodiments of the present invention, by fine-grained partitioning the table, the partitions are respectively established into the corresponding table space, data migration, backup and recovery at any time can be supported, the technical scheme can adapt to various databases, the data granularity of data migration, backup and recovery can be effectively controlled, and the speed of data migration, backup and recovery can be improved.

Description

technical field [0001] The embodiment of the present invention relates to the field of computer technology, and in particular to a data migration, backup and recovery method and device. Background technique [0002] Any application that needs to use a database needs to store various data, and data generally has different life cycles. Some data needs to be migrated to another database system after a period of time. At the same time, data also needs to be backed up regularly, because the data may be invisible, unreadable, or lost due to damage to the storage medium, misuse by personnel, or failure of the operating system itself. Once data is lost, it is necessary to use data backup for recovery. The granularity of traditional data migration and backup can only be as fine as the table level, and the migration, backup, and recovery are slow. [0003] Traditional Oracle data migration, backup and recovery are mainly divided into two categories: physical backup and recovery and...

AI Technical Summary

Problems solved by technology

Logical import and export are only suitable for small database dumps, database logical structure backups, etc. Although they can provide sufficient flexibility and customizable effects, they are limited by the efficiency of data transmission during the export and import process. The efficiency cannot meet the requirements in the scenario of large and medium-sized databases

[0007] Currently, the technologies provided by Oracle can support backup and recovery and data migration at the following levels: database level, table space level, user level, and table level; the flexibility of such a granular level is relatively limited, and the selectivity is relatively poor.

[0008] In the process of implementing the embodiment of the present invention, the inventors found that the existing methods, whether cold backup or hot backup, can only provide backup and recovery of all data in the database up to a certain point in the past, and logical import and export only It is suitable for small databases, and it can only support table level when performing data migration, backup and recovery, and the selectivity of data granularity level is poor

Images