CN106372170A - Database table recovery method and system and server with system - Google Patents
Database table recovery method and system and server with system Download PDFInfo
- Publication number
- CN106372170A CN106372170A CN201610780706.3A CN201610780706A CN106372170A CN 106372170 A CN106372170 A CN 106372170A CN 201610780706 A CN201610780706 A CN 201610780706A CN 106372170 A CN106372170 A CN 106372170A
- Authority
- CN
- China
- Prior art keywords
- data base
- auxiliary data
- space
- described auxiliary
- recover
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a database table recovery method and system and a server with the system. The table recovery method comprises the following steps that a parameter file used for creating an auxiliary database is generated so as to create the auxiliary database; a system table space of the auxiliary database is recovered; the auxiliary database is opened; a located table space of the table to be recovered is inquired; whether the table space exists in the system table space of the auxiliary database or not is judged; if so, the table to be recovered is exported from the auxiliary database; the exported table is imported into a main database; if not, the result shows that the located space of the table to be recovered is in a user table space of the auxiliary database; the located user table space of the table to be recovered is recovered; the table to be recovered is exported out of the auxiliary database; the exported table is imported into the main database. The cross-server table recovery is supported; the goals of reducing the influence on the production server and lowering the recovery risk are achieved; the recovery speed is accelerated.
Description
Technical field
The invention belongs to structural data protection field, it is related to a kind of restoration methods and system, more particularly to a kind of number
According to the restoration methods of table, system in storehouse and the server with this system.
Background technology
If, because maloperation delete or update data finally submit to, we must be by flash back area for user
Or back up and to correct these mistakes.
Flash back area technology has the limitation of itself, such as can only recover the data in nearest a period of time, can flash back
Go how long to depend on size of undo data volume etc. in system.When the area's function that flashes back can not meet demand, simply by
The method recovering backup set recovers data.
After oracle 10g, oracle provides the point-in-time recovery function of table space rank.In order to recover in table space
The a few tables in face, and remove to recover whole table space, it is not an effectively mode, because influencing whether its in table space
His object.
The recovery function of table time point is just provided after oracle 12c.This function can not recover the right of sys user's establishment
As it is impossible to recover table space system, the object inside sysaux, and need master library and theassistant base is present in a server
Interior.Theassistant base can take certain internal memory and disk space.In order to recover several tables, just in case exhausting the computer producing server
Resource, have impact on normal production, and the impact bringing can be bigger.
The table of oracle 12c recovers, and is the time point that the state setting based on master library returns to.If master library
After resetlogs, the time point that table recovers is can only be from the beginning of resetlogs, to current time.Also just say, the shape of master library
State can affect the recovery of table.
Therefore, the restoration methods of table, system and the server with this system in a kind of data base how are provided, to solve
Table recovery impact master library state in prior art, causes to exhaust computer resource, and the defect such as normal production of impact, in fact to become this
Skilled practitioner technical problem urgently to be resolved hurrily.
Content of the invention
The shortcoming of prior art in view of the above, it is an object of the invention to provide in a kind of data base table recovery side
Method, system and the server with this system, recover impact master library state in order to solve table in prior art, cause to exhaust calculating
Machine resource, the normal problem producing of impact.
For achieving the above object and other related purposes, one aspect of the present invention provides a kind of recovery side of table in data base
Method, in order to recover the table in MDL, in described data base, the restoration methods of table comprise the following steps: generate auxiliary in order to create
The Parameter File of data base, to create described auxiliary data base；Recover the system table space of described auxiliary data base；Open described auxiliary number
According to storehouse, inquire about the table space that the table that need to recover is located, and judge whether described table space is empty in the system table of described auxiliary data base
Between in；If so, the table that need recover is derived from described auxiliary data base, and the table derived is imported in described MDL；If it is not,
The table space that table that expression need to recover is located in user's table space of described auxiliary data base, the use that the table that recovers to recover is located
Family table space, and the table that need are recovered derives from described auxiliary data base, and the table derived is imported in described MDL.
In one embodiment of the invention, described MDL and auxiliary data base include the data file of storage table, record
The control file of the position of described data file, and/or record the described Parameter File controlling file；Generate in order to create described
Before the step of the Parameter File building auxiliary data base, in described data base, the restoration methods of table also include analyzing described MDL
Parameter File.
In one embodiment of the invention, the Parameter File of described auxiliary data base is included in order to the number with described MDL
According to library name identical with the database-name using backup piece produced by described MDL, in order to exist with described MDL
The mark that process is distinguished, and/or with described control file；The step of the described Parameter File generating in order to create auxiliary data base is also
Configure described Parameter File including in the text of described auxiliary data base.
In one embodiment of the invention, the start-up course of described auxiliary data base includes loading Parameter File not
Carry state, in order to according to recording the described position controlling file, to load the described carry state controlling file, and in order to carry
The open mode of described data file；The step of the described system table space recovering described auxiliary data base includes: by described auxiliary number
According to storehouse start to described in non-carry state；Also multiple described control file；Described auxiliary data base is started to described carry state；Weight
Name the position of online daily record in described system table space；Reduce the data file in described system table space, recover described number
According to the table in file, and open described auxiliary data base described in proceeding to, inquire about the table space that the table that need to recover is located, and judge described
Whether table space is the step of the system table space of described auxiliary data base.
In one embodiment of the invention, if the table space that the table recovering is located is user's table space, described recovery needs
The step of user's table space that the table recovering is located includes: closes described auxiliary data base, and described auxiliary data base is started to extension
Load state；The position of user's table space described in renaming；Reduce user's table space that described table is located, and recover described user's table
Table in space, proceeds to the step that the described table recovering need is derived from described auxiliary data base.
In one embodiment of the invention, the table at the table place that need to be recovered by the system view inquiry of described auxiliary data base
Space.
In one embodiment of the invention, the table that need are recovered by the dump instrument that provided by described auxiliary data base is from described
Auxiliary data base derives；If described auxiliary data base carries out cross-server table recovery, the support being provided by described auxiliary data base is long-range
Import tool imports the table derived in described MDL.
Another aspect of the present invention provides a kind of recovery system of table in data base, the table recovery system bag of described data base
Include: creation module, for generating in order to create the Parameter File of auxiliary data base, to create described auxiliary data base；Main recovery module,
For recovering the system table space of described auxiliary data base；Processing module, is used for opening described auxiliary data base, inquires about the table that need to recover
The table space being located, and judge described table space whether in the system table space of described auxiliary data base；If so, need are recovered
Table is derived from described auxiliary data base, and the table derived is imported in described MDL；If it is not, representing what the table that need to recover was located
, in user's table space of described auxiliary data base, user's table at the table place that order time recovery module recovery need to recover is empty for table space
Between, and the table that need are recovered derives from described auxiliary data base, and the table derived is imported in described MDL.
In one embodiment of the invention, described processing module will be needed extensive by the dump instrument that described auxiliary data base provides
Multiple table is derived from described auxiliary data base；If described auxiliary data base carries out cross-server table recovery, carried by described auxiliary data base
For support be remotely guided instrument by derive table import described MDL in.
Another aspect of the invention provides a kind of server, and described server includes: as any one of claim 8-9
Data base in table recovery system.
As described above, the restoration methods of table, system and the server with this system in the data base of the present invention, have with
Lower beneficial effect:
First, by creating an auxiliary data base unrelated with MDL state, version after support oracle10g
Table recovers, and can recover the information of the table before master library resetlogs it is also possible to recover the object of sys.
Second, auxiliary data base with master library on a different server, can support that the table of cross-server recovers, and reach and subtract
Few impact to production server, reduces the purpose of the risk of recovery.
3rd, different from use on the market Backup and Restore software, due to use on the market Backup and Restore software
It is to name using duplicate to create auxiliary data base.And duplicate order can be carried out to table space certainly in pressure data storehouse
Comprise to detect, if being unsatisfactory for self-contained, recovery can fail.Therefore, self-contained in order to meet table space, can recover unrelated with table
Table space.The data quantitative change recovering is big, and recovery time is elongated, and the disk space that also assistance data Kuku takies can become many.
The present invention need not recover the table space unrelated with table, with respect to existing Backup and Restore software rejuvenation data volume less, and improves
Resume speed.
Brief description
Fig. 1 is shown as the restoration methods of table in the data base of the present invention schematic flow sheet in an embodiment.
Fig. 2 is shown as the schematic flow sheet of step s3 in the restoration methods of table in the data base of the present invention.
Fig. 3 is shown as the schematic flow sheet of step s6 in the restoration methods of table in the data base of the present invention.
Fig. 4 is shown as the recovery system of table in the data base of the present invention theory structure schematic diagram in an embodiment.
Fig. 5 is shown as the server of the present invention theory structure schematic diagram in an embodiment.
Component label instructions
The recovery system of table in 1 data base
11 analysis modules
12 creation modules
13 main recovery modules
14 processing modules
15 recovery modules
2 servers
S1～s7 step
S31～s35 step
S61～s63 step
Specific embodiment
Below by way of specific instantiation, embodiments of the present invention are described, those skilled in the art can be by this specification
Disclosed content understands other advantages and effect of the present invention easily.The present invention can also be by addition different concrete realities
The mode of applying is carried out or applies, and the every details in this specification can also be based on different viewpoints and application, without departing from
Carry out various modifications and changes under the spirit of the present invention.It should be noted that, in the case of not conflicting, following examples and enforcement
Feature in example can be mutually combined.
It should be noted that the diagram provided in following examples only illustrates the basic structure of the present invention in a schematic way
Think, then only show the assembly relevant with the present invention in schema rather than according to component count during actual enforcement, shape and size
Draw, during its actual enforcement, the kenel of each assembly, quantity and ratio can be a kind of random change, and its assembly layout kenel
It is likely more complexity.
Embodiment one
The present embodiment provides a kind of restoration methods of table in data base, in order to recover the table in MDL, described data
In storehouse, the restoration methods of table comprise the following steps:
Generate in order to create the Parameter File of auxiliary data base, to create described auxiliary data base；
Recover the system table space of described auxiliary data base；
Open described auxiliary data base, inquire about the table space that the table that need to recover is located, and judge described table space whether in institute
State in the system table space of auxiliary data base；If so, the table that need recover is derived from described auxiliary data base, and the table derived is imported
In described MDL；If it is not, representing the table space at the table that need to recover place in user's table space of described auxiliary data base, extensive
User's table space that the table that need to recover again is located, and the table that need are recovered derives from described auxiliary data base, and the table of derivation is led
Enter in described MDL.
Below in conjunction with diagram, the restoration methods of table in the data base described in the present embodiment are described in detail.The present embodiment
In described data base, the restoration methods of table are applied particularly to oracle database, and the table in described oracle database is carried out
Recover.In data base described in the present embodiment, the restoration methods of table can be carried out it is also possible to cross-server is held on same server
OK.But because some server performances are poor, if master library and auxiliary storehouse are all present in same server, auxiliary storehouse also can take one
Fixed internal memory and disk space, may affect original master library.If cross-server recovers table, by other servers
Necessary information is extracted in the auxiliary storehouse creating, and then returns in master library, will compare flexible.
Refer to Fig. 1, be shown as the restoration methods of table in the data base schematic flow sheet in an embodiment.As Fig. 1 institute
Show, in described data base, the restoration methods of table comprise the following steps:
S1, the Parameter File in order to start described MDL of analysis MDL, when creating auxiliary data base, to join
Parameter File according to described MDL configures the Parameter File of described auxiliary data base.Described MDL and auxiliary data base include
The data file of storage table, records the control file of the position of described data file, and/or records the described parameter controlling file
File.In the present embodiment, the start-up course of described auxiliary data base includes the non-carry state loading Parameter File, that is,
Nomount state；In order to according to recording the described position controlling file, to load the described carry state controlling file, i.e. moun
State；And the open mode in order to data file described in carry, i.e. open state.
S2, generates in order to create the Parameter File of auxiliary data base, to create described auxiliary data base.The ginseng of described auxiliary data base
Number file includes:
In order to identical with the database-name of described MDL with using backup piece produced by described MDL
Database-name, described in the present embodiment auxiliary wide area information server title is designated as db_name.During DB Backup, can produce
Raw backup piece.Db_name is recorded in described backup piece.When using backup piece, oracle can check, current database
Whether db_name is consistent with the db_name of backup piece, if it is not, backup piece then can not be used.
In order to the mark distinguished in process with described MDL, in the present embodiment, the mark note of described auxiliary data base
For db_unique_name.The db_unique_name of auxiliary data base is different from master library, so that master library and auxiliary storehouse are in process
Make a distinction.And/or
There is the control file of the position of the data file of table in order to record storage, in the present embodiment, described auxiliary data base
Control file be designated as control_files.
In other words, described step s2 is to configure described parameter in the text (pfile file) of described auxiliary data base
File, db_name, db_unique_name, control_files.
S3, recovers the system table space of described auxiliary data base.In the present embodiment, must first can recovery system table space
, there is no system table space, data base cannot start.Refer to Fig. 2, be shown as the schematic flow sheet of step s3.As Fig. 2 institute
Show, described step s3 specifically includes following step:
S31, by described auxiliary data base start to described in non-carry state.
S32, also multiple (restore) described control file.In the present embodiment, restore is the recovery of file-level, physics
The recovery of file.
S33, described auxiliary data base is started to described carry state.
S34, the position of online daily record in system table space described in renaming.
S35, the data file in reduction (restore) described system table space, recover (recover) described data file
In table, and proceed to step s4.In the present embodiment, recover is the recovery of data level.Recover in logic, such as application is returned
Shelves daily record, redo log, fully synchronized, be consistent.
S4, opens described auxiliary data base, inquires about the table space that the table that need to recover is located.In the present embodiment, by system
View all_tables or all_tab_partitions inquires table space and the owning user at table place.
S5, judges described table space whether in the system table space of described auxiliary data base, if not then it represents that the table that need to recover
The table space being located in user's table space of described auxiliary data base, execution step s6 and s7.If then it represents that the table that need to recover
The table space being located, in system table space, avoids the need for recovery system table space.Continue executing with step s7.
S6, user's table space that the table recovering to recover is located.In the present embodiment, by inquiry table in user's table space
The inside, if there are 7 user's table spaces, only recovers user's table space that the table inside 7 user's table spaces is located.Refer to figure
3, it is shown as the schematic flow sheet of step s6.As shown in figure 3, described step s6 specifically includes following steps:
S61, closes described auxiliary data base, and described auxiliary data base is started to carry state.
S62, the position of user's table space described in renaming.
S63, user's table space that reduction (restore) described table is located, and recover (recover) described user table space
In table, proceed to step s7.
S7, the table that need are recovered is derived from described auxiliary data base, and the table derived is imported in described MDL.At this
In embodiment, the dump instrument that provided by described auxiliary data base, the table that is, need are recovered by exp/expdb is from described auxiliary data base
Derive.In the present embodiment, if auxiliary data base and MDL are located in same server, the table of derivation is placed directly within institute
State in MDL.If described auxiliary data base carries out cross-server table recovery, that is, auxiliary data base and MDL are located at different clothes
Business device, is remotely guided instrument by the support that described auxiliary data base provides, that is, imp/impdb the table of derivation is remotely guided described
In MDL.Setting cross-server table recovers to be because oracle 12c itself has the function of table recovery in the present embodiment,
But oracle 12c does not support that cross-server recovers (not supporting the recovery of sys object), and cross-server recovers to reduce to clothes
The impact of business device, relatively more flexible.
In data base described in the present embodiment, the restoration methods of table, have the advantages that
First, by creating an auxiliary data base unrelated with MDL state, version after support oracle10g
Table recovers, and can recover the information of the table before master library resetlogs it is also possible to recover the object of sys.
Second, auxiliary data base with master library on a different server, can support that the table of cross-server recovers, and reach and subtract
Few impact to production server, reduces the purpose of the risk of recovery.
3rd, different from use on the market Backup and Restore software, due to use on the market Backup and Restore software
It is to name using duplicate to create auxiliary data base.And duplicate order can be carried out to table space certainly in pressure data storehouse
Comprise to detect, if being unsatisfactory for self-contained, recovery can fail.Therefore, self-contained in order to meet table space, can recover unrelated with table
Table space.The data quantitative change recovering is big, and recovery time is elongated, and the disk space that also assistance data Kuku takies can become many.
The present invention need not recover the table space unrelated with table, with respect to existing Backup and Restore software rejuvenation data volume less, and improves
Resume speed.
Embodiment two
The present embodiment provides a kind of recovery system 1 of table in data base, refers to Fig. 4, is shown as the extensive of table in data base
Theory structure schematic diagram in an embodiment for the complex system.As shown in figure 4, the table recovery system 1 of described data base includes: analysis
Module 11, creation module 12, main recovery module 13, processing module 14 and secondary recovery module 15.
Described analysis module 11 is used for analyzing the Parameter File in order to start described MDL of described MDL, with
When creating auxiliary data base, with reference to the Parameter File of the Parameter File described auxiliary data base of configuration of described MDL.Described master
Data base and auxiliary data base include the data file of storage table, record the control file of the position of described data file, and/or note
The described Parameter File controlling file of record.In the present embodiment, the start-up course of described auxiliary data base includes loading ginseng
The non-carry state of number file, i.e. nomount state；In order to according to recording the described position controlling file, to load described control
The carry state of file, i.e. moun state；And the open mode in order to data file described in carry, i.e. open state.
The creation module 12 being connected with described analysis module 11 is used for generating in order to create the Parameter File of auxiliary data base, with
Create described auxiliary data base.The Parameter File of described auxiliary data base includes:
In order to identical with the database-name of described MDL with using backup piece produced by described MDL
Database-name, described in the present embodiment auxiliary wide area information server title is designated as db_name.
In order to the mark distinguished in process with described MDL, in the present embodiment, the mark note of described auxiliary data base
For db_unique_name.And/or
There is the control file of the position of the data file of table in order to record storage, in the present embodiment, described auxiliary data base
Control file be designated as control_files.
In the present embodiment, described creation module 12 is additionally operable to the text (pfile file) in described auxiliary data base
The described Parameter File of middle configuration, db_name, db_unique_name, control_files.
The main recovery module 13 being connected with described creation module 12 is used for recovering the system table space of described auxiliary data base.Institute
State creation module 13 specifically for non-carry state described in starting to described auxiliary data base；Also multiple (restore) described control
File, described auxiliary data base is started to described carry state, the position of online daily record in system table space described in renaming；Also
Data file in former (restore) described system table space, recovers the table in (recover) described data file.
The processing module 14 being connected with described main recovery module 13 is used for opening described auxiliary data base, inquires about the table that need to recover
The table space being located.In the present embodiment, described processing module 14 passes through system view all_tables or all_tab_
Partitions inquires table space and the owning user at table place.
Described processing module 14 is additionally operable to judge described table space whether in the system table space of described auxiliary data base, if
No then it represents that the table space that is located of the table that need to recover, in user's table space of described auxiliary data base, makes described recovery module
User's table space that 15 tables recovering to recover are located, after described recovery module 15 recovers the table that need to recover, described process
The table that need recover is derived by module 14 from described auxiliary data base, and the table derived is imported in described MDL.If so, then table
The table space showing the table that need to recover place is in system table space.The table that need are recovered is derived from described auxiliary data base, and will derive
Table import described MDL in.
Described recovery module 15 is specifically for closing described auxiliary data base, and described auxiliary data base is started to carry shape
State；The position of user's table space described in renaming；User's table space that reduction (restore) described table is located, and recover
(recover) table in described user's table space.
In the present embodiment, the dump instrument that described processing module 14 is provided by described auxiliary data base, i.e. exp/expdb
The table that need are recovered is derived from described auxiliary data base.In the present embodiment, if auxiliary data base and MDL are located at same service
In device, then the table of derivation is placed directly within described MDL.If described auxiliary data base carries out cross-server table recovery, that is, auxiliary
Data base and MDL are located at different server, and described processing module 14 is remotely led by the support that described auxiliary data base provides
Enter instrument, that is, the table of derivation is remotely guided in described MDL imp/impdb.Cross-server table is set in the present embodiment
Recovery is because oracle 12c itself has the function of table recovery, but oracle 12c does not support that cross-server recovers (not prop up
Hold the recovery of sys object), and cross-server recovers to reduce the impact to server, relatively more flexible.
The present embodiment also provides a kind of server 2, refers to Fig. 5, is shown as principle knot in an embodiment for the server
Structure schematic diagram.As shown in figure 5, described server 2 includes the recovery system 1 of table in above-mentioned data base.In the present embodiment, described
Auxiliary data base can be only included it is also possible to include MDL and auxiliary data base in service 2.
In sum, the restoration methods of table, system and the server with this system in data base of the present invention, have
Following beneficial effect:
First, by creating an auxiliary data base unrelated with MDL state, version after support oracle10g
Table recovers, and can recover the information of the table before master library resetlogs it is also possible to recover the object of sys.
Second, auxiliary data base with master library on a different server, can support that the table of cross-server recovers, and reach and subtract
Few impact to production server, reduces the purpose of the risk of recovery.
3rd, different from the Backup and Restore software using on the market, due to use on the market Backup and Restore software be
Named using duplicate and create auxiliary data base.And uplicate order can be carried out to table space certainly wrapping in pressure data storehouse
Containing detection, if being unsatisfactory for self-contained, recovery can fail.Therefore, self-contained in order to meet table space, can recover unrelated with table
Table space.The data quantitative change recovering is big, and recovery time is elongated, and the disk space that also assistance data Kuku takies can become many.This
Invention need not recover the table space unrelated with table, with respect to existing Backup and Restore software rejuvenation data volume less, and improves extensive
Complex velocity.
Above-described embodiment only principle of the illustrative present invention and its effect, and be not used to limit the present invention.Any ripe
The personage knowing this technology all can carry out modifications and changes without prejudice under the spirit and the scope of the present invention to above-described embodiment.Cause
This, those of ordinary skill in the art is complete with institute under technological thought without departing from disclosed spirit such as
All equivalent modifications becoming or change, must be covered by the claim of the present invention.
Claims (10)
1. in a kind of data base the restoration methods of table it is characterised in that in order to recover the table in MDL, in described data base
The restoration methods of table comprise the following steps:
Generate in order to create the Parameter File of auxiliary data base, to create described auxiliary data base；
Recover the system table space of described auxiliary data base；
Open described auxiliary data base, inquire about the table space that the table that need to recover is located, and judge described table space whether described auxiliary
In the system table space of data base；If so, the table that need recover is derived from described auxiliary data base, and the table derived is imported described
In MDL；If it is not, representing that the table space at the table that need to recover place, in user's table space of described auxiliary data base, recovers to need
User's table space that the table recovering is located, and the table that need are recovered derives from described auxiliary data base, and the table derived is imported institute
State in MDL.
2. in data base according to claim 1 table restoration methods it is characterised in that: described MDL and auxiliary data
Storehouse includes the data file of storage table, records the control file of the position of described data file, and/or records described control file
Parameter File；Before the described step generating in order to the Parameter File creating auxiliary data base, in described data base, table is extensive
Compound recipe method also includes analyzing the Parameter File of described MDL.
3. in data base according to claim 2 table restoration methods it is characterised in that:
The Parameter File of described auxiliary data base is included in order to identical with the database-name of described MDL with using described master
The database-name of backup piece produced by data base, in order to the mark distinguished in process with described MDL, and/or uses institute
State control file；
Described generation is additionally included in the text of described auxiliary data base in order to create the step of the Parameter File of auxiliary data base
Configure described Parameter File.
4. in data base according to claim 3 table restoration methods it is characterised in that: the startup of described auxiliary data base
Process includes the non-carry state loading Parameter File, in order to according to recording the described position controlling file, to load described
Control the carry state of file, and the open mode in order to data file described in carry；The described auxiliary data base of described recovery is
The step of system table space includes:
By described auxiliary data base start to described in non-carry state；
Also multiple described control file；
Described auxiliary data base is started to described carry state；
The position of online daily record in system table space described in renaming；
Reduce the data file in described system table space, recover the table in described data file, and open described in proceeding to described
Auxiliary data base, inquires about the table space that the table that need to recover is located, and judges that whether described table space is the system of described auxiliary data base
The step of table space.
5. in data base according to claim 3 table restoration methods it is characterised in that: if the table that the table recovering is located is empty
Between for user's table space when, the step of user's table space that table that described recovery need to recover is located includes:
Close described auxiliary data base, and described auxiliary data base is started to carry state；
The position of user's table space described in renaming；
Reduce user's table space that described table is located, and recover the table in described user's table space, proceed to and described need are recovered
The step that table is derived from described auxiliary data base.
6. in data base according to claim 1 table restoration methods it is characterised in that: by described auxiliary data base be
The table space that the table that system view query need to recover is located.
7. in data base according to claim 1 table restoration methods it is characterised in that:
The table that need recover is derived by the dump instrument being provided by described auxiliary data base from described auxiliary data base；
If described auxiliary data base carries out cross-server table recovery, being remotely guided instrument by the support that described auxiliary data base provides will
The table derived imports in described MDL.
8. in a kind of data base table recovery system it is characterised in that in described data base the recovery system of table include:
Creation module, for generating in order to create the Parameter File of auxiliary data base, to create described auxiliary data base；
Main recovery module, for recovering the system table space of described auxiliary data base；
Processing module, is used for opening described auxiliary data base, inquires about the table space that the table that need to recover is located, and judges described table space
Whether in the system table space of described auxiliary data base；If so, the table that need recover is derived from described auxiliary data base, and will derive
Table import described MDL in；If it is not, representing user's table in described auxiliary data base for the table space at the table place that need to recover
In space, user's table space that table that order time recovery module recovers to recover is located, and the table that need are recovered is from described auxiliary data
Storehouse is derived, and the table derived is imported in described MDL.
9. in data base according to claim 8 table recovery system it is characterised in that: described processing module pass through described
The table that need recover is derived by the dump instrument that auxiliary data base provides from described auxiliary data base；If described auxiliary data base is carried out across service
Device table recovers, and is remotely guided instrument by the support that described auxiliary data base provides and imports the table derived in described MDL.
10. a kind of server is it is characterised in that described server includes: the data base as any one of claim 8-9
The recovery system of middle table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610780706.3A CN106372170B (en) | 2016-08-30 | 2016-08-30 | Method and system for recovering table in database and server with system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610780706.3A CN106372170B (en) | 2016-08-30 | 2016-08-30 | Method and system for recovering table in database and server with system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106372170A true CN106372170A (en) | 2017-02-01 |
| CN106372170B CN106372170B (en) | 2020-02-14 |
Family
ID=57899312
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610780706.3A Active CN106372170B (en) | 2016-08-30 | 2016-08-30 | Method and system for recovering table in database and server with system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106372170B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101436207A (en) * | 2008-12-16 | 2009-05-20 | 浪潮通信信息系统有限公司 | Data restoring and synchronizing method based on log snapshot |
| CN101814045A (en) * | 2010-04-22 | 2010-08-25 | 华中科技大学 | Data organization method for backup services |
| CN103853837A (en) * | 2014-03-17 | 2014-06-11 | 上海爱数软件有限公司 | Oracle table-level backup and recovering method for full-automatic continuously producing databases |
| CN105320576A (en) * | 2014-05-30 | 2016-02-10 | 中国电信股份有限公司 | Device and method for database backup |
-
2016
- 2016-08-30 CN CN201610780706.3A patent/CN106372170B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101436207A (en) * | 2008-12-16 | 2009-05-20 | 浪潮通信信息系统有限公司 | Data restoring and synchronizing method based on log snapshot |
| CN101814045A (en) * | 2010-04-22 | 2010-08-25 | 华中科技大学 | Data organization method for backup services |
| CN103853837A (en) * | 2014-03-17 | 2014-06-11 | 上海爱数软件有限公司 | Oracle table-level backup and recovering method for full-automatic continuously producing databases |
| CN105320576A (en) * | 2014-05-30 | 2016-02-10 | 中国电信股份有限公司 | Device and method for database backup |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106372170B (en) | 2020-02-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106933570B (en) | Aerospace test, launch and control software platform based on plug-in technology | |
| CN105359141B (en) | Supporting a combination of flow-based ETL and entity relationship-based ETL | |
| US9648059B2 (en) | System and methods for multi-user CAx editing conflict management | |
| CN103514023B (en) | The method and system that a kind of virtual machine off-line automatic software is installed | |
| CN108536752A (en) | A kind of method of data synchronization, device and equipment | |
| KR20150087325A (en) | System, method, and apparatus for collaborative cax editing | |
| CN106681956A (en) | Method and device for operating large-scale computer cluster | |
| WO2016026328A1 (en) | Information processing method and device and computer storage medium | |
| US20120278306A1 (en) | Retrieving data objects | |
| CN106991104B (en) | Database script deployment device and database script deployment method | |
| CN103744647A (en) | Java workflow development system and method based on workflow GPD | |
| CN107659455A (en) | A kind of method, storage medium, equipment and the system of iOS ends Mock data | |
| CN102289513A (en) | Method and system for obtaining internal files of virtual machine | |
| CN104008441A (en) | Task management system and method for automatically submitting files into version library | |
| CN101221504A (en) | Test script processing method and its scheduling and executing system | |
| CN104820625B (en) | A kind of data record, backup and the restoration methods of Information management system | |
| CN109933338A (en) | Block chain dispositions method, device, computer equipment and storage medium | |
| CN106802895A (en) | For repair data storehouse for database data method and apparatus | |
| CN104899141A (en) | Test case selecting and expanding method facing network application system | |
| US20150178122A1 (en) | Method and system for providing a high-availability application | |
| US8650534B2 (en) | Metaobject enhancement objects | |
| CN107832352A (en) | Daily record automatic processing method, device, storage medium and equipment | |
| CN109032940B (en) | Test scene input method, device, equipment and storage medium | |
| CN106372170A (en) | Database table recovery method and system and server with system | |
| CN103425550B (en) | A kind of system cloning process and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |