検索
ホームページデータベースmysql チュートリアルOracle GoldenGate extract进程的工作方式

oracle goldengate先从online log日志抽取数据,然后才会从archived log中进行抽取,这可以通过下面的方式来验证.

Oracle goldengate先从online log日志抽取数据,然后才会从archived log中进行抽取,这可以通过下面的方式来验证.

1、主库端插入测试数据
SQL> insert into gg1.dept values(81,'1','1');

1 row created.

SQL> commit;

Commit complete.

SQL> alter system switch logfile;

System altered.

SQL> insert into gg1.dept values(82,'2','2');

1 row created.

SQL> commit;

Commit complete.

SQL> insert into gg1.dept values(83,'3','3');

1 row created.

SQL> commit;

Commit complete.

SQL> alter system switch logfile;

System altered.

SQL> insert into gg1.dept values(84,'4','4');

1 row created.

SQL> commit;

Commit complete.

在这里多次执行alter system switch logfile;

这里比较关键,在后面我们会删除, 82、83对应的归档日志, 如果没有覆盖掉82、83对应的online log,goldengate的extract进程不会异常中止,extract进程会优选online log。

2、在这里我们覆盖掉online log,然后删除82、83对应的归档日志。

3、查看goldengate状态,,extract进程异常中止
GGSCI (slav2) 1> info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING D1PUMP 00:00:00 00:00:02
EXTRACT ABENDED EXT1 00:03:10 00:02:29

GGSCI (slav2) 2> info ext1

EXTRACT EXT1 Last Started 2013-01-21 22:15 Status ABENDED
Checkpoint Lag 00:03:10 (updated 00:02:33 ago)
Log Read Checkpoint Oracle Redo Logs
2013-01-21 22:11:50 Seqno 28, RBA 67584

[oracle@slav2 ggs]$ vi ggserr.log
2013-01-21 22:14:59 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT1 starting.
2013-01-21 22:14:59 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 starting.
2013-01-21 22:15:00 WARNING OGG-01423 Oracle GoldenGate Capture for Oracle, ext1.prm: No valid default archive log destination directory found for thread 1.
2013-01-21 22:15:00 INFO OGG-01513 Oracle GoldenGate Capture for Oracle, ext1.prm: Positioning to Sequence 28, RBA 67088.
2013-01-21 22:15:00 INFO OGG-01516 Oracle GoldenGate Capture for Oracle, ext1.prm: Positioned to Sequence 28, RBA 67088, Jan 21, 2013 10:11:50 PM.
2013-01-21 22:15:00 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 started.
2013-01-21 22:15:00 INFO OGG-01055 Oracle GoldenGate Capture for Oracle, ext1.prm: Recovery initialization completed for target file /u01/app/ggs/dirdat/lt000004, at RBA 1672.
2013-01-21 22:15:00 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, ext1.prm: Output file /u01/app/ggs/dirdat/lt is using format RELEASE 10.4/11.1.
2013-01-21 22:15:00 INFO OGG-01026 Oracle GoldenGate Capture for Oracle, ext1.prm: Rolling over remote file /u01/app/ggs/dirdat/lt000004.
2013-01-21 22:15:00 INFO OGG-01053 Oracle GoldenGate Capture for Oracle, ext1.prm: Recovery completed for target file /u01/app/ggs/dirdat/lt000005, at RBA 968.
2013-01-21 22:15:00 INFO OGG-01057 Oracle GoldenGate Capture for Oracle, ext1.prm: Recovery completed for all targets.
2013-01-21 22:15:00 INFO OGG-01517 Oracle GoldenGate Capture for Oracle, ext1.prm: Position of first record processed Sequence 28, RBA 67088, SCN 0.610617, Jan 21, 2013 10:11:50 PM.

linux

声明
この記事の内容はネチズンが自主的に寄稿したものであり、著作権は原著者に帰属します。このサイトは、それに相当する法的責任を負いません。盗作または侵害の疑いのあるコンテンツを見つけた場合は、admin@php.cn までご連絡ください。
如何使用PHP中的extract函数将数组键值赋值给变量如何使用PHP中的extract函数将数组键值赋值给变量Jun 26, 2023 pm 03:44 PM

