'태그를 입력해 주세요.'에 해당되는 글 3건

2015.12.24 Adding MySQL Cluster Data Nodes Online
2015.10.07 Source 비교 S/W: Beyond Compare 활용
2013.04.08 Oracle Golden Gate Configuration(단방향 DDL,DML)

Adding MySQL Cluster Data Nodes Online

1. IT Story/DB 2015. 12. 24. 11:30

Adding MySQL Cluster Data Nodes Online

MySQL 클러스터 온라인 데이터 노드 추가가 가능하도록 지원을 시작하고 있다.
MySQL Cluster Data Nodes Online 추가가 가능한 버전은 MySQL Cluster NDB 6.4.0 (This capability is available in MySQL Cluster NDB 7.0 (beginning with MySQL Cluster NDB 6.4.0) and later MySQL Cluster release series.) 이상부터 가능한 것으로 확인되며 공식문서를 참고하여 문서를 정리하였습니다.

Step 1: Update configuration file.

the cluster uses a config.ini file

[ndbd default]

…..

[ndbd]

….

Id = 7

HostName = *.*.*.4 (TEST IP)

datadir=/usr/local/mysql-cluster/ndbd-data

ArbitrationRank=3

Id = 8

HostName = *.*.*.5 (TEST IP)

datadir=/usr/local/mysql-cluster/ndbd-data

ArbitrationRank=4

Step 2: Restart the management server

1) Stop the management server using the management client STOP command, as shown here:

ndb_mgm> 10 STOP

Node 10 has shut down.

Disconnecting to allow Management Server to shutdown

shell>

2) Because shutting down the management server causes the management client to terminate, you must start the management server from the system shell.

shell> ndb_mgmd -f config.ini --reload

2008-12-08 17:29:23 [MgmSrvr] INFO -- NDB Cluster Management Server. 5.1.73-ndb-7.1.36

2008-12-08 17:29:23 [MgmSrvr] INFO -- Reading cluster configuration from 'config.ini'

3) status check

ndb_mgm> show

Cluster Configuration

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

[ndbd(NDB)] 2 node(s)

id=3 @*.*.*.1 (mysql-5.1.34 ndb-6.3.25, Nodegroup: 0)

id=4 @*.*.*.2 (mysql-5.1.34 ndb-6.3.25, Nodegroup: 0, Master)

id=7 (not connected, accepting connect from 10.0.0.4)

id=8 (not connected, accepting connect from 10.0.0.5)

[ndb_mgmd(MGM)] 1 node(s)

id=1 @*.*.*.3 (mysql-5.1.34 ndb-6.3.25)

[mysqld(API)] 2 node(s)

id=5 @*.*.*.1 (mysql-5.1.34 ndb-6.3.25)

id=6 @*.*.*.2 (mysql-5.1.34 ndb-6.3.25)

Step 3: Perform a rolling restart of the existing data nodes.

ndb_mgm> 1 RESTART

Node 1: Node shutdown initiated

Node 1: Node shutdown completed, restarting, no start.

Node 1 is being restarted

ndb_mgm> Node 1: Start initiated (version 7.1.36)

Node 1: Started (version 7.1.36)

ndb_mgm> 2 RESTART

Node 2: Node shutdown initiated

Node 2: Node shutdown completed, restarting, no start.

Node 2 is being restarted

ndb_mgm> Node 2: Start initiated (version 7.1.36)

ndb_mgm> Node 2: Started (version 7.1.36)

Step 4: Perform a rolling restart of all cluster API nodes.

shell> mysqladmin -uroot -ppassword shutdown

081208 20:19:56 mysqld_safe mysqld from pid file

/usr/local/mysql/var/tonfisk.pid ended

shell> mysqld_safe --ndbcluster --ndb-connectstring=*.*.*.3 &

081208 20:20:06 mysqld_safe Logging to '/usr/local/mysql/var/tonfisk.err'.

081208 20:20:06 mysqld_safe Starting mysqld daemon with databases

from /usr/local/mysql/var

Step 5: Perform an initial start of the new data nodes.

shell> ndbd -c 10.0.0.3 --initial

ndb_mgm> show

Cluster Configuration

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

[ndbd(NDB)] 2 node(s)

