怎么理解Oracle數(shù)據(jù)庫的單向復(fù)制

這篇文章主要講解了“怎么理解Oracle數(shù)據(jù)庫的單向復(fù)制”，文中的講解內(nèi)容簡單清晰，易于學(xué)習(xí)與理解，下面請大家跟著小編的思路慢慢深入，一起來研究和學(xué)習(xí)“怎么理解Oracle數(shù)據(jù)庫的單向復(fù)制”吧！

1.       環(huán)境需求：

兩臺裝有Oracle軟件的虛擬機(jī)服務(wù)器，并配置好監(jiān)聽及安裝好數(shù)據(jù)庫

2.       配置準(zhǔn)備

2.1   創(chuàng)建操作系統(tǒng)用戶

useradd ogg -g oinstall

新建安裝目錄

[root@ogg1 ~]# mkdir -p /u01/ogg

[root@ogg1 ~]# chown -R ogg.oinstall /u01/ogg

[root@ogg1 ~]# chmod 775 /u01/ogg/

2.2   設(shè)置用戶的環(huán)境變量，尤其要給它指定lib庫的位置以及ggsci位置：

export PATH

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1

export GG_HOME=/u01/ogg

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

export PATH=$GG_HOME:$PATH

2.3正式安裝

[root@ogg1 soft]# unzip 122022_fbo_ggs_Linux_x64_shiphome.zip

[ogg@ogg1 ~]$ cd /u01/soft/fbo_ggs_Linux_x64_shiphome/Disk1/

[ogg@ogg1 Disk1]$ ./runInstaller

                   安裝步驟略，將安裝目錄設(shè)置為/u01/ogg

3.       復(fù)制準(zhǔn)備：實(shí)現(xiàn)單表復(fù)制

檢查相關(guān)參數(shù)是否開啟

Select LOG_MODE , FORCE_LOGGING, SUPPLEMENTAL_LOG_DATA_min from v$database;

3.1   開啟參數(shù)（需開啟歸檔模式和強(qiáng)制歸檔）

SQL> show parameter golde

NAME                                          TYPE        VALUE

------------------------------------ ----------- ------------------------------

enable_goldengate_replication              boolean  FALSE

SQL> alter system set enable_goldengate_replication=true;

SQL> select SUPPLEMENTAL_LOG_DATA_min from v$database;

SUPPLEME

--------

NO

SQL> alter database add supplemental log data;

Database altered.

SQL> select SUPPLEMENTAL_LOG_DATA_min from v$database;

SUPPLEME

--------

YES

SQL> alter system archive log current;

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area  830930944 bytes

Fixed Size                 2257800 bytes

Variable Size                  536874104 bytes

Database Buffers         289406976 bytes

Redo Buffers                    2392064 bytes

Database mounted.

SQL> alter database force logging;

Database altered.

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

System altered.

源端和目標(biāo)端分別設(shè)置

源端：create user ogg_source identified by oracle default tablespace users;
grant alter session to ogg_source;
grant create session to ogg_source;
grant connect to ogg_source;
grant resource to ogg_source;
grant select any dictionary to ogg_source;
grant select any table to ogg_source;
grant flashback any table to ogg_source;
grant alter any table to ogg_source;

目標(biāo)：create user ogg_target identified by oracle default tablespace users;
grant alter session to ogg_target;
grant create session to ogg_target;
grant connect to ogg_target;
grant resource to ogg_target;
grant select any dictionary to ogg_target;
grant select any table to ogg_target;
grant flashback any table to ogg_target;
grant alter any table to ogg_target;
grant insert any table to ogg_target;
grant update any table to ogg_target;
grant delete any table to ogg_target;

3.2   Ogg配置

問題解決：無法登陸，是oracle_sid設(shè)置問題

GGSCI (ogg1) 5> dblogin userid ogg_source ,password oracle

ERROR: Unable to connect to database using user ogg_source. Please check privileges.

Unable to initialize database connection because of error ORA-12162: TNS:net service name is incorrectly specified.

GGSCI (ogg1) 6> exit

[ogg@ogg1 ~]$ export ORACLE_SID=ogg

[ogg@ogg1 ~]$ /u01/ogg/ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 12.2.0.2.2 OGGCORE_12.2.0.2.0_PLATFORMS_170630.0419_FBO

Linux, x64, 64bit (optimized), Oracle 11g on Jun 30 2017 14:42:26

Operating system character set identified as UTF-8.

Copyright (C) 1995, 2017, Oracle and/or its affiliates. All rights reserved.

GGSCI (ogg1) 1> dblogin userid ogg_source ,password oracle

Successfully logged into database.

1.       配置需要抽取的表或者用戶

Add trandata luc.*

