JP2000347919A - Automatic operation system for database on-line backup - Google Patents

Abstract

PROBLEM TO BE SOLVED: To prevent the decrease of the operation performance of a database on-line backup automatic operation system by minimizing a backup required period. SOLUTION: A system operation performance data collecting means 2 collects disk activity information in system activity in a system operation mode, and a system operation performance data storing means 3 stores collected system operation performance daily and in each different time period. A backup execution condition inputting means 7 inputs a backup execution condition, and a backup execution plan is prepared by using a backup execution plan preparing means 4 so as to prevent the decrease of system operation performance and to minimize a required period for backup. A backup execution managing means 5 executes backup on the basis of the prepared backup execution plan, and in a such a case, a backup execution performance storing means 6 accumulates the required time for backup of each data file as backup performance data.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database online backup automatic operation system.
The present invention relates to a database online backup automatic operation system for preventing deterioration of system operation performance.

[0002]

2. Description of the Related Art Conventionally, a database online backup automatic operation system is generally configured to have a mechanism for setting a backup start time and a backup execution cycle and executing the backup automatically.

The database backup system of the prior art 1 related to the above configuration is disclosed in Japanese Patent Application Laid-Open No. 08-212142.
No., published in Japanese Unexamined Patent Publication No. The backup system of the first conventional example has a mechanism for automatically setting a backup start time and a backup execution cycle as a backup execution plan.

Further, Japanese Patent Application Laid-Open No. HEI 8-19438 of Conventional Example 2
Japanese Patent Application Laid-Open Publication No. H10-260, entitled "Database backup method and database backup device at specified time" saves, in an online system that operates continuously for 24 hours, a database that is constantly updated in online work or patch work at a specified time. It is possible to make it.

[0005] A "database division management system" disclosed in Japanese Patent Application Laid-Open No. 8-328929 of the prior art 3 divides a physical file of a database into a plurality of physical files in accordance with the frequency of use of the data. The physical file is moved by a plurality of storage devices in accordance with the frequency of use of the file, and the plurality of physical files are logically accessed as one physical file, thereby improving the efficiency of the backup of the physical file.

[0006]

However, the above-mentioned prior art has the following problems. First, the effect of backup execution on system operation is not quantitatively observed. For this reason, the performance of the system operation may deteriorate due to the execution of the backup process.

Second, there is no mechanism for dynamically modifying a backup plan. For this reason, the system backup plan is fixed, and the backup execution plan is reviewed only when the system operation performance deteriorates.

In the above-mentioned conventional example 3, although the efficiency of backup of a frequently used physical file can be improved, the required backup time is not actively reduced based on actual operation.

The present invention provides an online backup of a database system, that is, a backup during operation.
It is an object of the present invention to provide a database online backup automatic operation system that minimizes backup time and prevents a decrease in system operation performance.

[0010]

In order to achieve the above object, an automatic database online backup operation system according to the present invention includes a database management system for controlling and managing the operation of the automatic database backup online operation system; A system operation performance data collection unit 2 that collects disk activity information from the system activities during the operation of the database / online backup automatic operation system 1, and a system operation performance acquired by the system operation performance data collection unit 2 System operation performance data accumulating means 3 for accumulating data for different time periods, backup execution condition input means constituting a functional unit for inputting backup execution conditions, Backup execution plan creating means 4 prevent deterioration and backup time required system operational performance is to create a backup execution plan to minimize
A backup execution management unit 5 having a function of inputting approval of the backup execution plan created by the backup execution plan creation unit 4; and a backup time required for each data file when the backup is executed by the backup execution management unit 5. And a backup execution performance accumulating means 6 for accumulating as backup performance data.

According to the second aspect of the present invention, in the database online backup automatic operation system according to the first aspect, a busy rate which is a time rate required for read / write instruction processing may be adopted as disk activity information. .

According to a third aspect of the present invention, in the database online backup automatic operation system according to the first or second aspect, the backup execution condition input means 7 is provided.
As the execution conditions using, a backup start date and time, a backup end date and time, or a backup execution cycle, an execution timing, an execution start time and an end time may be input.

According to the fourth aspect of the present invention, the first to third aspects are provided.
In the database online backup automatic operation system according to any one of the above, the backup execution plan is created by the system operation performance information accumulated by the system operation performance data accumulation unit 3 and the backup execution input by the backup execution condition input unit 7. This may be performed based on the conditions and information on the backup target data file acquired from the database management system 1.