id=3 @*.*.*.1 (mysql-5.1.34 ndb-6.3.25, Nodegroup: 0)

id=4 @*.*.*.2 (mysql-5.1.34 ndb-6.3.25, Nodegroup: 0, Master)

id=7 @*.*.*.7 (mysql-5.1.34 ndb-6.3.25, no nodegroup)

id=8 @*.*.*.8 (mysql-5.1.34 ndb-6.3.25, no nodegroup)

[ndb_mgmd(MGM)] 1 node(s)

id=1 @*.*.*.3 (mysql-5.1.34 ndb-6.3.25)

[mysqld(API)] 2 node(s)

id=5 @*.*.*.1 (mysql-5.1.34 ndb-6.3.25)

id=6 @*.*.*.2 (mysql-5.1.34 ndb-6.3.25)

Step 6: Create a new node group

ndb_mgm> CREATE NODEGROUP 7,8

Nodegroup 1 created

ndb_mgm> show

Cluster Configuration

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

[ndbd(NDB)] 2 node(s)

id=3 @*.*.*.1 (mysql-5.1.34 ndb-6.3.25, Nodegroup: 0)

id=4 @*.*.*.2 (mysql-5.1.34 ndb-6.3.25, Nodegroup: 0, Master)

id=7 @*.*.*.7 (mysql-5.1.34 ndb-6.3.25, 1)

id=8 @*.*.*.8 (mysql-5.1.34 ndb-6.3.25, 1)

[ndb_mgmd(MGM)] 1 node(s)

id=1 @*.*.*.3 (mysql-5.1.34 ndb-6.3.25)

[mysqld(API)] 2 node(s)

id=5 @*.*.*.1 (mysql-5.1.34 ndb-6.3.25)

id=6 @*.*.*.2 (mysql-5.1.34 ndb-6.3.25)

Step 7: Redistribute cluster data.

ndb_mgm> all report mem

Node 2: Data usage is 5%(176 32K pages of total 3200)

Node 2: Index usage is 0%(76 8K pages of total 12832)

Node 3: Data usage is 5%(176 32K pages of total 3200)

Node 3: Index usage is 0%(76 8K pages of total 12832)

Node 7: Data usage is 0%(0 32K pages of total 192000)

Node 7: Index usage is 0%(0 8K pages of total 192032)

Node 8: Data usage is 0%(0 32K pages of total 192000)

Node 8: Index usage is 0%(0 8K pages of total 192032)

shell> ndb_desc -c *.*.*.3 -d n ips -p

- ips --

Version: 1

Fragment type: 9

K Value: 6

Min load factor: 78

Max load factor: 80

...

-- Per partition info --

Partition Row count Commit count Frag fixed memory Frag varsized memory

0 26086 26086 1572864 557056

1 26329 26329 1605632 557056

1) Table Redistribute

- 대상 테이블명 확인

SELECT TABLE_SCHEMA, TABLE_NAME

FROM INFORMATION_SCHEMA.TABLES

WHERE ENGINE = 'NDBCLUSTER';

- 테이블 복제

mysql> ALTER ONLINE TABLE [DB명].[테이블명] REORGANIZE PARTITION;

- Redistribute 확인

shell> ndb_desc -d [DB명] [테이블명] -c *.*.*.3:port -pn

shell> ndb_desc -c *.*.*.10 -d n ips -p

-- ips --

Version: 16777217

Fragment type: 9

K Value: 6

Min load factor: 78

Max load factor: 80

…

-- Per partition info --

Partition Row count Commit count Frag fixed memory Frag varsized memory

0 12981 52296 1572864 557056

1 13236 52515 1605632 557056

2 13105 13105 819200 294912

3 13093 13093 819200 294912

ndb_mgm> all report mem

Node 2: Data usage is 5%(176 32K pages of total 3200)

Node 2: Index usage is 0%(76 8K pages of total 12832)

Node 3: Data usage is 5%(176 32K pages of total 3200)

Node 3: Index usage is 0%(76 8K pages of total 12832)

Node 7: Data usage is 2%(80 32K pages of total 3200)

Node 7: Index usage is 0%(51 8K pages of total 12832)

Node 8: Data usage is 2%(80 32K pages of total 3200)

Node 8: Index usage is 0%(50 8K pages of total 12832)

[참고 사이트]

