CN109522161A - Implementation method of the Oracle GoldenGate under unshared storage deployment - Google Patents

Implementation method of the Oracle GoldenGate under unshared storage deployment Download PDF

Info

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
Application number
CN201811442745.8A
Other languages
Chinese (zh)
Inventor
程永新
孙玉颖
杨光
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
SHANGHAI NEW CENTURY NETWORK Co Ltd
Original Assignee
SHANGHAI NEW CENTURY NETWORK Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by SHANGHAI NEW CENTURY NETWORK Co Ltd filed Critical SHANGHAI NEW CENTURY NETWORK Co Ltd
Priority to CN201811442745.8A priority Critical patent/CN109522161A/en
Publication of CN109522161A publication Critical patent/CN109522161A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14Error detection or correction of the data by redundancy in operation
    • G06F11/1402Saving, restoring, recovering or retrying
    • G06F11/1446Point-in-time backing up or restoration of persistent data
    • G06F11/1458Management of the backup or restore process
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F2201/00Indexing scheme relating to error detection, to error correction, and to monitoring
    • G06F2201/80Database-specific techniques
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F2201/00Indexing scheme relating to error detection, to error correction, and to monitoring
    • G06F2201/82Solving 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

Implementation method of the Oracle GoldenGate under unshared storage deployment
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.
CN201811442745.8A 2018-11-29 2018-11-29 Implementation method of the Oracle GoldenGate under unshared storage deployment Pending CN109522161A (en)

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)

* Cited by examiner, † Cited by third party
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

Patent Citations (4)

* Cited by examiner, † Cited by third party
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