CNDBA社区
生产端 灾备段都要做
GGSCI (db1.example.com) 4> create subdirs
Creating subdirectories under current directory /u01/app/oracle/ogg
Parameter files /u01/app/oracle/ogg/dirprm: already exists
Report files /u01/app/oracle/ogg/dirrpt: already exists
Checkpoint files /u01/app/oracle/ogg/dirchk: already exists
Process status files /u01/app/oracle/ogg/dirpcs: already exists
SQL script files /u01/app/oracle/ogg/dirsql: already exists
Database definitions files /u01/app/oracle/ogg/dirdef: already exists
Extract data files /u01/app/oracle/ogg/dirdat: already exists
Temporary files /u01/app/oracle/ogg/dirtmp: already exists
Stdout files /u01/app/oracle/ogg/dirout: already exists
Create subdirs 会创建一些ogg作用目录。
dirrpm是用来存放参数文件。
dirrpt是用来存放进程报告文件。
dirchk是用来存放检查点文件。
dirpcs是用来存放进程状态文件。
Dirdef是用来存放通过defgen工具生成的源或目标端数据定义文件。
Dirsql用来存放sql脚本文件。
Dirdat用来存放trail文件
Dirtmp当事务所需要的内存超过已分配的内存是，默认存储在这个目录
创建ggs用户，授予权限。
要是不想麻烦的haunted，可以直接授予dba权限，一切搞定。
生产端：
SQL> create user ggtest identified by ggtest default tablespace users temporary tablespace temp quota unlimited on users;
User created.
SQL> grant connect,resource to ggtest;
Grant succeeded.
SQL>
生产端创建测试表
SQL> conn ggtest/ggtest
Connected.
SQL> select object_name,object_type from user_objects;
no rows selected
SQL> @/u01/app/oracle/ogg/demo_ora_create.sql
DROP TABLE tcustmer
*
ERROR at line 1:
ORA-00942: table or view does not exist
Table created.
DROP TABLE tcustord
*
ERROR at line 1:
ORA-00942: table or view does not exist
Table created.
SQL>
生产端插入数据：
SQL> @/u01/app/oracle/ogg/demo_ora_insert.sql
1 row created.
1 row created.
1 row created.
1 row created.
Commit complete.
灾备端创建ggtest测试用户
SQL> create user ggtest identified by ggtest default tablespace users temporary tablespace temp quota unlimited on users;
User created.
SQL> grant connect,resource to ggtest;
Grant succeeded.
SQL>
SQL> conn ggtest/ggtest
Connected.
SQL> show user
USER is "GGTEST"
SQL> @/u01/app/oracle/ogg/demo_ora_create.sql
DROP TABLE tcustmer
*
ERROR at line 1:
ORA-00942: table or view does not exist
Table created.
DROP TABLE tcustord
*
ERROR at line 1:
ORA-00942: table or view does not exist
Table created.
SQL>
SQL> select * from tcustmer;
no rows selected
SQL> select * from tcustord;
no rows selected
SQL>
SQL> desc tcustmer;
Name Null? Type
----------------------------------------- -------- ----------------------------
CUST_CODE NOT NULL VARCHAR2(4)
NAME VARCHAR2(30)
CITY VARCHAR2(20)
STATE CHAR(2)
SQL> desc tcustord;
Name Null? Type
----------------------------------------- -------- ----------------------------
CUST_CODE NOT NULL VARCHAR2(4)
ORDER_DATE NOT NULL DATE
PRODUCT_CODE NOT NULL VARCHAR2(8)
ORDER_ID NOT NULL NUMBER
PRODUCT_PRICE NUMBER(8,2)
PRODUCT_AMOUNT NUMBER(6)
TRANSACTION_ID NUMBER
生产端查看表：
SQL> select * from tcustmer;
CUST NAME CITY ST
---- ------------------------------ -------------------- --
WILL BG SOFTWARE CO. SEATTLE WA
JANE ROCKY FLYER INC. DENVER CO
SQL> select * from tcustord;
CUST ORDER_DAT PRODUCT_ ORDER_ID PRODUCT_PRICE PRODUCT_AMOUNT TRANSACTION_ID
---- --------- -------- ---------- ------------- -------------- --------------
WILL 30-SEP-94 CAR 144 17520 3 100
JANE 11-NOV-95 PLANE 256 133300 1 100
SQL> desc tcustmer;
Name Null? Type
----------------------------------------- -------- ----------------------------
CUST_CODE NOT NULL VARCHAR2(4)
NAME VARCHAR2(30)
CITY VARCHAR2(20)
STATE CHAR(2)
SQL> desc tcustord;
Name Null? Type
----------------------------------------- -------- ----------------------------
CUST_CODE NOT NULL VARCHAR2(4)
ORDER_DATE NOT NULL DATE
PRODUCT_CODE NOT NULL VARCHAR2(8)
ORDER_ID NOT NULL NUMBER
PRODUCT_PRICE NUMBER(8,2)
PRODUCT_AMOUNT NUMBER(6)
TRANSACTION_ID NUMBER
看的出来两边的表结构是一致的。
生产端
GGSCI (db3.example.com) 1> info mgr
Manager is running (IP port db3.example.com.7809).
GGSCI (db3.example.com) 2>
GGSCI (db3.example.com) 2> info mgr
Manager is running (IP port db3.example.com.7809).
GGSCI (db3.example.com) 3> dblogin userid system, password oracle
Successfully logged into database.
GGSCI (db3.example.com) 4> add trandata ggtest.tcustmer
Logging of supplemental redo data enabled for table GGTEST.TCUSTMER.
GGSCI (db3.example.com) 5> add trandata ggtest.tcustord
Logging of supplemental redo data enabled for table GGTEST.TCUSTORD.
GGSCI (db3.example.com) 6> info trandata ggtest.*
Logging of supplemental redo log data is enabled for table GGTEST.TCUSTMER.
Columns supplementally logged for table GGTEST.TCUSTMER: CUST_CODE.
Logging of supplemental redo log data is enabled for table GGTEST.TCUSTORD.
Columns supplementally logged for table GGTEST.TCUSTORD: CUST_CODE, ORDER_DATE, PRODUCT_CODE, ORDER_ID.
GGSCI (db3.example.com) 7>
生产端增加extrace 进程组einit 并配置参数。
GGSCI (db3.example.com) 7> add extract einit,sourceistable
EXTRACT added.
GGSCI (db3.example.com) 8> edit params einit
extract einit
userid system, password oracle
rmhost 192.168.0.104,mgrport 7809
rmttask replicat,group rinit
table ggtest.tcustmer;
table ggtest.tcustord;
~
GGSCI (db3.example.com) 9> info extract *,tasks
EXTRACT EINIT Initialized 2016-07-07 04:23 Status STOPPED
Checkpoint Lag Not Available
Log Read Checkpoint Not Available
First Record Record 0
Task SOURCEISTABLE
灾备端增加replicat组rinit，并配置参数。
GGSCI (db4.example.com) 1> add replicat rinit,specialrun
REPLICAT added.
GGSCI (db4.example.com) 3> edit params rinit
replicat rinit
assumetargetdefs
userid system, password oracle
discardfile ./dirrpt/rinit.dsc,purge
map ggtest.*,target ggtest.*;
~
~
GGSCI (db4.example.com) 4> info replicat *,task
REPLICAT RINIT Initialized 2016-07-07 04:29 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:03:06 ago)
Log Read Checkpoint Not Available
Task SPECIALRUN
启动生产库的extract并查看生产库的extract报告
GGSCI (db3.example.com) 10> start extract einit
Sending START request to MANAGER ...
EXTRACT EINIT starting
版权声明：本文为博主原创文章，未经博主允许不得转载。
- 上一篇：oracle 容灾产品 goldengate
- 下一篇：Linux 7 密码破解