원본 위치 <https://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-online-add-node.html>

'1. IT Story > DB' 카테고리의 다른 글

Oracle MySQL 운영관리 Q&A 정리(2020) (0)	2020.12.24
Oracle 11G RAC Engine,OCR,VOTE Backup/Recovery(백업/복구) (0)	2020.12.24
대량 데이터 변경 세션 KILL 수행 후, ROLLBACK 모니터링 방법 (0)	2020.12.24
Oracle Database Appliance(X5-2) Disk Online replacement (0)	2015.12.30
MySQL Monitor Tool Install (0)	2015.12.24
Oracle 서비스지원(SR) 신청 방법 (0)	2015.10.07
IBM SPSS Statistics 22 Installation on Windows7 32bit (0)	2015.10.06
MYSQL: InnoDB Storage Architecture (0)	2015.10.02

운명을바꾸는자

IT와 함께 살아가는 삶

Source 비교 S/W: Beyond Compare 활용

2. Knowledge 2015. 10. 7. 17:36

Source 비교 S/W: Beyond Compare 활용

IT 업종에서 개발 및 SQL Source가 많아지게 되는데 각 Source의 비교를 통하여 데이터를 찾거나 수정하고 정리할 경우에 유용하게 사용할 수 있다.

1. beyond Compare

http://software.naver.com/software/summary.nhn?softwareId=MFS_100881

네이버에서 검색을 통하여 손 쉽게 해당 SW를 다운 받을 수 있다.

2. beyond Compare 주요 기능

Folder Compare, Text Compare, Data Compare 등등 다양한 형태로 데이터를 비교해주는 기능을 가지고 있다.

① Folder Compare

Folder Tree를 비교하여 중복되는 내역이 없는지 확인하여 백업 시에 불피룡한 Folder 및 파일을 비교하여 정리할 수 있다.

② Text Compare

주로 많이 사용하는 기능으로는 Text Compare로 2개의 문서의 내용을 비교하여 다른 부분을 찾아 빨간색으로 표기해 준다.
같은 데이터만 보기
다른 데이터만 보기
왼쪽 데이터를 기준으로 오른쪽 데이터를 변경하여 동일하게 맞추어 주는 기능

'2. Knowledge' 카테고리의 다른 글

2019 자동차세 연납신청 (1월 연납시 10%할인) (0)	2019.01.17
연봉탐색기 (연봉만 입력하면 연봉순위와 각종 고급정보가 한눈에) (0)	2019.01.12
크롬을 활용하여 막혀있는 글, 그림 드래그 & 복사하기 (1)	2019.01.03
정보관리/응용 기술사, 정보시스템 감리사 준비 (0)	2015.11.05
직장인 영어 공부 습관 들이기 (0)	2015.08.12
직장인 대학원(야간, 특수대학원)에 대한 이야기 (0)	2015.08.06
부천에서 에버랜드&케리비안베이 대중교통 (2)	2015.08.03
EditPlus Macro 활용 (0)	2015.07.30

운명을바꾸는자

IT와 함께 살아가는 삶

Oracle Golden Gate Configuration(단방향 DDL,DML)

1. IT Story/DB 2013. 4. 8. 23:30

1.OGG Configuration(단방향 DDL,DML)

1-1 Create and start Manager

OGG MGR 포트 및 Trail파일 설정(Source)

GGSCI (ocp.mycorpdomain.com) 2> dblogin userid oggmgr, password oracle

Successfully logged into database.

GGSCI (ocp.mycorpdomain.com) 3> edit params mgr

PORT 7809

userid oggmgr password oracle

PURGEOLDEXTRACTS ./dirdat/et*, USECHECKPOINTS, MINKEEPDAYS 3

PURGEOLDEXTRACTS ./dirdat/rt*, USECHECKPOINTS, MINKEEPDAYS 3

GGSCI (ocp.mycorpdomain.com) 4>start mgr

GGSCI (ocp.mycorpdomain.com) 5> info mgr

Manager is running (IP port ocp.mycorpdomain.com.7809).

OGG MGR 포트 및 Trail파일 설정(Target)
GGSCI (ocp.mycorpdomain.com) 2> dblogin userid oggmgr, password oracle

Successfully logged into database.

GGSCI (ocp.mycorpdomain.com) 5> edit params mgr