According to a fifth aspect of the present invention, in the database online backup automatic operation system according to the fourth aspect, a data file to be backed up is mapped to a predetermined physical disk device, and the data file is mapped in a time zone satisfying the backup execution condition. It is preferable to create a backup plan to back up this data file during a time period when the physical disk device busy rate is lower.

According to a sixth aspect of the present invention, in the database online backup automatic operation system according to the fifth aspect, the accumulated backup performance data is:
It may be used to create a backup plan by the backup execution plan creating means 4.

[0016]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Next, an embodiment of a database online backup automatic operation system according to the present invention will be described in detail with reference to the accompanying drawings. 1 to 5, there is shown an embodiment of a database online backup automatic operation system according to the present invention.

The database of the present embodiment shown in FIG.
The online backup automatic operation system includes a database management system 1 that manages a database system, a system operation performance data collection unit 2, a system operation performance data storage unit 3, a backup execution plan creation unit 4, and a backup execution management unit 5. , A backup execution performance storage means 6 and a backup execution condition input means 7. These means
Each operates as follows.

Database management system 1
Is a control unit that manages the operation of the database online backup automatic operation system.

The system operation performance data collection means 2 collects disk activity information from system activities during system operation. In the present embodiment, it is necessary to input a performance factor that becomes a bottleneck during backup execution as an input for creating a backup execution plan. However, performance bottlenecks during backup execution generally relate to disk activity. A busy rate is used as the disk activity information.
Generally, the following (A) to (E) are used as disk activity information.

(A) Busy rate (time rate required for read / write command processing) (B) Number of read / writes per unit time (C) Number of read / write blocks per unit time (D) Read Average waiting time per read / write instruction (E) Average number of waiting instructions per read / write instruction

However, in the present embodiment, it is necessary to use an operation rate that can be compared between different disk devices as a factor for determining a backup target file. For this purpose, it is optimal to employ the busy rate (A) described above.

The system operation performance data accumulating means 3 accumulates the system operation performance acquired by the system operation performance data collecting means 2 for each day and time zone. Generally, the conditions for backup execution are (D1) day / (T1) hour and (D2) according to the system operation time zone.
Date / (T2) hour. Therefore, as the system operation performance, it is best to accumulate the disk activity for each day / time zone.

The backup execution condition input means 7 constitutes a functional unit for inputting backup execution conditions.
As an execution condition using the backup execution condition input means 7, for example, a backup start date and time, a backup end date and time, or a backup execution cycle, an execution timing, an execution start time and an end time can be input.

The backup execution plan creating means 4 is used to create a backup execution plan so as to prevent the system operation performance from deteriorating and to minimize the required backup time. The creation of the backup execution plan includes the system operation performance information accumulated by the system operation performance data accumulation means 3, the backup execution conditions inputted by the backup execution condition input means 7, and the backup target data file acquired from the database management system 1. It is performed based on the information of.

More specifically, the data file to be backed up is mapped to, for example, a physical disk device, and is a time zone that satisfies backup execution conditions.
A backup plan is created so that this data file is backed up during a time when the physical disk device busy rate is as low as possible.

The backup execution management means 5 has a function of inputting approval of the backup execution plan created by the backup execution plan creation means 4. In addition, a program for performing backup according to the backup execution plan is created and executed. On UNIX, the backup program is created as a shell script, and the regular backup execution is realized by registering it in the cron.

The backup execution performance accumulating means 6 accumulates the required backup time for each data file as backup performance data. This accumulation is performed when the backup is executed by the backup execution management means 5. Further, the accumulated backup performance data is input to the backup execution plan creating means 4 and used to create a backup plan.

(Operation) Next, an overall operation example of the present embodiment will be described in detail with reference to the flowcharts of FIGS.

First, system operation performance data is collected during the system operation time zone (step A1 in FIG. 2). At the same time, system operation performance data is accumulated (step A
2). Next, a backup execution condition is input (step A3). Here, a backup execution plan is created (step A4). A backup is executed according to the created backup execution plan (step A5), and the backup performance data at this time is collected (step A6) and the backup performance data is accumulated (step A7).

Next, step A4 will be described in detail with reference to FIG. Each step in FIG. 3 shows the details of “backup execution plan creation” in step A4 in FIG.

First, in response to the input of the backup execution condition, a backup time zone is determined from the backup execution start date and time and the backup completion date and time (step B1).

In step B2, the backup time zone determined in step B1 is calculated to determine which month, week, and day of the week.

Based on the date data of the backup time zone obtained in step B2, the system operation performance data for each time zone on the same month and the same week of the previous year is extracted (step B3).
Here, the system operation performance data is a busy rate of the disk device. FIG. 4 shows this data image.

