JPH09190368A - Medium management device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To restore a system at high speed by managing a medium used for restoration in a data base. SOLUTION: A file saving block output means (file saving part) 2a adds and outputs journal file information obtained from a transaction information management device 1 to a file saving block. A journal file saving block output means (journal file saving part) 3a detects a journal file where writing completes, generates and outputs the journal file saving block. A medium information output means (information registration device) 4 generates and outputs medium information showing a relation between the file saving block and the journal file saving block. A restoration processing means (file restoration part) 7 retrieves medium information required for restoration based on medium information stored in the medium management data base 5 by a medium information retrieval means (information extraction device) 6 so as to execute a restoration processing.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a medium management device used when a failure occurs in a file or the like in a data management system having an online transaction function.

[0002]

2. Description of the Related Art Conventionally, in a computer system or the like having an online transaction function, when a failure occurs in a file or a database (hereinafter referred to as a file), a save medium of a file or a save medium of a journal file required for recovery. The preparation of was left to the user.

Therefore, among the following three types of save data prepared for saving files, which file can be used to restore the computer system at the highest speed depends on the user's operation.

1. Total save (save of all data) 2. Thin save (save of update data after total save) 3. Incremental save (total save, thin save, or save of data updated after incremental save) In addition, since the media of the journal file used for roll forward after file restore is also managed by the user, recovery is possible due to human error. It took time.

[0005]

As described above, in the conventional computer system having the online transaction function, the information of the medium used for the failure recovery is managed even when the failure occurs in the file. Therefore, the system could not be restored at high speed due to user's mistakes in judgment or operation mistakes.

The present invention has been made in view of the above circumstances, and it is an object of the present invention to provide a medium management device capable of performing system restoration at high speed by managing a medium used for restoration in a database. To aim.

[0007]

Therefore, first, in order to achieve the above-mentioned object, the invention according to claim 1 is a medium management apparatus of a data management system comprising a transaction information management apparatus having an online transaction function. A file save block output means for outputting journal file information obtained from the transaction information management device in addition to the file save block and a journal file for which writing has been completed are detected from the transaction information management device, and a journal file save block is created. Journal file save block output means, a file save block output from the file save block output means, and a journal file output from the journal file save block output means. Medium saving means for creating and outputting medium information indicating a relationship with a save block, a medium management database for storing medium information output from the medium information output means, and a medium stored in the medium management database A medium information searching unit that searches the medium information necessary for the restoration based on the information, and a restoration process that performs the restoration process of the file save block and the journal file save block based on the medium information searched by the medium information searching unit. Means and means are provided.

The invention according to claim 2 is the medium management apparatus according to claim 1, wherein the invention according to claim 1 is a file save block output from the file save block output means by the medium information output means. The medium information indicating the relationship with the journal file save block output from the journal file save block output means is created and output, and the output medium information is stored in the medium management database. Then, the medium information searching unit searches the medium information necessary for restoration based on the medium information stored in the medium management database, and the restoration processing unit based on the medium information searched by the medium information searching unit. Since the file save block and the journal file save block are restored, the system can be restored at high speed.

According to the second aspect of the present invention, the overflow prevention means deletes the medium information stored in the medium management database after a lapse of a predetermined period, so that the medium management database can be prevented from overflowing.

[0010]

Embodiments of the present invention will be described below with reference to the drawings. <First Embodiment> FIG. 1 is a diagram showing the overall configuration of a medium management apparatus according to a first embodiment of the present invention (an embodiment corresponding to the invention of claim 1).

The file save unit 2a receives a file save command from the user, and an AIJ (clean point journal) of a transaction for which a CLPJ (clean point journal: a journal indicating an actual update of the database) is not collected from the transaction information management device 1 for managing transaction information. After-image journal: The position of the post-database journal is detected and the file is saved in the file 2b.

The file save unit 2a adds the journal file information obtained from the transaction information management device 1 to the FSB (file save block),
The information is output to the information registration device 4.

FIG. 2 is a diagram for explaining the configuration of the FSB output from the file save unit 2a to the information registration device 4. Of the information of the FSB, the save type indicates the type of total save, thin save, and incremental save.

The next pointer indicates a pointer to the next information, the journal file information includes the journal file information at the start of the save, and the relation pointer indicates
It shows pointers for thin save and incremental save information.

On the other hand, when the user issues a journal file save command, the journal file save unit 3a
Detects a journal file for which journal writing has been completed by the transaction information management device 1 and saves the journal file in the journal file 3b.

Further, the journal file save section 3a
Creates a JSB (journal file save block) as shown in FIG. 4 and outputs it to the information registration device 4. The information registration device 4 creates, in the memory, the medium management information having the data structure shown in FIG. 2 and showing the relationship between the FSB and the JSB, and stores it in the medium management database 5.

