Unlock instant, AI-driven research and patent intelligence for your innovation.

Method for repairing database table space

A database and tablespace technology, applied in the field of repairing database tablespaces, can solve problems such as missing data and database inoperability, and achieve the effect of small data leakage

Pending Publication Date: 2017-12-15
福建星瑞格软件有限公司
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

All database objects are stored in the specified table space, but the main storage is the table, so it is called the table space; under certain circumstances, a certain area will be changed from the original online state to the offline state. Once this happens, the entire database may fail to operate. The normal repair method is to restore the original backup, but if the database is operated after the backup exists, some data will be lost, causing users You also need to do the same thing again

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for repairing database table space
  • Method for repairing database table space
  • Method for repairing database table space

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0018] Such as figure 1 Shown, the method that the present invention repairs database table space, comprises the steps:

[0019] Step 1. Open the root block of the database table space with a hexadecimal editor;

[0020] Step 2. Find the position of the status flag marked as an offline block;

[0021] Step 3. Modify the status flag to online status through a hexadecimal editor.

[0022] Generally speaking, the database will have a status flag (status flag) in the data file structure that controls it, and its content indicates the type and status of the data file.

[0023] Taking the Informix database as an example, its data files are called chunks, and each chunk has a status flag in its internal structure, and its hexadecimal value is as follows.

[0024] 0x0010 Mirror chunk

[0025] 0x0020 Chunkis off-line

[0026] 0x0040 Chunkis on-line (1)

[0027] 0x0080 Chunkis being recovered

[0028] 0x0100 Chunk is newly mirrored

[0029] 0x0200 Chunk belongs to ablobspace

...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention provides a method for repairing a database table space. The method comprises the steps of finding out a block marked to be in off-line state from a log of a database when the database cannot be accessed; using a hexadecimal editor to open a root block of the database table space; finding the position of the state mark of the block marked to be in off-line state; modifying the state mark into an online state through the hexadecimal editor; restarting the database, and verifying whether or not the database can be accessed normally. The method for repairing the database table space is convenient to use by a user and ensures that data cannot be lost.

Description

technical field [0001] The invention relates to a method for repairing database table space. Background technique [0002] All existing databases have table spaces, which are logical divisions of the database, and a table space can only belong to one database. All database objects are stored in the specified table space, but the main storage is the table, so it is called the table space; under certain circumstances, a certain area will be changed from the original online state to the offline state. Once this happens, the entire database may fail to operate. The normal repair method is to restore the original backup, but if the database is operated after the backup exists, some data will be lost, causing users It is also necessary to do the same operation again. Contents of the invention [0003] The technical problem to be solved by the present invention is to provide a method for repairing a database table space, which is convenient for users to use and ensures that dat...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30G06F11/14
CPCG06F11/1448G06F11/1464G06F16/22G06F16/2365
Inventor 周荣兴
Owner 福建星瑞格软件有限公司