Here, data file information to be backed up is extracted from the database management system (step B4), and the disk device on which the extracted data files are mounted is specified or mapped (step B4). B5). To explain using a specific example, when the data file “DF-n” is mounted on the disk device “DK-n”, the busy rate of the disk device “DK-n” is equal to or less than a preset threshold. Such a time zone is selected from the data extracted in step B3.

In the continuous time zone "TZ-n" selected in this way, whether or not the backup of the disk device "DF-n" can be completed is determined by the backup stored in step A7 in FIG. The determination is made based on the performance data (step B7).

If it is determined that the backup cannot be completed, the threshold is increased, so-called conditions are relaxed (step B8), and a continuous time zone is selected again from the data extracted in step B3, and the backup is completed. It is determined whether or not it is possible (step B7). Repeat this process until a backup window can be found.

If it is determined that the backup can be completed, the backup time zone of the disk device "DF-n" is determined to be "TZ-n" (step B9).

Thereafter, by repeating steps B6 to B9 for all data files, a time zone for backing up all data files is determined (step B).
10).

In FIG. 1, the system operation performance data collection means 2 collects a data file during system operation and performance data of a physical disk device in which the data file exists.

The system operation performance data accumulating means 3 accumulates physical disk operating rates for each day and for each time zone as performance data.

The backup execution plan creation means 4 inputs system operation performance, backup execution conditions, and backup target data files. Also, a backup execution plan is created using the backup execution conditions as execution conditions. These pieces of system operation performance information are stored by the system operation performance data storage unit 3. The backup execution condition is input by the backup execution condition input unit 7. The data file to be backed up is obtained from the database management system.

As the backup execution performance or the backup execution condition, the required backup time for each data file and physical disk is accumulated. The backup execution condition is a condition for designating a backup execution date, a backup execution cycle, a backup start time, and a backup end time.

The backup execution plan is designed to complete the backup in the shortest required backup time, avoiding a time zone in which access to the data file to be backed up frequently occurs.

The backup execution management means 5 receives the approval input of the created backup execution plan and executes the backup according to the plan. At this time, the backup execution performance is recorded and accumulated by the backup execution performance accumulation means 6 as the latest information.

In this way, it is possible to reduce the system operation performance at the time of online backup and minimize the required backup time.

(Other Embodiment) Next, another embodiment of the present invention will be described in detail with reference to the drawings. Referring to FIG. 5, this embodiment differs from the embodiment shown in FIG. 1 in further including a system performance monitoring means 8 during backup.

The system operation performance data collection means 2 collects disk activity information from system activities during system operation.

The system operation performance data accumulating means 3 accumulates the system operation performance obtained by the system operation performance data collecting means 2 for each day / time zone. The backup execution condition input means 7 constitutes means for inputting backup execution conditions. As the execution condition, a backup start date and time, a backup end date and time, or a backup execution cycle, an execution timing, an execution start time and an end time can be input.

The backup execution plan creating means 4 includes the system operation performance information accumulated by the system operation performance data accumulation means 3, the backup execution conditions inputted by the backup execution condition input means 7, and the backup acquired from the database management system 1. Based on the information of the target data file, reduce the system operation performance and minimize the required backup time,
Create a backup execution plan.

The backup execution management means 5 has a function of inputting the approval of the backup execution plan created by the backup execution plan creation means 4. In addition, a program for performing a backup is created and executed according to the backup execution plan.

The system performance monitoring means 8 during backup execution monitors the system performance during backup execution.
Specifically, the average number of instructions waiting to be executed per read / write instruction of the disk device to be backed up is monitored as system performance. If the average number of instructions waiting to be executed per read / write instruction exceeds a predetermined time for a predetermined time, it is considered that the system operation using the disk device to be backed up has been started, Immediately, the backup process for the current data file is interrupted, and the backup execution plan creating means 4 re-creates the backup for the data files excluding the data file that has already been backed up.

At this time, the system operation performance data of the disk device accessed by the interrupted backup processing is replaced by the current system performance data (busy rate). Further, the backup execution time zone of each data file is reevaluated for the backup execution time zone after the current time.

The backup execution performance accumulating means 6 accumulates the required backup time of each data file as backup performance data when the backup is executed by the backup execution management means 5. The accumulated backup performance data is stored in the backup execution plan
Is an input for creating a backup plan.