extract函数是PHP中一个非常实用的函数,它可以将一个数组中的键值对赋值给一组变量。采用这种方式,我们可以简化代码,并且提供更直观的变量名称,方便维护和调试。本文将介绍如何使用PHP中的extract函数将数组键值赋值给变量。一、extract函数的语法extract函数的语法非常简单,如下所示:extract(array$array,int$f

Jim Rickards: Treasury Should Buy Gold to Avoid Dollar Substitution by New Forms of Money Like CryptoJim Rickards: Treasury Should Buy Gold to Avoid Dollar Substitution by New Forms of Money Like CryptoOct 08, 2024 am 09:44 AM

The longevity and staying power of the U.S. dollar is starting to worry economists in a high-debt, high issuance scenario.

Fujifilm Instax Mini Evo hybrid instant camera launches as 90th Anniversary Limited EditionFujifilm Instax Mini Evo hybrid instant camera launches as 90th Anniversary Limited EditionAug 15, 2024 pm 12:02 PM

Fujifilm was founded in Tokyo on January 20, 1934, which is why the company is currently celebrating its 90th anniversary. As part of celebrations, Fujifilm is presenting a limited 90th Anniversary Edition of the Instax Mini Evo, which is available i

Gold Prices Surge 3% Nearing All-Time High as Bitcoin (BTC) Struggles to Maintain MomentumGold Prices Surge 3% Nearing All-Time High as Bitcoin (BTC) Struggles to Maintain MomentumAug 06, 2024 am 03:29 AM

Gold prices increased by over 3% this week, nearing their all-time high, as investors seek safe-haven assets amid geopolitical unrest

Bitcoin vs. Gold: Which is the ‘better money’?Bitcoin vs. Gold: Which is the ‘better money’?Sep 09, 2024 pm 03:22 PM

Strike’s Jack Mallers defended Bitcoin [BTC] in a recent debate with Peter Schiff, one of the top crypto critics. There’s been a long-standing argument

Tether Gold是什么?黄金代币XAUt交易、原理、优势、风险全解Tether Gold是什么?黄金代币XAUt交易、原理、优势、风险全解Jun 25, 2024 pm 07:03 PM

稳定币龙头USDT发行商Tether在2024年6月17日正式推出了其「AlloybyTether」平台,首项产品允许用户将Tether旗下的黄金代币TetherGold(XAUt)作为抵押品,铸造新的合成美元稳定币aUSDT,在不到一天的时间里,就达到了802万美元的市场规模,引发市场关注。本文全面整理了在这一过程中作为抵押品的TetherGold(XAUt)发行与赎回方式、优点与风险等方面,以利读者了解这一独特资产。TetherGold(XAUt)是什么?XAUt是一种由黄金支持的稳定币,与

Bitcoin vs Gold: Which Is the Better Safe Haven Asset?Bitcoin vs Gold: Which Is the Better Safe Haven Asset?Aug 17, 2024 pm 09:02 PM

Gold consistently reduces portfolio volatility while improving returns, even with increased allocation. By simulating portfolio performance with varying allocations of gold (2.5% to 10%), it's evident that the metal bolsters returns without adding si

Bitcoin (BTC) Outperformed by Traditional Assets Gold and the Japanese Yen in Q3 of 2024Bitcoin (BTC) Outperformed by Traditional Assets Gold and the Japanese Yen in Q3 of 2024Oct 21, 2024 am 10:08 AM

According to a report by Coingecko, Bitcoin (BTC) saw a modest price increase of just 0.8%, whereas Gold emerged as the biggest winner

See all articles

ホットAIツール

Undresser.AI Undress

Undresser.AI Undress

リアルなヌード写真を作成する AI 搭載アプリ

AI Clothes Remover

AI Clothes Remover

写真から衣服を削除するオンライン AI ツール。

Undress AI Tool

Undress AI Tool

脱衣画像を無料で

Clothoff.io

Clothoff.io

AI衣類リムーバー

AI Hentai Generator

AI Hentai Generator

AIヘンタイを無料で生成します。

ホットツール

MantisBT

MantisBT

Mantis は、製品の欠陥追跡を支援するために設計された、導入が簡単な Web ベースの欠陥追跡ツールです。 PHP、MySQL、Web サーバーが必要です。デモおよびホスティング サービスをチェックしてください。

DVWA

DVWA

Damn Vulnerable Web App (DVWA) は、非常に脆弱な PHP/MySQL Web アプリケーションです。その主な目的は、セキュリティ専門家が法的環境でスキルとツールをテストするのに役立ち、Web 開発者が Web アプリケーションを保護するプロセスをより深く理解できるようにし、教師/生徒が教室環境で Web アプリケーションを教え/学習できるようにすることです。安全。 DVWA の目標は、シンプルでわかりやすいインターフェイスを通じて、さまざまな難易度で最も一般的な Web 脆弱性のいくつかを実践することです。このソフトウェアは、

SublimeText3 英語版

SublimeText3 英語版

推奨: Win バージョン、コードプロンプトをサポート!

SAP NetWeaver Server Adapter for Eclipse

SAP NetWeaver Server Adapter for Eclipse

Eclipse を SAP NetWeaver アプリケーション サーバーと統合します。

Dreamweaver Mac版

Dreamweaver Mac版

ビジュアル Web 開発ツール