JPH0573388A - Controller for backup data - Google Patents

Abstract

PURPOSE:To provide the controller for backup data which easily and securely retrieve an external medium where desired data is stored among plural backed-up external media and automatically select data to be backed up in backup operation. CONSTITUTION:A fixed disk 11 is provided with a control master wherein the backup date, backup medium identification symbol, recovery data, and recovery frequency of backed-up data are registered to retrieve the external medium where the desired data is stored among the backed-up external media 12. Further, the data to be backed up can automatically be selected at the time of the backup operation.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a backup data management apparatus, in particular, searching a magnetic tape storing desired data from a large number of magnetic tapes backed up at the time of recovery and selecting data to be backed up at the time of backup. Backup data management device.

[0002]

2. Description of the Related Art Normally, in a database that stores a large amount of data frequently, it is necessary to back up to an external medium and then delete it from the database in order to secure a free area of the database.

When retrieving required data from the database, if the retrieved data is backed up, it is necessary to recover the data. When backing up, which data was backed up to which external medium was recorded in the management table, and when recorded, the recorded management table was read and recovered.

In addition, at the time of backing up, a person made a judgment as to which data should be backed up and deleted from the database.

[0005]

In the conventional backup / recovery method described above, an external medium in which data to be recovered from a large number of backup external media is recorded is searched by a management table to check whether necessary data is backed up at the time of recovery. Was finding.

At the time of backup, it was very difficult to determine which data can be backed up and deleted from the database.

The present invention solves the above problems, and provides a backup data management apparatus capable of easily searching for a desired backup external medium at the time of recovery and efficiently determining the data to be backed up at the time of backup. The purpose is to do.

[0008]

In order to achieve this object, a backup data management apparatus according to the present invention is a management master in which a backup date and time of a backed up data, a backup external medium identification symbol, a recovery date and time and a recovery count are registered. Is provided.

[0009]

With the above-described structure, the present invention makes it possible to determine whether the data has been backed up at the time of recovery and to identify the backup external storage medium identification symbol, and to judge which data can be backed up at the time of backup.

[0010]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS A first embodiment of the present invention will be described with reference to the drawings.

FIG. 1 is a block diagram of hardware showing a first embodiment of the present invention. A fixed disk 11 for storing an extraction result in which a master for managing inspection data and an inspection database for storing inspection data exist. , A magnetic tape 12 recording backup inspection data, a cathode ray tube (CRT) 13 for displaying a work menu and a search result, a keyboard 14 for selecting a search menu and inputting a search key code, a CPU 15 for arithmetic processing, a data It is composed of the primary storage memory 16.

FIG. 2 is an explanatory diagram showing the contents of the management master stored in the fixed disk 11 of FIG. 1, and FIG. 3 is for recovering, retrieving, and extracting the inspection data backed up using the management master shown in FIG. It is a flowchart of.

First, when the inspection data to be extracted is backed up on the magnetic tape 12 and deleted from the inspection database and does not exist in the fixed disk 11, it is necessary to create a management master that can identify the magnetic tape storing the arbitrary inspection data. There is.

FIG. 2 shows this management master data. The data items to be registered are a registration ID indicating an inspection object, an inspection type indicating an inspection type, an inspection date and time, and a backed-up magnetic tape ID (identification). Symbol), backup date and time, recovery date and time recovered in the inspection database, and recovery count. Such management master data is recorded and updated on the fixed disk 11 at the time of registration of inspection data, backup, and recovery.

Next, with reference to FIG. 3, a procedure for searching for desired data from the registration ID, inspection type, inspection date and time, and storing the extracted result in the fixed disk 11 will be described.

Registration ID to be searched from the keyboard 14,
Enter all or part of the inspection type, inspection date and time,
The end of input is confirmed (steps S1 and S2).

Next, the management master shown in FIG. 2 is loaded from the fixed disk 11, the search condition is compared with the management master record, and it is determined whether or not the management master record matches the search condition (steps S3 and S4).

Next, if the management master record matches the search condition, it is judged whether the corresponding search target is backed up or recovered after being backed up. As a result of the judgment, the backup date and time is set, and If the recovery date / time is not set, it is determined that the inspection data does not exist in the inspection database, and the corresponding record of the management master is stored (steps S5 and S6).

Next, it is judged whether all the records of the management master have been compared with the search condition, and if there is a management master record to be compared, the next record of the management master is compared until all the records are compared. Repeat (step 7).

If there is no management master record stored in step S8, all the inspection data to be searched are in the inspection database in the fixed disk, and the database management system inspects the inspection data. The database is searched and the extraction result is stored in the fixed disk (step S14).