According to the above embodiment, in the online backup of the database system, that is, the backup during operation, a backup plan for reducing the system operation performance and minimizing the required backup time can be created, and the backup can be automatically executed according to the plan. Build a database online backup automatic operation system.

According to the above configuration, first, a backup execution plan is created with the disk device having a low busy rate as a backup target with reference to the system operation performance data. Therefore, when performing online backup,
The decrease in system operation performance can be reduced.

Second, since a disk device having a low busy rate is always set as a backup target, the seek time of the disk is reduced, and as a result, the time required for the entire backup process is reduced. Therefore, the required backup time can be reduced.

Third, since the backup execution plan and the execution management are performed automatically, the running cost required for the plan creation and backup operation is not required. For this reason, the cost in the backup operation of the system can be reduced.

The above embodiment is an example of a preferred embodiment of the present invention. However, it is not limited to this.
Various modifications can be made without departing from the spirit of the present invention.

[0059]

As is clear from the above description, the database online backup automatic operation system according to the present invention manages a database system, and collects and acquires disk activity information in system activities during system operation. Accumulated system operation performance is accumulated for each day and time zone, and backup execution conditions are entered.
Create a backup execution plan to prevent a decrease in system operation performance and minimize the time required for backup.
When backup is executed by the approval input function of the created backup execution plan, the required backup time for each data file is accumulated as backup performance data.

According to the above configuration, by creating a backup execution plan for backing up a disk device having a low busy rate with reference to the system operation performance data, a decrease in the system operation performance at the time of online backup execution is prevented. Can be smaller.

In addition, by always backing up a disk device having a low busy rate, the seek time of the disk can be reduced, and as a result, the time required for the entire backup process can be reduced.

Further, the backup execution plan and the execution management are automatically performed, so that the running cost required for the plan creation and the backup operation becomes unnecessary, and the cost in the backup operation of the system can be reduced.

[Brief description of the drawings]

FIG. 1 is a block diagram showing an embodiment of a database online backup automatic operation system according to the present invention.

FIG. 2 is a flowchart illustrating a series of operation examples.

FIG. 3 is a flowchart illustrating an operation example of step A4 in FIG. 2;

FIG. 4 is a diagram showing a data image of system operation performance data (busy rate of a disk device).

FIG. 5 is a system block diagram showing another embodiment.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Database management system 2 System operation performance data collection means 3 System operation performance data accumulation means 4 Backup execution plan creation means 6 Backup execution performance accumulation means 5 Backup execution management means 7 Backup execution condition input means 8 System performance monitoring means during backup execution

Claims (6)

[Claims] 1. A database management system for controlling and managing the operation of the database / online backup automatic operation system, and a system for collecting disk activity information in the system activity at the time of operation of the database / online backup automatic operation system An operation performance data collection unit, a system operation performance data storage unit that stores the system operation performance obtained by the system operation performance data collection unit for each day and time zone, and a functional unit for inputting backup execution conditions Backup execution condition input means, and a backup execution plan that creates a backup execution plan so that the operation performance of the database / online backup automatic operation system is prevented from deteriorating and the backup time is minimized. Execution plan creation means; backup execution management means having a function of inputting approval of the backup execution plan created by the backup execution plan creation means; backup required for each data file when the backup is executed by the backup execution management means A database online backup automatic operation system, comprising: backup execution performance storage means for accumulating time as backup performance data. 2. The database / online backup automatic operation system according to claim 1, wherein a busy rate which is a time rate required for processing a read / write command is adopted as the disk activity information.・ Online backup automatic operation system. 3. The database according to claim 1 or 2,
In the online backup automatic operation system, as the execution conditions using the backup execution condition input means, a backup start date and time, a backup end date and time, or a backup execution cycle,
An automatic database online backup operation system characterized in that an execution timing, an execution start time, and an end time can be input. 4. The database / online backup automatic operation system according to claim 1, wherein the backup execution plan is created by the system operation performance information accumulated by the system operation performance data accumulation unit. A database online backup automatic operation system, which is performed based on backup execution conditions input by a backup execution condition input means and information of a backup target data file acquired from the database management system. 5. The database / online backup automatic operation system according to claim 4, wherein the data file to be backed up is mapped to a predetermined physical disk device, and the physical disk is stored in a time zone satisfying the backup execution condition. A database online backup automatic operation system, wherein a backup plan is created so as to back up a corresponding data file at a time when the device busy rate is lower. 6. The database / online backup automatic operation system according to claim 5, wherein the accumulated backup performance data is used for creating the backup plan by the backup execution plan creating means. Database online backup automatic operation system.