Shulou(Shulou.com)06/01 Report--

Oracle DataGuardOracle GoldenGate principle replicates archived logs or online logs extract data changes in online logs, converts them to GGS custom data formats and stores them in local queues or remote queues. The stability of disaster recovery is not as high as DataGuard maintenance, and there are few problems on the command line. The maintenance of more complex objects fully supports some objects that need to be manually created to maintain the availability of the backup side and the backup side is in a restore or read-only state, and cannot be restored at the same time in a read-only state. The database at both ends is active, and the backup side can provide real-time data query and report services, so as to improve the overall business processing capacity of the system, make full use of the computing power of the backup side, and improve the overall business processing performance of the system. Can achieve both ends of the data at the same time write takeover time database work in the mount state, take over business, the database to open can immediately take over the replication mode through the recovery mechanism, can not achieve synchronous replication GoldenGate can provide a second level of real-time data capture and delivery, asynchronous replication mode, can not achieve synchronous replication resources occupation replication through the database LGWR process or ARCN process Occupy a small amount of database resources during peak business consumption of system resources during data extraction conversion, low peak consumption of smaller heterogeneous databases support a single database solution, only run on Oracle databases, the source and target operating systems must be the same, version numbers can be different and data can be replicated between different types and versions of databases. Such as ORACLE,DB2,SYBASE,SQL SERVER,INFORMIX, Teradata and so on.

Suitable for different operating systems such as windows, linux, unix, aix, etc., using Oracle Net to transmit logs, it can be compressed through advanced compression options, and the compression ratio is 2-3 times using TCP/IP to transmit data changes, integrated data compression, provide theoretical data compression characteristics that can reach 9:1 compression ratio, topology structure can achieve one-to-one mode, one-to-many mode, many-to-one, two-way replication and other topologies.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.