PORT 7810

PURGEOLDEXTRACTS ./dirdat/et*, USECHECKPOINTS, MINKEEPDAYS 3

PURGEOLDEXTRACTS ./dirdat/rt*, USECHECKPOINTS, MINKEEPDAYS 3

GGSCI (ocp.mycorpdomain.com) 7> start mgr

GGSCI (ocp.mycorpdomain.com) 7> info mgr

Manager is running (IP port ocp.mycorpdomain.com.7810).

1-2 Create extract/Data-pump group(Source)

EXTRACT
GGSCI (ocp.mycorpdomain.com) 8> add extract extora, tranlog, begin now

GGSCI (ocp.mycorpdomain.com) 9> edit params EXTORA

-- Extract Parameter File

EXTRACT EXTORA

USERID oggmgr, PASSWORD oracle

TRANLOGOPTIONS OPENARCHIVEIMMEDIATE

THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 60000 IOLATENCY 60000

TRANLOGOPTIONS EXCLUDEUSER OGGMGR, EXCLUDEUSERID 54

EXTTRAIL ./dirdat/et

REPORTCOUNT EVERY 5 MINUTES, RATE

-- Use DDL parameter to configure support for all mapped DDL operations

DDL INCLUDE MAPPED

DDLOPTIONS ADDTRANDATA, REPORT

-- Table/Sequence List

TABLE SCOTT.*;

SEQUENCE SCOTT.*;

GGSCI (ocp.mycorpdomain.com) 10> add exttrail ./dirdat/et, extract extora

Data-PUMP
GGSCI (ocp.mycorpdomain.com) 11>add extract pumpora, exttrailsource ./dirdat/et

GGSCI (ocp.mycorpdomain.com) 12> edit params PUMPA

-- Data Pump Parameter File

EXTRACT PUMPA

PASSTHRU

RMTHOST 192.168.22.10, MGRPORT 7810

RMTTRAIL ./dirdat/rt

REPORTCOUNT EVERY 5 MINUTES, RATE

-- DDL Option

--DDL INCLUDE MAPPED

--DDLOPTIONS REPORT

--DDLERROR DEFAULT ABEND

-- Table/Sequence List

TABLE SCOTT.*;

SEQUENCE SCOTT.*;

GGSCI (ocp.mycorpdomain.com) 13> add rmttrail ./diradat/rt, extract pumpora

[주의사항]

- Trail File명이 혼돈하지 않고 적절하게 사용할 수 있도록 주의 해야 한다.

