CN109597709A - A method of process breakpoint transmission is created for Oracle Dataguard - Google Patents
A method of process breakpoint transmission is created for Oracle Dataguard Download PDFInfo
- Publication number
- CN109597709A CN109597709A CN201811359314.5A CN201811359314A CN109597709A CN 109597709 A CN109597709 A CN 109597709A CN 201811359314 A CN201811359314 A CN 201811359314A CN 109597709 A CN109597709 A CN 109597709A
- Authority
- CN
- China
- Prior art keywords
- change
- library
- field
- dataguard
- checkpoint
- 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
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1448—Management of the data involved in backup or backup restore
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention for oracle database during create Dataguard, once interrupt, can not breakpoint transmission the problem of, provide it is a kind of for oracle database breakpoint transmission create Dataguard method.Creativeness of the invention is to compensate for the defect of oracle database itself, during very long creation Dataguard, if error, it is not necessary to restart synchrodata again, only need to synchronize variance data, realize the characteristic of breakpoint transmission.The present invention greatly reduces the time loss during creation Dataguard, reduces the waiting time of technical staff.
Description
Technical field
The present invention relates to Oracles database, it is the enhancing of creation Dataguard process primary to Oracle, makes up
A kind of defect that way error needs to restart, and in particular to side for Oracle Dataguard creation process breakpoint transmission
Method.
Background technique
Oracle Dataguard technology is the one of the creation Oracle backup database of the primary support of oracle database
Kind mode.
During creating Dataguard, Oracle provides shirtsleeve operation mode, realizes synchronously control during creation
File, data file, the simplification operation of the operations such as archive file.
When there is network, when the mistake of the levels such as storage, database, Dataguard visioning procedure will be terminated, primary wound
Building order cannot achieve the function of breakpoint transmission.Since oracle database volume may be larger, up to 30TB even 100TB with
On, once error, the time cost re-created are very high.
Summary of the invention
The defect restarted is needed for the error halfway of the primary creation Dataguard process of Oracle in the prior art,
The present invention provides a kind of methods for oracle database breakpoint transmission creation Dataguard, when primary using Oracle
When creating the error of Dataguard method process, this method can be used to realize breakpoint transmission, replaces the primary side that must start over
Method includes the following steps；
(1) it compares current primary database (hereinafter master library) and backup database (hereinafter for library) data file quantity is
It is no consistent.(2) are gone to if consistent, if inconsistent go to (3)；
(2) minimum FIRST_CHANGE# field values, the maximum NEXT_ in all continuous archive logs of master library are obtained
CHANGE# field values, i.e., all data files in V $ DATAFILE view in the range of continuous archive log, with standby library
CHECKPOINT_CHANGE# field compares.CHECKPOINT_CHANGE# field is less than master library archive log model if it exists
The record enclosed then goes to (3), otherwise goes to (4)；
(3) export master library controls file to standby library, covers the standby original ancient deed in library.And update has transmitted the information of data file extremely
Control file；
(4) minimum FIRST_CHANGE# field values, the maximum NEXT_ in all continuous archive logs of master library are obtained
CHANGE# field values, i.e., all data in V $ DATAFILE_HEADER view in the range of continuous archive log, with standby library
The CHECKPOINT_CHANGE# field of file compares.CHECKPOINT_CHANGE# field is filed less than master library if it exists
The record of log range；(5) are then gone to, (6) are otherwise gone to；
(5) information got according to (4) retransmits CHECKPOINT_CHANGE# field and is less than master library archive log range
Record signified data file, and more new information is to controlling file；
(6) log filing is executed in all examples of master library, records the FIRST_CHANGE# Field Count of newly-generated archive log
Value；
(7) according to the smallest CHECKPOINT_CHANGE# word in V $ DATAFILE view and V $ DATAFILE_HEADER view
Number of segment value, transmission difference archive log to standby library；
(8) RECOVER operation is executed in standby library, specifies the FIRST_CHANGE# field values for restoring to record into (6)；
(9) it can be created successfully with successful execution OPEN operation, Dataguard for library at this time, whole flow process terminates.
The present invention has significant technical effect: by breakpoint transmission, creating process due to using above technical scheme
The data transmitted before interruption can be multiplexed, without transmitting again, greatly reduce creation Oracle Dataguard when
Between cost.
Detailed description of the invention
Fig. 1 is the method flow schematic diagram for oracle database breakpoint transmission creation Dataguard.
Specific embodiment
Present invention is further described in detail with embodiment with reference to the accompanying drawing.
Embodiment 1
As shown in Figure 1, a kind of method for oracle database breakpoint transmission creation Dataguard, comprising the following steps:
(1) it compares current primary database (hereinafter master library) and backup database (hereinafter for library) data file quantity is
It is no consistent.(2) are gone to if consistent, if inconsistent go to (3)；
(2) minimum FIRST_CHANGE# field values, the maximum NEXT_ in all continuous archive logs of master library are obtained
CHANGE# field values, i.e., all data files in V $ DATAFILE view in the range of continuous archive log, with standby library
CHECKPOINT_CHANGE# field compares.CHECKPOINT_CHANGE# field is less than master library archive log range if it exists
Record, then go to (3), otherwise go to (4)；
(3) export master library controls file to standby library, covers the standby original ancient deed in library.And update has transmitted the information of data file extremely
Control file；
(4) minimum FIRST_CHANGE# field values, the maximum NEXT_ in all continuous archive logs of master library are obtained
CHANGE# field values, i.e., all data in V $ DATAFILE_HEADER view in the range of continuous archive log, with standby library
The CHECKPOINT_CHANGE# field of file compares.CHECKPOINT_CHANGE# field is filed less than master library if it exists
The record of log range；(5) are then gone to, (6) are otherwise gone to；
(5) information got according to (4) retransmits the note that CHECKPOINT_CHANGE# field is less than master library archive log range
Record signified data file, and more new information is to controlling file；
(6) log filing is executed in all examples of master library, records the FIRST_CHANGE# Field Count of newly-generated archive log
Value；
(7) according to the smallest CHECKPOINT_CHANGE# word in V $ DATAFILE view and V $ DATAFILE_HEADER view
Number of segment value, transmission difference archive log to standby library；
(8) RECOVER operation is executed in standby library, specifies the FIRST_CHANGE# field values for restoring to record into (6)；
(9) it can be created successfully with successful execution OPEN operation, Dataguard for library at this time, whole flow process terminates.
The present invention has significant technical effect: by breakpoint transmission, creating process due to using above technical scheme
The data transmitted before interruption can be multiplexed, without transmitting again, greatly reduce creation Oracle Dataguard when
Between cost.
In short, the foregoing is merely a prefered embodiment of the invention, it is all according to equivalent change made by scope of the present invention patent
With modification, shall all be covered by the patent of the invention.
Claims (2)
1. a kind of method for oracle database breakpoint transmission creation Dataguard, it is characterised in that: including following step
Suddenly；
(1) current primary database, abbreviation master library and backup database are compared, referred to as library, whether data file quantity is consistent；
(2) are gone to if consistent, if inconsistent go to (3)；
(2) minimum FIRST_CHANGE# field values, the maximum NEXT_ in all continuous archive logs of master library are obtained
CHANGE# field values, i.e., all data files in V $ DATAFILE view in the range of continuous archive log, with standby library
CHECKPOINT_CHANGE# field compares；CHECKPOINT_CHANGE# field is less than master library archive log range if it exists
Record, then go to (3), otherwise go to (4)；
(3) export master library controls file to standby library, covers the standby original ancient deed in library；And update has transmitted the information of data file extremely
Control file；
(4) minimum FIRST_CHANGE# field values, the maximum NEXT_ in all continuous archive logs of master library are obtained
CHANGE# field values, i.e., all data in V $ DATAFILE_HEADER view in the range of continuous archive log, with standby library
The CHECKPOINT_CHANGE# field of file compares；CHECKPOINT_CHANGE# field is less than master library and files day if it exists
The record of will range；(5) are then gone to, (6) are otherwise gone to；
(5) information got according to (4) retransmits the note that CHECKPOINT_CHANGE# field is less than master library archive log range
Record signified data file, and more new information is to controlling file；
(6) log filing is executed in all examples of master library, records the FIRST_CHANGE# Field Count of newly-generated archive log
Value；
(7) according to the smallest CHECKPOINT_CHANGE# word in V $ DATAFILE view and V $ DATAFILE_HEADER view
Number of segment value, transmission difference archive log to standby library；
(8) RECOVER operation is executed in standby library, specifies the FIRST_CHANGE# field values for restoring to record into (6)；
(9) standby library successful execution OPEN operation, Dataguard are created successfully.
2. the method for oracle database breakpoint transmission creation Dataguard, feature exist as described in claim 1
In: breakpoint transmission is factually showed by synchronization discrepancy heteromerism.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811359314.5A CN109597709B (en) | 2018-11-15 | 2018-11-15 | Method for breakpoint resume of Oracle Dataguard creation process |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811359314.5A CN109597709B (en) | 2018-11-15 | 2018-11-15 | Method for breakpoint resume of Oracle Dataguard creation process |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109597709A true CN109597709A (en) | 2019-04-09 |
| CN109597709B CN109597709B (en) | 2023-01-10 |
Family
ID=65958515
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811359314.5A Active CN109597709B (en) | 2018-11-15 | 2018-11-15 | Method for breakpoint resume of Oracle Dataguard creation process |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109597709B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113515573A (en) * | 2021-05-08 | 2021-10-19 | 上海英方软件股份有限公司 | Method and system for one-to-many negotiation replication breakpoint of ORACLE database |
| CN115129739A (en) * | 2022-08-31 | 2022-09-30 | 杭州沃趣科技股份有限公司 | Data file breakpoint continuous transmission method, device, equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| GB9406564D0 (en) * | 1994-03-31 | 1994-05-25 | Int Computers Ltd | Database management system |
| US6658589B1 (en) * | 1999-12-20 | 2003-12-02 | Emc Corporation | System and method for backup a parallel server data storage system |
| CN105975579A (en) * | 2016-05-05 | 2016-09-28 | 北京思特奇信息技术股份有限公司 | Primary and backup copying method of memory database and memory database system |
| CN106933843A (en) * | 2015-12-29 | 2017-07-07 | 阿里巴巴集团控股有限公司 | database heartbeat detecting method and device |
-
2018
- 2018-11-15 CN CN201811359314.5A patent/CN109597709B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| GB9406564D0 (en) * | 1994-03-31 | 1994-05-25 | Int Computers Ltd | Database management system |
| US6658589B1 (en) * | 1999-12-20 | 2003-12-02 | Emc Corporation | System and method for backup a parallel server data storage system |
| CN106933843A (en) * | 2015-12-29 | 2017-07-07 | 阿里巴巴集团控股有限公司 | database heartbeat detecting method and device |
| CN105975579A (en) * | 2016-05-05 | 2016-09-28 | 北京思特奇信息技术股份有限公司 | Primary and backup copying method of memory database and memory database system |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113515573A (en) * | 2021-05-08 | 2021-10-19 | 上海英方软件股份有限公司 | Method and system for one-to-many negotiation replication breakpoint of ORACLE database |
| CN115129739A (en) * | 2022-08-31 | 2022-09-30 | 杭州沃趣科技股份有限公司 | Data file breakpoint continuous transmission method, device, equipment and storage medium |
| CN115129739B (en) * | 2022-08-31 | 2022-11-25 | 杭州沃趣科技股份有限公司 | Data file breakpoint continuous transmission method, device, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109597709B (en) | 2023-01-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106776121B (en) | Data disaster recovery device, system and method | |
| EP1859363B1 (en) | Apparatus and method for identifying asynchronous data in redundant data stores and for re-synchronizing same | |
| EP2052337B1 (en) | Retro-fitting synthetic full copies of data | |
| CN108415793B (en) | Modifying membership of a replica group via a log operation | |
| US20040205391A1 (en) | Mirrored volume replication method, apparatus, and system | |
| DE112010003262B4 (en) | Synchronizing replicated sequential access storage components | |
| US7685189B2 (en) | Optimizing backup and recovery utilizing change tracking | |
| DE602005002532T2 (en) | CLUSTER DATABASE WITH REMOTE DATA MIRROR | |
| US20140059003A1 (en) | Automated migration to a new target volume via merged bitmaps to maintain consistency | |
| KR100825720B1 (en) | File management method in file system and metadata server for the same | |
| EP2521037A2 (en) | Geographically distributed clusters | |
| CN105574187B (en) | A kind of Heterogeneous Database Replication transaction consistency support method and system | |
| US7801867B2 (en) | Optimizing backup and recovery utilizing change tracking | |
| US8600937B1 (en) | System and method for fast volume cloning | |
| US7860828B2 (en) | System and method for transfering data from a source machine to a target machine | |
| CN109597709A (en) | A method of process breakpoint transmission is created for Oracle Dataguard | |
| CN104714811A (en) | Method and device for manufacturing difference upgrade package and system difference upgrade method and device | |
| US7152183B2 (en) | Method and apparatus for volume replication management at planned and unplanned link down | |
| CN102955720A (en) | Method for improving stability of EXT (extended) file system | |
| US7133984B1 (en) | Method and system for migrating data | |
| KR20190049266A (en) | Apparatus for controlling synchronization of metadata on network and method for the same | |
| CN111177122A (en) | Database backup method, device, equipment and computer readable storage medium | |
| CN101714169A (en) | Method and system for transmitting data on multiple nodes | |
| EP2542976A1 (en) | Method and apparatus of backing-up subversion repository | |
| US7580959B2 (en) | Apparatus, system, and method for providing efficient disaster recovery storage of data using differencing |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | 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 |