If there is a management master record stored in step S8, a part or all of the inspection data to be searched is backed up and is not in the inspection database, and the stored management master record is backed up. Prompt for recovery by CRT by sorting by magnetic tape ID. Recovery from the magnetic tape to the inspection database is performed manually or automatically. At the time of recovery, the inspection data is recovered, the recovery date and time of the corresponding record of the management master is set, and the recovery count is updated by 1 (steps S9 to S13).

After all the inspection data to be retrieved is recovered, all the inspection data to be inspected will exist in the inspection database. After that, the database management system retrieves and extracts the inspection data to be inspected. The result is stored in the fixed disk (step S14).

Based on the management master created for managing the backup status, desired search data can be searched easily, reliably and in a short time.

In the first embodiment, when the free area of the inspection database is reduced, it is necessary to back up to the magnetic tape and delete the backed up data from the inspection database to secure the free area of the inspection database. ..

FIG. 4 uses the management master shown in FIG.
9 is a flowchart of a second embodiment for selecting data to be deleted from the inspection database and backing up the inspection data.

The required free area is input to the inspection database from the keyboard, and the end of the input is confirmed (steps S21 and S22).

Next, the management master shown in FIG. 2 is loaded from the fixed disk and rearranged in the order of inspection date / time, backup date / time, recovery date / time, and recovery count (step S2).
3).

When the rearranged management master record is read and the backup date and time is not set, it means that the backup has not been made yet. Therefore, the CRT 13 is prompted to input the backup magnetic tape ID, and the magnetic tape ID is input from the keyboard to perform the backup. Start (Step S
24-S28).

After the backup, the relevant inspection data is deleted from the inspection database. After deletion, backup date and time of the relevant record in the management master, backup magnetic tape I
D is set (steps S29 and S30).

If the backup date and time is set and the recovery date and time is not set, it means that the backup has been made but the recovery has not been made, and it is not in the inspection database (step S31).

If the backup date and time is set and the recovery date and time is set, it indicates the state of being recovered after being backed up, and it exists in the inspection database. Since it has been backed up, the relevant inspection data is deleted from the inspection database. After the deletion, the recovery date / time of the corresponding record of the management master is not set (steps S32 and S33).

It is determined whether or not the required free area designated by the input is secured, and if the secured area is insufficient, the next management master record is determined. It is determined whether or not the required free space designated by the input is secured, and if it is determined to be sufficiently secured, the process ends (step S34).

As described above, the data to be backed up and the data that can be deleted can be automatically and promptly selected based on the management master created for the management of the backup and recovery status, and the inspection database can be efficiently used. Can be used.

[0034]

As described above, according to the present invention, by creating the management master in which the backup date and time of the backed up data, the backup external medium identification symbol, the recovery date and time and the number of times of recovery are registered, the desired backup external medium at the time of recovery is created. It is possible to provide a backup data management apparatus that can easily search data in a short time and can efficiently determine data to be backed up at the time of backup.

[Brief description of drawings]

FIG. 1 is a hardware configuration diagram of a backup data management device according to a first embodiment of the present invention.

FIG. 2 is a diagram showing management master data stored in a fixed disk in the hardware configuration diagram of FIG.

FIG. 3 is a flowchart for recovering, searching, and extracting inspection data backed up using the management master shown in FIG.

FIG. 4 is a flowchart at the time of backup of the backup data management device in the second embodiment.

[Explanation of symbols]

 11 Fixed Disk 12 Magnetic Tape (Backup External Medium) 13 CRT (Display Means) 14 Keyboard 15 CPU (Processing Means) 16 Primary Storage Memory (Storage Means)

Claims (2)

[Claims] 1. A backup data management apparatus that searches for a backup external medium storing arbitrary data from a plurality of backup external media storing a plurality of data and recovers the database to a database. Management master in which date and time, backup external medium identification symbol, recovery date and time and number of times of recovery are registered, backup external medium identification symbol given to each of the plurality of backup external mediums, and backup external in which a plurality of data to be recovered are stored Storage means for storing the management master, which can be compared with the medium identification symbol, and all records of the management master read from the storage means and the specific backup external medium identification symbol in which the data to be recovered are stored Processing means, before A backup data management apparatus comprising: a display unit that displays a specific backup external medium identification symbol to be recovered. 2. In a backup data management device for backing up arbitrary data from a database storing a plurality of data and deleting it from the database, a backup date and time of the backed up data, a backup external medium identification symbol, a recovery date and time, and a recovery. The management master that stores the number of times and the management master that can compare the backup external medium identification symbol given to each of the plurality of backup external mediums with the backup external medium identification symbol storing a plurality of data to be recovered are stored. Of the backup data, and a processing unit for selecting data to be backed up from all records of the management master read from the storage unit and recording a backup external medium identification symbol in the management master. tube Processing equipment.