2.       配置全局參數(shù)

./GLOBALS 必須大寫

事務(wù)配置及檢查點(diǎn)表

3.       配置MGR進(jìn)程

Edit params mgr

>port 7809

4.       配置Extract腳本

配置參數(shù)，使用本地的方式。

Edit params EXT_1

EXTRACT EXT_1
USERID ogg_source, PASSWORD oracle
EXTTRAIL /home/oracle/ogg/ogg_work/dirdat/ss
TABLE N1.*;

添加抽取進(jìn)程，從數(shù)據(jù)庫日志中抓取數(shù)據(jù)。

>  ADD EXTRACT EXT_1, TRANLOG, BEGIN NOW

EXTRACT added.

配置本地隊(duì)列,然后啟動

> ADD EXTTRAIL /home/oracle/ogg/ogg_work/dirdat/ss, EXTRACT EXT_1

> start EXT_1

Sending START request to MANAGER ...

EXTRACT EXT_1 starting

配置完成之后，就可以查看是否能夠正常抽取了，可以看到是沒有正常啟動。狀態(tài)現(xiàn)在還是STOPPED

> info EXT_1

EXTRACT    EXT_1     Initialized   2016-11-11 16:16   Status STOPPED

Checkpoint Lag       00:00:00 (updated 00:01:22 ago)

Log Read Checkpoint  Oracle Redo Logs

                     2016-11-11 16:16:04  Seqno 0, RBA 0

5.       配置Pump腳本

>  edit params dpump_1

EXTRACT dpump_1

PASSTHRU

RMTHOST 10.127.2.32, MGRPORT 1530

RMTTRAIL  /home/oracle/ogg/ogg_work/dirdat/ss

TABLE n1.*;

> ADD EXTRACT dpump_1,EXTTRAILSOURCE /home/oracle/ogg/ogg_work/dirdat/ss

EXTRACT added.

> ADD RMTTRAIL /home/oracle/ogg/ogg_work/dirdat/ss, EXTRACT dpump_1

RMTTRAIL added.

配置完成之后，啟動PUMP進(jìn)程。

> start dpump_1

Sending START request to MANAGER ...

EXTRACT DPUMP_1 starting查看DUMP進(jìn)程的信息如下：

> info dpump_1

EXTRACT    DPUMP_1   Last Started 2016-11-11 16:24   Status RUNNING

Checkpoint Lag       00:00:00 (updated 00:00:04 ago)

Process ID           53479

Log Read Checkpoint  File /home/oracle/ogg/ogg_work/dirdat/ss000000000

                     First Record  RBA 0

6.       配置Application腳本

配置投遞隊(duì)列參數(shù)，將數(shù)據(jù)應(yīng)用到目標(biāo)庫，這里有個映射關(guān)系，就是源庫的n1.*和目標(biāo)庫的n1.*是對應(yīng)的。

> edit params rep_1

REPLICAT REP_1

USERID ogg_target, PASSWORD oracle

ASSUMETARGETDEFS

HANDLECOLLISIONS

MAP n1.*,TARGET n1.*; 添加投遞隊(duì)列

> ADD REPLICAT REP_1, EXTTRAIL /home/oracle/ogg/ogg_work/dirdat/ss,CHECKPOINTTABLE ogg_target.CHKPTAB

REPLICAT added.

> start REP_1

Sending START request to MANAGER ...

REPLICAT REP_1 starting

啟動成功后的狀態(tài)是這樣的。

> INFO REP_1

REPLICAT   REP_1     Last Started 2016-11-11 17:02   Status RUNNING

Checkpoint Lag       00:00:00 (updated 00:00:02 ago)

Process ID           69571

Log Read Checkpoint  File /home/oracle/ogg/ogg_work/dirdat/ss000000000

                     First Record  RBA 0

報錯執(zhí)行：

BEGIN

     DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE(

     grantee => 'ogg_target',

    grant_privileges => true);

     END;

     /

循環(huán)插入1-100

begin
for i in 1 .. 100 loop
    insert into  luc.test values (i,’uuu’);
    end loop;

end;

/

插入大量數(shù)據(jù)測試是否同步：

insert into luc.test select level,level||’obj’ from dual connect by level<500000;

感謝各位的閱讀，以上就是“怎么理解Oracle數(shù)據(jù)庫的單向復(fù)制”的內(nèi)容了，經(jīng)過本文的學(xué)習(xí)后，相信大家對怎么理解Oracle數(shù)據(jù)庫的單向復(fù)制這一問題有了更深刻的體會，具體使用情況還需要大家實(shí)踐驗(yàn)證。這里是億速云，小編將為大家推送更多相關(guān)知識點(diǎn)的文章，歡迎關(guān)注！