CN109522161A - Implementation method of the Oracle GoldenGate under unshared storage deployment - Google Patents
Implementation method of the Oracle GoldenGate under unshared storage deployment Download PDFInfo
- Publication number
- CN109522161A CN109522161A CN201811442745.8A CN201811442745A CN109522161A CN 109522161 A CN109522161 A CN 109522161A CN 201811442745 A CN201811442745 A CN 201811442745A CN 109522161 A CN109522161 A CN 109522161A
- Authority
- CN
- China
- Prior art keywords
- host
- goldengate
- source
- calamity
- standby end
- 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.)
- Pending
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/1458—Management of the backup or restore process
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/80—Database-specific techniques
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/82—Solving problems relating to consistency
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 invention discloses a kind of implementation method of Oracle GoldenGate under unshared storage deployment, include the following steps: S1: respectively on first host at the standby end of the first host and calamity of source, disposing GoldenGate software, and Checkpointing table;S2: on the second host of source, replicating the GoldenGate catalogue of the first host of source, on second host at the standby end of calamity, the GoldenGate catalogue of the first host of the standby end of duplication calamity;S3: stopping the disaster tolerance link between the first host of source and first host at the standby end of calamity, and the emergency link being switched between the second host of source and second host at the standby end of calamity starts duplicating process.Implementation method of the Oracle GoldenGate provided by the invention under unshared storage deployment, ensures data without loss by checkpoint table mechanism;The transmission mechanism of data is reliable;Hardware-dependent degree is greatly reduced, GoldenGate software deployment is in local server, without using the shared storage of high-performance individually deployment;Device is easy to use, and the requirement to user of service is low.
Description
Technical field
The present invention relates to a kind of database disaster recovery methods more particularly to a kind of Oracle GoldenGate to deposit unshared
Implementation method under storage deployment.
Background technique
As informationization gradually occupies leading role in social life, the information that people's lives are gradually increasingly permeated is controlled
It is surrounded.And with 911 for the variation of the international security situation of notable feature and the unexpected encounter of all kinds of large sizes or sudden disaster,
Make people see information be centralized in bring into social progress and change life while, also bring the risk set of height
In.Under the threat of various risks, robustness and the ability for resisting risk directly determine the core carrier information system of business
The survival ability of enterprise's even industry, becomes the basic guarantee of excellent service standard.
It has thus extended out and has been seen in a popular vocabulary disaster tolerance system of space in a newspaper and all kinds of media again and again recently.Construction
Disaster tolerance system, which refers to, is dissolved the influence of disaster using various technologies and management means, its main forms are two sides
Face: first is that guaranteeing the safety of business data;Second is that guaranteeing the continuity of business.When the informatization of each enterprise has moved towards one
Can new level effectively establish Disaster Defensive system when facing all kinds of regulations, competition, the new requirement of high-quality service
The milestone just further developed at enterprise.The rendering that the construction meaning of disaster tolerance system has been covered the sky and the earth, it is at different levels
Government and industry also start to lay down a regulation, and crisis response of the specification information system under various disasters is horizontal, from every aspect,
Whether it is necessary to build disaster tolerance system to have passed by the stage inquired into, and putting in face of people is that another expects in the past
Too late problem -- establish the complexity of disaster tolerance system.The complexity of this problem people consider disaster tolerance system planning and
It has shown especially and has come out when construction scheme, such as: it is found that when proposing an ideal all kinds of uniform service Disaster Defensive systems
Construction object after, can not but select the technology path met the requirements or need extremely high cost.For another example, people
It was found that IT department is but unable to control the disaster tolerance process an of entirety, and the formulation of process is a need in disaster tolerance System Construction
The more arm of the services engineerings for wanting the whole people to realize, etc. are such.
How about the data real-time update for how guaranteeing disaster tolerance system and production system guarantees disaster tolerance system in production system
Data being switched fast without loss under fortuitous event, this is the critically important project faced now.In reality, a technology
The quality overwhelming majority of the operation system that frame is fixed, database schema is stable, operational reliability depends on database disaster tolerance
The reliability of system.And a set of reasonable database disaster tolerance system configuration is played a crucial role with switching flow.
And Oracle GoldenGate software is a kind of structural data copy backup software based on log, it passes through
It parses the online log of source database or archive log obtains the increment variation of data, then by these change applications to target data
Library, to realize that source database is synchronous with target database.It can be in IT foundation structure (including nearly all common behaviour of isomery
Make system platform and database platform) between realize mass data submicrosecond level-one real-time duplication, thus can emergency be
System, the supply of online report, real-time data warehouse, transaction tracking, data synchronization, concentration/distribution, disaster tolerance, database upgrade and shifting
It is applied under multiple scenes such as plant, double service centers.Meanwhile Oracle GoldenGate can also realize one-to-one, broadcast (one
To more), polymerization (many-one), it is two-way, point-to-point, cascade etc. a variety of flexible topological structures.
Oracle GoldenGate is a kind of software-based data copy mode, it from extract source database day
The variation of will (redo log or archive log) parsing data (data volume only has a quarter of log or so).
After Oracle GoldenGate converts data variation to the format of oneself, directly by TCP/IP network transmission, without relying on
In the transfer mode of database itself, and data Zhong row can be compressed by being up to the compression ratio of 10:1, can be dropped significantly
Low bandwidth needs.In target side, Oracle GoldenGate can be recombinated by transaction, and the technological means such as load are significantly in batches
The speed and efficiency for accelerating data delivery, reduce the resource occupation of goal systems, can realize answering for mass data in submicrosecond grade
System, and target client database is movable.
For under Oracle Rac database environment, mainly point the following two kinds situation is disposed at present:
1), only on the local disk of each node at source and disaster tolerance end, Oracle GoldenGate software is disposed.
As shown in Figure 1, maintenance personnel needs to estimate target side team by personal experience's Manual analysis when 1 hostdown of source end node
The time that column file final data generates reconfigures GoldenGate on 2 host of source end node and extracts environment;If maintenance
Personnel can not judge the time that target side queue file final data generates by personal experience, and maintenance personnel needs in source section
While building GoldenGate environment again on 2 hosts of point, all data of target side are reinitialized.
Have the following disadvantages: that 1, switching time is too long in this deployment situation.Either maintenance personnel is by virtue of experience manual
Analytical estimating target side queue file's final data generate time, still reinitialize data built on node 2 it is new
GoldenGate environment, according to the difference of data volume size, the operating time takes several hours even several days.2, data risk is lost
It is high.For fast quick-recovery disaster tolerance system, the time for often giving operation maintenance personnel analysis log is seldom.Operation maintenance personnel can only be according to estimating
The time of calculation, which reconfigure, extracts end starting time point.The time point is later than 1 fault time of node, will cause partial data
Missing.The time point earlier than 1 fault time of node, will cause partial data and repeat to modify.3, high to the dependence of people.Even if using
Logdump tool is delivered to the queue file of target side to analyze, and information is very big in queue file and identification is poor.It needs to safeguard
The deep study of personnel GoldenGate software and Oracle architecture, can just understand relevant information.Also, to shorten industry
It is engaged in impacted duration, when emergency switching, operation maintenance personnel pressure is huge, it is necessary to possess good psychological quality.
2), by Oracle GoldenGate software deployment in shared storage, and the queue file being drawn into also is buffered in
In shared storage, when production, is only run on each node at source and disaster tolerance end.As shown in Fig. 2, in this case, early period advises
When drawing deployment GoldenGate, need to prepare to share storage in advance for GoldenGate out, and GoldenGate is deployed in this
In shared storage.When 1 host of source end node or target end-host failure, maintenance personnel can start emergency on node 2
Link.Since queue file also is stored in shared storage, after starting emergency link, it is ensured that the normal fortune of disaster tolerance system
Row.
Have the following disadvantages: that 1, construction cost is high in this deployment situation.GoldenGate, must as disaster tolerance software
It must be deployed in safe and reliable storage system.And storage system is still costly at present, few then hundreds of thousands is how then millions of.2,
Resource utilization is low.Queue file's yield of GoldenGate only has a quarter of redo.Give GoldenGate software list
After being solely equipped with storage, the high-speed read-write ability of storage is not made full use of, the utilization rate of resource is reduced.
Summary of the invention
The technical problem to be solved in the present invention is to provide a kind of Oracle GoldenGate under unshared storage deployment
Implementation method records GoldenGate operating status using checkpoint table mechanism, reduces in emergency handoff procedure to maintenance people
The dependence of member, and the integrality and consistency of data on the target system after the switching that ensures to meet an urgent need.
The present invention exists the technical solution adopted is that providing a kind of Oracle GoldenGate to solve above-mentioned technical problem
Implementation method under unshared storage deployment, includes the following steps:
S1: respectively on first host at the standby end of the first host and calamity of source, GoldenGate software is disposed, and be arranged
Checkpoint table;
S2: on the second host of source, replicating the GoldenGate catalogue of the first host of source, the second of the standby end of calamity
On host, the GoldenGate catalogue of the first host of the standby end of duplication calamity;
S3: stop the disaster tolerance link between the first host of source and first host at the standby end of calamity, be switched to the second of source
Emergency link between host and second host at the standby end of calamity, starts duplicating process.
Further, the step S1 is specifically included: S11: being authorized to Oracle GoldenGate user, is changed data
Library addition supplement daily record data;S12: manager process is respectively created in source and the standby end of calamity;S13: it is drawn into source configuration
Journey and delivery process;S14: in the standby end configuration duplicating process of calamity;Checkpointing table.
It further, include more in the permission that source is authorized to Oracle GoldenGate user in the step S11
Change session, creation session, any list of flash back, selection list, open source, selection dictionary, selection data-base cluster, selection industry
Business and exemption access strategy;In calamity, standby to hold the permission authorized to Oracle GoldenGate user include change session, creation meeting
Words, open source, selection dictionary, selection list, insertion list, more new table and deletion list.
Further, in the step S12, creation manager process includes parameter definition, and the parameter of definition includes: logical
Believe port, dynamic port list, the parameter of self-starting attempts the time interval being restarted automatically and number after extracting process interrupt,
The periodic cleaning scratch file time cycle, the inspection period in propagation delay time, the period of transmission delay time-out write error log,
The period of transmission delay time-out write-in warning log.
It further, include defining extraction process document number and delivery process file number, the step in the step S13
It include defining duplicating process document number in S14.
Further, the step S3 is specifically included: S31: checkpoint table is inquired in the standby end arbitrary node of calamity, by searching for
Checkpoint table order, No. scn of confirmation duplicating process last operation;S32: switch GoldenGate on the second host of source and take out
It takes process file number and delivers process file number;S33: it No. scn according to obtained in step S31, is looked on the second host of source
Time corresponding to asking this No. scn, as fault time point;S34: failure starting point is arranged according to fault time point, from failure
Point starts the starting on the second host of source and extracts, delivers process;S35: the document number for process of delivering is checked in step S34;
S36: duplicating process start file number is modified, is opened on second host at the standby end of calamity according to the document number obtained in step S35
Dynamic duplicating process.
The present invention, which compares the prior art, to be had following the utility model has the advantages that Oracle GoldenGate provided by the invention is non-
Implementation method under shared storage deployment has the advantage that 1, checkpointing mechanism ensures data without loss.After handoff links,
The sequence of GoldenGate application copy operation is identical as the sequence in the system of source, and mentions according to identical transaction environment
It hands over, it is ensured that the integrality and read consistency of data on the target system.2, the transmission mechanism of data is reliable.GoldenGate is used
Acknowledgement mechanism transmits transaction data, just thinks that data are transmitted only after being confirmed message, otherwise will pass again automatically
Transmission of data, to ensure that all data extracted can be sent to backup end.3, hardware-dependent degree is greatly reduced.
GoldenGate software deployment is in local server, without using the shared storage of high-performance individually deployment.4, the dependency degree of people is big
Width reduces.The optimization and early warning that the time point index for the duplication that end starts is backed up when switching all rely on real data from technology
Angle is advised.Because having used checkpoint table, maintenance personnel can quickly position No. SCN, be not necessarily to mining analysis
GoldenGate queue file relies on also very big decline to the technical level of maintenance personnel.5, device is easy to use.Propose this
The switching flow after GoldenGate is disposed on ground, and by shirtsleeve operation, the switching of GoldenGate, operation letter can be completed
Single, the requirement to user of service is low.
Detailed description of the invention
Fig. 1 is the first deployment topologies figure of prior art Oracle GoldenGate;
Fig. 2 is second of deployment topologies figure of prior art Oracle GoldenGate;
Fig. 3 is the Oracle GoldenGate deployment topologies figure of the embodiment of the present invention;
Fig. 4 is implementation method flow chart of the Oracle GoldenGate of the present invention under unshared storage deployment;
Fig. 5 is the emergency switching flow figure of the embodiment of the present invention.
Specific embodiment
The invention will be further described with reference to the accompanying drawings and examples.
Fig. 3 is the Oracle GoldenGate deployment topologies figure of the embodiment of the present invention;Fig. 4 is the present invention
Implementation method flow chart of the OracleGoldenGate under unshared storage deployment.
Fig. 3 is referred to, Oracle GoldenGate of the invention is deployed in the local of first host at source and the standby end of calamity
On disk, disaster tolerance link is established between source and first host at the standby end of calamity;On second host at source and the standby end of calamity, respectively
The GoldenGate catalogue for copying the first host establishes emergency link between source and second host at the standby end of calamity.
Refer to Fig. 4, implementation method of the Oracle GoldenGate provided by the invention under unshared storage deployment,
Include the following steps:
S1: respectively on first host at the standby end of the first host and calamity of source, GoldenGate software is disposed, and be arranged
Checkpoint table;
S2: on the second host of source, replicating the GoldenGate catalogue of the first host of source, the second of the standby end of calamity
On host, the GoldenGate catalogue of the first host of the standby end of duplication calamity;
S3: stop the disaster tolerance link between the first host of source and first host at the standby end of calamity, be switched to the second of source
Emergency link between host and second host at the standby end of calamity, starts duplicating process.
Specifically, step S1 is specifically included: S11: authorizing to Oracle GoldenGate user, change database addition
Supplement daily record data;S12: manager process is respectively created in source and the standby end of calamity;S13: extraction process and throwing are configured in source
Progressive journey;S14: in the standby end configuration duplicating process of calamity;Checkpointing table.
Specifically, in step S11, the permission that source is authorized to Oracle GoldenGate user include change session,
It creates session, any list of flash back, selection list, open source, selection dictionary, selection data-base cluster, selection business and slits
Exempt from access strategy;In calamity, standby to hold the permission authorized to Oracle GoldenGate user include change session, creation session, is opened
It puts resource, selection dictionary, selection list, insertion list, more new table and deletes list.In step S12, creation manager into
Journey includes parameter definition, and the parameter of definition includes: communication port, dynamic port list, the parameter of self-starting, extraction process interrupt
The time interval being restarted automatically and number are attempted afterwards, the periodic cleaning scratch file time cycle checks the period in propagation delay time,
The period of transmission delay time-out write error log, the period of transmission delay time-out write-in warning log.It include fixed in step S13
Adopted extraction process document number and process file number is delivered, includes defining duplicating process document number in the step S14.
Refer to Fig. 5, implementation method of the Oracle GoldenGate provided by the invention under unshared storage deployment,
Step S3 is specifically included: S31: checkpoint table is inquired in the standby end arbitrary node of calamity, by searching for checkpoint table order, confirmation duplication
No. scn of process last operation;S32: on the second host of source switch GoldenGate extract process document number and deliver into
Journey document number;S33: No. scn according to obtained in step S31, when corresponding to inquiring this No. scn on the second host of source
Between, as fault time point;S34: failure starting point is arranged according to fault time point, in the second host of source since failure starting point
Upper starting is extracted, delivers process;S35: the document number for process of delivering is checked in step S34;S36: according to what is obtained in step S35
Document number modifies duplicating process start file number on second host at the standby end of calamity, starts duplicating process.
Implementation method of the Oracle GoldenGate provided by the invention under unshared storage deployment, in practical application
In, certain telecom operators' hard core control system uses apparatus of the present invention to carry out the deployment of GoldenGate software by the end of October,
The multiple switching of subsequent process is drilled.It makes arrangement front and back ratio from source and calamity for end data delay time and emergency switching time
Compared with: before deployment, using script, full dose from source to target side reinitializes data to operation maintenance personnel per hour, and the process is with number
Increasing according to measuring, the process time-consuming is increasingly longer, minimum at present to need complete within 15 minutes;After disposing GoldenGate, source
The changes of all data can update in 2-3 seconds to the standby end of calamity.Before deployment, operation maintenance personnel is conventionally met an urgent need
Switching needs 135 minutes, is shortened to 3 minutes using switching time of meeting an urgent need after the present invention.
In conclusion implementation method of the Oracle GoldenGate provided by the invention under unshared storage deployment, tool
Have the advantage that 1, checkpointing mechanism ensures data without loss;After handoff links, the sequence of GoldenGate application copy operation
It is identical as the sequence in the system of source, and submitted according to identical transaction environment, it is ensured that data is complete on the target system
Property and read consistency, created condition for real-time query and issued transaction;2, the transmission mechanism of data is reliable;GoldenGate makes
Transaction data is transmitted with acknowledgement mechanism, just thinks that data are transmitted only after being confirmed message, it otherwise will automatically again
Data are transmitted, to ensure that all data extracted can be sent to backup end;3, hardware-dependent degree is greatly reduced;
GoldenGate software deployment is in local server, without using the shared storage of high-performance individually deployment;4, the dependency degree of people is big
Width reduces;The optimization and early warning that the time point index for the duplication that end starts is backed up when switching all rely on real data from technology
Angle is advised, and not needing maintenance personnel has deep understanding to the architecture of GoldenGate and Oracle;Because making
With checkpoint table, maintenance personnel can quickly position No. SCN, mining analysis GoldenGate queue file is not necessarily to, to maintenance
The technical level dependence of personnel is also greatly reduced;5, device is easy to use;Switching after proposing local disposition GoldenGate
The switching of GoldenGate can be completed by shirtsleeve operation in process, and easy to operate, the requirement to user of service is low.
Although the present invention is disclosed as above with preferred embodiment, however, it is not to limit the invention, any this field skill
Art personnel, without departing from the spirit and scope of the present invention, when can make a little modification and perfect therefore of the invention protection model
It encloses to work as and subject to the definition of the claims.
Claims (6)
1. a kind of implementation method of Oracle GoldenGate under unshared storage deployment, which is characterized in that including walking as follows
It is rapid:
S1: respectively on first host at the standby end of the first host and calamity of source, dispose GoldenGate software, and inspection is set
Point table;
S2: on the second host of source, replicating the GoldenGate catalogue of the first host of source, the second host at the standby end of calamity
On, the GoldenGate catalogue of the first host of the standby end of duplication calamity;
S3: stop the disaster tolerance link between the first host of source and first host at the standby end of calamity, be switched to the second host of source
Emergency link between second host at the standby end of calamity, starts duplicating process.
2. implementation method of the Oracle GoldenGate as described in claim 1 under unshared storage deployment, feature exist
In the step S1 is specifically included:
S11: authorizing to Oracle GoldenGate user, change database addition supplement daily record data;
S12: manager process is respectively created in source and the standby end of calamity;
S13: in source configuration extraction process and process is delivered;
S14: in the standby end configuration duplicating process of calamity;Checkpointing table.
3. implementation method of the Oracle GoldenGate as claimed in claim 2 under unshared storage deployment, feature exist
In in the step S11, in the permission that source is authorized to Oracle GoldenGate user including changing session, creation meeting
It talks about, any list that flashes back, selection list, open source, selection dictionary, selection data-base cluster, selection business and exemption access
Strategy;Calamity it is standby hold the permission authorized to Oracle GoldenGate user include change session, creation session, open source,
It selects dictionary, selection list, insertion list, more new table and deletes list.
4. implementation method of the Oracle GoldenGate as claimed in claim 2 under unshared storage deployment, feature exist
In in the step S12, creation manager process includes parameter definition, and the parameter of definition includes: communication port, dynamic port
List, the parameter of self-starting attempt the time interval being restarted automatically and number, periodic cleaning scratch file after extracting process interrupt
Time cycle checks period in propagation delay time, the period of transmission delay time-out write error log, the write-in of transmission delay time-out
Alert the period of log.
5. implementation method of the Oracle GoldenGate as claimed in claim 2 under unshared storage deployment, feature exist
In including defining extraction process document number and delivering process file number in the step S13, including defining in the step S14
Duplicating process document number.
6. implementation method of the Oracle GoldenGate as described in claim 1 under unshared storage deployment, feature exist
In the step S3 is specifically included:
S31: the arbitrary node at the standby end of calamity inquires checkpoint table, by searching for checkpoint table order, confirms that duplicating process is last
No. scn of operation;
S32: switch GoldenGate on the second host of source and extract process document number and deliver process file number;
S33: No. scn according to obtained in step S31, this No. scn is inquired on the second host of source corresponding to the time, as
Fault time point;
S34: being arranged failure starting point according to fault time point, and starting is extracted, thrown on the second host of source since failure starting point
Progressive journey;
S35: the document number for process of delivering is checked in step S34;
S36: duplicating process start file is modified on second host at the standby end of calamity according to the document number obtained in step S35
Number, start duplicating process.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811442745.8A CN109522161A (en) | 2018-11-29 | 2018-11-29 | Implementation method of the Oracle GoldenGate under unshared storage deployment |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811442745.8A CN109522161A (en) | 2018-11-29 | 2018-11-29 | Implementation method of the Oracle GoldenGate under unshared storage deployment |
Publications (1)
Publication Number | Publication Date |
---|---|
CN109522161A true CN109522161A (en) | 2019-03-26 |
Family
ID=65794348
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811442745.8A Pending CN109522161A (en) | 2018-11-29 | 2018-11-29 | Implementation method of the Oracle GoldenGate under unshared storage deployment |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109522161A (en) |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101316184A (en) * | 2007-06-01 | 2008-12-03 | 华为技术有限公司 | Disaster tolerance switching method, system and device |
US8127174B1 (en) * | 2005-02-28 | 2012-02-28 | Symantec Operating Corporation | Method and apparatus for performing transparent in-memory checkpointing |
CN103853634A (en) * | 2014-02-26 | 2014-06-11 | 北京优炫软件股份有限公司 | Disaster recovery system and disaster recovery method |
CN105159793A (en) * | 2015-08-18 | 2015-12-16 | 上海新炬网络信息技术有限公司 | Data replication backup method based on GoldenGate |
-
2018
- 2018-11-29 CN CN201811442745.8A patent/CN109522161A/en active Pending
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US8127174B1 (en) * | 2005-02-28 | 2012-02-28 | Symantec Operating Corporation | Method and apparatus for performing transparent in-memory checkpointing |
CN101316184A (en) * | 2007-06-01 | 2008-12-03 | 华为技术有限公司 | Disaster tolerance switching method, system and device |
CN103853634A (en) * | 2014-02-26 | 2014-06-11 | 北京优炫软件股份有限公司 | Disaster recovery system and disaster recovery method |
CN105159793A (en) * | 2015-08-18 | 2015-12-16 | 上海新炬网络信息技术有限公司 | Data replication backup method based on GoldenGate |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN106776121B (en) | Data disaster recovery device, system and method | |
US10795911B2 (en) | Apparatus and method for replicating changed-data in source database management system to target database management system in real time | |
CN100449548C (en) | Method and system for synchronizing data base | |
US7421549B2 (en) | Method and apparatus of remote copy for multiple storage subsystems | |
DE69502651T2 (en) | Asynchronous remote data duplication | |
CN105159793B (en) | Data duplication backup method based on GoldenGate | |
US7428657B2 (en) | Method for rolling back from snapshot with log | |
CN103853837B (en) | Oracle does not stop the table level back-up restoring method of Production database automatically | |
US10565071B2 (en) | Smart data replication recoverer | |
CN106815097A (en) | Database disaster tolerance system and method | |
CN103345470A (en) | Database disaster tolerance method, database disaster tolerance system and server | |
CN110990200B (en) | Flow switching method and device based on multiple active data centers | |
CN103455557B (en) | A kind of structural data synchronous method based on daily record | |
CN105069160A (en) | Autonomous controllable database based high-availability method and architecture | |
CN106528341A (en) | Automatic disaster-tolerant system based on Greenplum database | |
CN108762982B (en) | A kind of database restoring method, apparatus and system | |
CN108964986A (en) | Cooperative office system application layer dual-active disaster recovery and backup systems | |
EP4060514A1 (en) | Distributed database system and data disaster backup drilling method | |
Zhu et al. | IT disaster tolerance and application classification for data centers | |
CN112631831A (en) | Bare computer recovery method and system of service system | |
CN101527656B (en) | Emergency switched system of NGN service platform database and realizing method thereof | |
CN101499924B (en) | On-line switchover method for computer production system | |
CN113114777B (en) | Disaster recovery method and device for multi-node high-availability cluster | |
CN106445746A (en) | Method and device for disaster recovery backup facing emergency replacement | |
CN109522161A (en) | Implementation method of the Oracle GoldenGate under unshared storage deployment |
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 | ||
WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20190326 |
|
WD01 | Invention patent application deemed withdrawn after publication |