Further, the information registration device 4, when the saving of the journal file indicated by the FSB is not completed,
Since there is no JSB, “not yet” indicating that the save is not performed is set in the “save information” in the JSB to create a temporary JSB in which only the identification information of the journal file is set.

Next, a method of searching the medium management database 5 for recovering from a fault will be described. Here, a procedure for recovering at a designated date and time, for example, at x0: 00 will be described.

The information extracting device 6 first searches the total save queue in the FSB of the medium management database 5, and based on the save end time of the FSB stored in the FSB, the save end time is time x: 00. Faster than
And it is positioned as the latest FSB (A0).

Similarly, the information extracting device 6 also searches the thin save queue or the incremental save queue in the same manner to detect the information of the medium to be restored (B,
C). Next, based on the journal file information included in the latest block of the FSB, the journal save block queue is positioned (D), and among the JSB, the journal storage end time is later than the time x: 0 0 and the oldest JSB is selected. To detect.

Then, the file recovery unit 7 recovers the file and the journal file based on the medium information on the FSB and JSB. Therefore, according to the medium management apparatus of the present embodiment, the medium used for restoration is managed by the medium management database 5, and the information extraction apparatus 6 and the file restoration unit 7 perform efficient recovery, so that recovery is performed at high speed. be able to.

Next, a medium management apparatus according to a second embodiment of the present invention will be described (an embodiment corresponding to the invention of claim 2). The medium management device according to the above-described embodiment is
Although the medium is managed by the medium management database 5, the medium management database 5 may overflow because the expiration date of the medium information is not managed.

The medium management apparatus according to the present embodiment automatically deletes the medium management information stored in the medium management database 5 and updates the medium management database 5 to prevent the medium management database 5 from overflowing. It is a thing.

FIG. 5 is a diagram showing the configuration of a medium management device according to the second embodiment of the present invention (an embodiment corresponding to the invention of claim 2). Note that the same parts as those in FIG.

As shown in the figure, the difference between the medium management apparatus of the present embodiment and the above-described medium management apparatus is that the information management apparatus 11 is provided. This information management device 11
Based on the expiration date of the data initially set by the user,
When the file save unit 2a performs a total save, the medium information on the medium management database 5 that has expired is deleted and the medium management database 5 is updated.

Now, taking the case where the user specifies the time y: 00 as the expiration date in the information management apparatus 11, the information management apparatus 11 determines that the oldest total satisfying y: 0> save start time. Detect save blocks, total save blocks older than that, and
Delete the incremental save block, the incremental save block, the incremental save block, the incremental save block, and the total save block that are connected to it.

Further, the information management device 11 deletes all the JSBs older than the JSB indicated by the detected total save block and automatically updates the medium management database 11. Therefore, according to the medium management apparatus according to the present embodiment, the information management apparatus 11 can automatically delete / update the medium management information in the medium management database 5, so that the medium management database overflows. Can be prevented.

[0028]

As described above in detail, according to the present invention,
By managing the medium used for restoration in the database, it is possible to provide a medium management device capable of performing system restoration at high speed.

[Brief description of the drawings]

FIG. 1 is a diagram showing an overall configuration of a medium management device according to a first embodiment of the present invention.

FIG. 2 is a diagram for explaining the configuration of an FSB output from the file save unit of the medium management device to the information registration device in the same embodiment.

FIG. 3 is a diagram showing medium management information on a memory of the medium management apparatus in the same embodiment.

FIG. 4 is a JS output from the journal file save unit of the medium management apparatus in the embodiment to the information registration apparatus.
It is a figure for explaining the composition of B.

FIG. 5 is a diagram showing an overall configuration of a medium management device according to a second embodiment of the present invention.

[Explanation of symbols]

DESCRIPTION OF SYMBOLS 1 ... Transaction information management device, 2a ... File save part, 2b ... File, 3a ... Journal file save part, 3b ... Journal file, 4 ... Information registration device, 5 ... Medium management database, 6 ... Information extraction device.

Claims (2)

[Claims] 1. A medium management device of a data management system comprising a transaction information management device having an online transaction function, wherein a file save block output for outputting journal file information obtained from said transaction information management device in addition to a file save block. Means and a journal file for which writing has been completed is detected from the transaction information management device, a journal file save block output means for creating and outputting a journal file save block, and a file save output from the file save block output means Medium information output means for creating and outputting medium information indicating the relationship between the block and the journal file save block output from the journal file save block output means A medium management database that stores the medium information output from the medium information output unit; and a medium information search unit that searches the medium information necessary for restoration based on the medium information stored in the medium management database, A medium management apparatus comprising: a recovery processing unit that performs a recovery process of a file save block and a journal file save block based on the medium information retrieved by the medium information retrieval unit. 2. The medium management according to claim 1, further comprising overflow preventing means for preventing an overflow of the medium management database by deleting the medium information stored in the medium management database after a predetermined period of time. apparatus.