(EXTRACT(./diradat/et) 파일을 기반으로 Data-PUMP(./diardata/rt)를 생성해야 함으로 파일 명을 혼돈하지 말고 사용할 것.

1-3 Create Chekpoint Table(Target)

GGSCI (ocp.mycorpdomain.com) 14> add checkpointtable oggmgr.ogg_checkpoint

Oggmgr 유저에 해당 테이블 생성 확인

1-4 Create Replicat Group(Target)

GGSCI (ocp.mycorpdomain.com) 15>

add replicat repora, exttrail ./dirdat/rt, checkpointtable oggmgr.ogg_checkpoint

GGSCI (ocp.mycorpdomain.com) 16> edit params REPORA

replicat repora

userid oggmgr, password oracle

assumetargetdefs

DDL INCLUDE MAPPED

DDLOPTIONS REPORT

DDLERROR DEFAULT ABEND

checkpointsecs 1

map scott.*, target scott.*;

[주의사항]

-Replicat 설정시에도 Source DB의 Data-Pump를 이용해야 되기 때문에 추가시 파일 명을 일치시켜주어야 합니다.(./dirdat/rt)

1-5 OGG EXTRACT,PUMP,REPLICAT Start(Source / Target)

OGG EXTRACT,PUMP (Source)

GGSCI (ocp.mycorpdomain.com) 1> Start EXTRACT EXTORA

GGSCI (ocp.mycorpdomain.com) 2> Start EXTRACT PUMPORA

GGSCI (ocp.mycorpdomain.com) 3> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

EXTRACT RUNNING EXTORA 00:00:00 00:00:07

EXTRACT RUNNING PUMPORA 00:00:00 00:00:03

GGSCI (ocp.mycorpdomain.com) 2> info EXTRACT EXTORA

EXTRACT EXTORA Last Started 2013-04-07 22:22 Status RUNNING

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

Log Read Checkpoint Oracle Redo Logs

2013-04-08 22:41:56 Seqno 31, RBA 8829440

SCN 0.1297938 (1297938)

GGSCI (ocp.mycorpdomain.com) 3> info EXTRACT PUMPORA

EXTRACT PUMPORA Last Started 2013-04-07 23:11 Status RUNNING

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

Log Read Checkpoint File ./dirdat/et000002

2013-04-07 23:43:11.000000 RBA 21412

OGG REPLICAT (Target)

GGSCI (ocp.mycorpdomain.com) 1> Start REPLICAT REPORA

GGSCI (ocp.mycorpdomain.com) 2> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

REPLICAT RUNNING REPORA 00:00:00 00:00:00

GGSCI (ocp.mycorpdomain.com) 4> info REPLICAT REPORA

REPLICAT REPORA Last Started 2013-04-07 22:36 Status RUNNING

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

Log Read Checkpoint File ./dirdat/rt000000

2013-04-07 23:43:10.988221 RBA 21512

1-6 OGG TEST Setting 확인

OGG-Checkpoint table(Target)

REPORA 4120505024 0 21512 2013-04-07 23:43:10.988221 2013-04-07 오후 10:26:50 2013-04-07 오후 11:43:16 /ogg 1282955 7.33.914 1282955 7.33.914 1

파일 생성 확인
--Source DB

ocp@orcl : /ogg/dirdat> ls

et000000 et000001 et000002

--Target DB

ocp@orcl : /ogg/dirdat> ls

rt000000

2.OGG TEST / 동작확인(DML / DDL)

- 데이터를 동일하게 이관하여 TEST진행(SCOTT 유저의 기본 테이블을 이용하여 OGG TEST)

OGG TEST(DML/DDL)

--Source DB

select * from scott.emp;

delete from scott.emp;

SET DEFINE OFF;

Insert into SCOTT.EMP

(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, DEPTNO)

Values

(7369, 'SMITH', 'CLERK', 7902, TO_DATE('12/17/1980 00:00:00', 'MM/DD/YYYY HH24:MI:SS'),

800, 20);

Insert into SCOTT.EMP

(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)

Values

(7499, 'ALLEN', 'SALESMAN', 7698, TO_DATE('02/20/1981 00:00:00', 'MM/DD/YYYY HH24:MI:SS'),

1600, 300, 30);

Insert into SCOTT.EMP

(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)

Values

(7521, 'WARD', 'SALESMAN', 7698, TO_DATE('02/22/1981 00:00:00', 'MM/DD/YYYY HH24:MI:SS'),

1250, 500, 30);

Insert into SCOTT.EMP

(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, DEPTNO)

Values

(7566, 'JONES', 'MANAGER', 7839, TO_DATE('04/02/1981 00:00:00', 'MM/DD/YYYY HH24:MI:SS'),

2975, 20);

Insert into SCOTT.EMP

(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)

Values

(7654, 'MARTIN', 'SALESMAN', 7698, TO_DATE('09/28/1981 00:00:00', 'MM/DD/YYYY HH24:MI:SS'),

1250, 1400, 30);

Insert into SCOTT.EMP

(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, DEPTNO)

Values

(7698, 'BLAKE', 'MANAGER', 7839, TO_DATE('05/01/1981 00:00:00', 'MM/DD/YYYY HH24:MI:SS'),

2850, 30);

Insert into SCOTT.EMP

(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, DEPTNO)

Values

(7782, 'CLARK', 'MANAGER', 7839, TO_DATE('06/09/1981 00:00:00', 'MM/DD/YYYY HH24:MI:SS'),

2450, 10);

Insert into SCOTT.EMP

(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, DEPTNO)

Values

(7788, 'SCOTT', 'ANALYST', 7566, TO_DATE('04/19/1987 00:00:00', 'MM/DD/YYYY HH24:MI:SS'),

3000, 20);

Insert into SCOTT.EMP

(EMPNO, ENAME, JOB, HIREDATE, SAL, DEPTNO)

Values

(7839, 'KING', 'PRESIDENT', TO_DATE('11/17/1981 00:00:00', 'MM/DD/YYYY HH24:MI:SS'),

5000, 10);

Insert into SCOTT.EMP

(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)

Values

(7844, 'TURNER', 'SALESMAN', 7698, TO_DATE('09/08/1981 00:00:00', 'MM/DD/YYYY HH24:MI:SS'),

1500, 0, 30);

Insert into SCOTT.EMP

(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, DEPTNO)

Values

(7876, 'ADAMS', 'CLERK', 7788, TO_DATE('05/23/1987 00:00:00', 'MM/DD/YYYY HH24:MI:SS'),

1100, 20);

Insert into SCOTT.EMP

(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, DEPTNO)

Values

(7900, 'JAMES', 'CLERK', 7698, TO_DATE('12/03/1981 00:00:00', 'MM/DD/YYYY HH24:MI:SS'),

950, 30);

Insert into SCOTT.EMP

(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, DEPTNO)

Values

(7902, 'FORD', 'ANALYST', 7566, TO_DATE('12/03/1981 00:00:00', 'MM/DD/YYYY HH24:MI:SS'),

3000, 20);

Insert into SCOTT.EMP

(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, DEPTNO)

Values

(7934, 'MILLER', 'CLERK', 7782, TO_DATE('01/23/1982 00:00:00', 'MM/DD/YYYY HH24:MI:SS'),

1300, 10);

COMMIT;

Alter table scott.emp add new_test char(10)

Alter table scott.emp drop column

OGG 동작 확인
--Source DB

GGSCI (ocp.mycorpdomain.com) 5> stats EXTRACT EXTORA

Sending STATS request to EXTRACT EXTORA ...

Start of Statistics at 2013-04-08 22:51:04.

DDL replication statistics (for all trails):

*** Total statistics since extract started ***

Operations 2.00

Mapped operations 2.00

Unmapped operations 0.00

Other operations 0.00

Excluded operations 0.00

Output to ./dirdat/et:

*** Total statistics since 2013-04-07 22:22:48 ***

No database operations have been performed.

*** Daily statistics since 2013-04-08 00:00:00 ***

No database operations have been performed.

*** Hourly statistics since 2013-04-08 22:00:00 ***

No database operations have been performed.

*** Latest statistics since 2013-04-07 22:22:48 ***

No database operations have been performed.

Extracting from SCOTT.EMP to SCOTT.EMP:

*** Total statistics since 2013-04-07 22:22:48 ***

Total inserts 56.00

Total updates 0.00

Total deletes 56.00

Total discards 0.00

Total operations 112.00

*** Daily statistics since 2013-04-08 00:00:00 ***

No database operations have been performed.

*** Hourly statistics since 2013-04-08 22:00:00 ***

No database operations have been performed.

*** Latest statistics since 2013-04-07 22:22:48 ***

Total inserts 56.00

Total updates 0.00

Total deletes 56.00

Total discards 0.00

Total operations 112.00

Extracting from OGGMGR.GGS_MARKER to OGGMGR.GGS_MARKER:

*** Total statistics since 2013-04-07 22:22:48 ***

No database operations have been performed.

*** Daily statistics since 2013-04-08 00:00:00 ***

No database operations have been performed.

*** Hourly statistics since 2013-04-08 22:00:00 ***

No database operations have been performed.

*** Latest statistics since 2013-04-07 22:22:48 ***

No database operations have been performed.

End of Statistics.

GGSCI (ocp.mycorpdomain.com) 6>

GGSCI (ocp.mycorpdomain.com) 8> stats EXTRACT PUMPORA

Sending STATS request to EXTRACT PUMPORA ...

Start of Statistics at 2013-04-08 22:51:27.

DDL replication statistics (for all trails):

*** Total statistics since extract started ***

Operations 2.00

Output to ./dirdat/rt:

*** Total statistics since 2013-04-07 23:11:14 ***

No database operations have been performed.

*** Daily statistics since 2013-04-08 00:00:00 ***

No database operations have been performed.

*** Hourly statistics since 2013-04-08 22:00:00 ***

No database operations have been performed.

*** Latest statistics since 2013-04-07 23:11:14 ***

No database operations have been performed.

Extracting from SCOTT.EMP to SCOTT.EMP:

*** Total statistics since 2013-04-07 23:11:14 ***

Total inserts 56.00

Total updates 0.00

Total deletes 56.00

Total discards 0.00

Total operations 112.00

*** Daily statistics since 2013-04-08 00:00:00 ***

No database operations have been performed.

*** Hourly statistics since 2013-04-08 22:00:00 ***

No database operations have been performed.

*** Latest statistics since 2013-04-07 23:11:14 ***

Total inserts 56.00

Total updates 0.00

Total deletes 56.00

Total discards 0.00

Total operations 112.00

End of Statistics.

--Target DB

GGSCI (ocp.mycorpdomain.com) 2> stats REPLICAT REPORA

Sending STATS request to REPLICAT REPORA1 ...

Start of Statistics at 2013-04-08 22:51:55.

DDL replication statistics:

*** Total statistics since replicat started ***

Operations 2.00

Mapped operations 2.00

Unmapped operations 0.00

Other operations 0.00

Excluded operations 0.00

Errors 0.00

Retried errors 0.00

Discarded errors 0.00

Ignored errors 0.00

Replicating from SCOTT.EMP to SCOTT.EMP:

*** Total statistics since 2013-04-07 23:24:16 ***

Total inserts 56.00

Total updates 0.00

Total deletes 56.00

Total discards 0.00

Total operations 112.00

*** Daily statistics since 2013-04-08 00:00:00 ***

No database operations have been performed.

*** Hourly statistics since 2013-04-08 22:00:00 ***

No database operations have been performed.

*** Latest statistics since 2013-04-07 23:24:16 ***

Total inserts 56.00

Total updates 0.00

Total deletes 56.00

Total discards 0.00

Total operations 112.00

End of Statistics.

[주의사항]

Vmware 환경이다 보니, Source DB -> Target DB로 작업 내용(DML/DDL)이 넘어가는데 시간이 걸리는 것을 확인할 수 있다.(1~3(s))

3.OGG Logfile List / 자주사용 되는 명령어

3-1 OGG Logfile

구성시 OGG 로그를 Tail 로 열어 두고 작업하는 것이 에러를 찾는데 좋은 방법이 됩니다.

/OGG/ggserr.log

/$ORACLE_BASE/diag/…/Trace/ggs_ddl_trace.log

3-2 OGG 기타 명령어

EXTTRAIL / REPLICAT의 설정 시 좀더 명확하게 옵션을 줄수 있다.
setenv (NLS_LANG = "KOREAN_KOREA.KO16KSC5601")

setenv (ORACLE_SID = "orcl")

EXTTRAIL / REPLICAT 적용이 후, 사용되고 있는 파일 명 변경 한다.
Alter REPLICAT REPORA, exttrail ./dirdat/sa

Alter EXTTRAIL EXTORA, exttrail ./dirdat/si

OGG의 경우 Seqno 및 RBA,SCAN 이 틀어지는 경우가 종종 발생한다 / 해당 번호에 맞게 변경시 사용한다.
ALTER REPLICAT REPORA, EXTSEQNO 0, EXTRBA 0

ALTER EXTTRAIL EXTORA, EXTSEQNO 0, EXTRBA 0

컬럼 mapping(COLMAP) / 세부 옵션의 경우 추가적으로 정리할 예정입니다.

[참고자료]

http://h391106.tistory.com/277

http://gssdba.wordpress.com/category/oracle-golden-gate/

http://mwguru.tistory.com/21

http://setijoagus.wordpress.com/2010/03/27/install-oracle-goldengate-2/

http://gavinsoorma.com/2010/02/oracle-goldengate-tutorial-6-configuring-data-pump-process/

http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html

'1. IT Story > DB' 카테고리의 다른 글

Oracle Datapump를 이용한 Expdp/Impdp백업!! (0)	2013.04.15
Active DataGuard 11gR2 DGMGRL (0)	2013.04.09
Active DataGuard 11gR2 Configuration (0)	2013.04.09
Active DataGuard 11gR2 개념 및 Installation (0)	2013.04.09
Oracle Golden Gate 개념 및 Installaton (2)	2013.04.08
Oracle 11gR2 TDE(Transparent Data Encryption) (0)	2013.03.31
Oracle 10g CRS 제거 (0)	2013.03.31
Oracle 11g RAC with ASM TEST (2)	2013.03.31