【gg notes】config gg for windows x86 32bit ,single node
1, Prepare the install environment
OS: windows XP(x86-32-bit)
DB: Oracle11R2
GG: ggs_Windows_x86_ora11g_32bit
Network: single node test
2, Download GG for windows x86-32-bit-edition, just for test
This is the web link:
http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html
3, Extract file to your path
Like:
C:\gg
4, Alter database archivelog
Oracle GG need database running on archive mode
Need perform. these commands:
Shutdown immediate;
Startup mount;
Alter database archivelog;
Alter database open;
5, Create test user and tables
Create user ggs identified by ggs;
Create user ggt identified by ggt;
Grant dba to ggs;
Grant dba to ggt;
Conn ggs/ggs
Create table test(
Stu_id number(6),
Stu_name varchar2(20),
Stu_pass varchar2(20)
);
Conn ggt/ggt;
Create table test(
Stu_id number(6),
Stu_name varchar2(20),
Stu_pass varchar2(20)
);
6, Config golden gate
1) Create file path
Access path c:\gg
Execute ggsci.exe
In ggsci command,execute:
Create subdirs ---only for the first config operation
2) Modify params for manager process(mgr)
Edit param mgr
Content:
Port 7809 --set the manager running port
Can use command:
Start mgr
To start the mgr process
Can use command :
Info all
To see the status of mgr running
3) Add supplemental logging for table, both source and target
4) Add and edit params for extract progress
Command:
Add extract ext1,tranlog,begin now
Edit param ext1
Param Contents:
Userid ggs,password ggs
Rmthost 127.0.0.1 mgrport 7809
Rmttrail C:\gg\dirdat\r1
Dynamicresolution
Table ggs.test
Add remote list
Add rmttrail C:\gg\dirdat\r1,extract ext1,megabyte 100
5) Add and edit replicat process param
Add replicat rep1,exttrail C:\gg\dirdat\r1,modebcheckpoint
Edit param rep1
Rep1.prm contents:
Userid ggt,password ggt
Assumetargetdefs
Discardfile C:\gg\dirdatrep1.dsc,append
MAP ggs.*,TARGET ggt.*
6) Start progress
Start extract progress:
Start ext1
Start replicat progress
Start rep1
Check the progress running
Info all
7) Testing
Conn ggs/ggs
Insert into test select 1,’aa’,’pass1’ from dual;
Insert into test select 2,’bb’,’pass2’ from dual;
Commit;
few seconds later:
conn ggt/ggt
select * from test;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/16179598/viewspace-758543/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【gg notes】config gg for windows x86 32bit ,two nodeWindows
- Node express 整合SwaggerExpressSwagger
- defeegdrfgfbghgggngng
- OGG_windows搭建實驗Windows
- ZT:another easter egg in windows xpASTWindows
- 掘金 AMA:聽阿里 Node 基礎框架 EggJS 的核心開發者–天豬講 EggJS 和 Node 那些事阿里框架JS
- 掘金 AMA:聽阿里 Node 基礎框架 EggJS 的核心開發者--天豬講 EggJS 和 Node 那些事阿里框架JS
- python logging模組註冊流程(以logging.config.dictConfig流程為例)Python
- MongoDB:aggregate與aggregateCursorMongoDB
- kaggle
- UGUI原始碼解析(Toggle和ToggleGroup)UGUI原始碼
- triggerHandler()和trigger()區別
- 從egg.js重新認識node後端開發JS後端
- Oracle 建立PDB-Plugging In an Unplugged PDBOracle
- PostgreSQL DBA(34) - (HashAggregate vs GroupAggregate)SQL
- Hugging News #0428: HuggingChat 來啦GC
- ogg GGS ERROR 500 Could not find archived logErrorHive
- Oracle OGG 到 Kafka OGG-01431 OGG-01003 OGG-01151 OGG-01296 OGG-01668OracleKafka
- JavaScript toggle()JavaScript
- swaggerSwagger
- jQuery toggleClass()jQuery
- jQuery toggle()jQuery
- Templates by HanggoashGo
- Kaggle CLI
- 日誌記錄模式(LOGGING 、FORCE LOGGING 、NOLOGGING)模式
- 10g Cluster啟動OGG後./ggsci登入OGG無法操作
- 在原ogg基礎上重新搭建ogg
- 【OGG】OGG的下載和安裝篇
- ClassCastException Log4jLoggerFactory LoggerContexASTException
- Python(logging.getLogger().info())Python
- Oracle DML/DDL同步資料(OGG_12.2_for_Windows)OracleWindows
- OGG問題處理(OGG-01031,OGG-01416)
- trigger 'SYS.GGS_DDL_TRIGGER_BEFORE' is invalid and failed re-validationAI
- 基於 logger sdk-logger 封裝封裝
- ogg 同步kafka OGG-15051 Java or JNI exception:KafkaJavaException
- RRGGBBAA或者RRGGBB轉換成rgba()
- create index logging, nologging performance testIndexORM
- Important points about LOGGING and NOLOGGING(轉)Import