Shulou(Shulou.com)06/01 Report--

Configure deployment Oracle Goldengate Version 11.2.1.0.1

Configure user environment variables

Vi .bash _ profile

Add:

Export OGG_HOME=/data0/temp/ogg

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

Export LD_LIBRARY_PATH

Check whether the data is enabled for archiving

SQL > archive log list;-- Enabled

Configuring logging properties

Oracle GoldenGate relies on the redo logs to capture the data and metadata that it

Needs to replicate source transactions. The Oracle redo logs on the source system must

Be configured properly before you start Oracle GoldenGate processing. Because redo

Volume is increased as the result of this required logging, you might want to wait until

Just before you start Oracle GoldenGate processing to enable the logging.

This section addresses the following logging levels:

■ Enabling database-level supplemental logging

■ Enabling schema-level supplemental logging

■ Enabling table-level supplemental logging

Check the database log opening

SQL > Select SUPPLEMENTAL_LOG_DATA_MIN

2 SUPPLEMENTAL_LOG_DATA_PK

3 SUPPLEMENTAL_LOG_DATA_UI

4 SUPPLEMENTAL_LOG_DATA_FK

5 SUPPLEMENTAL_LOG_DATA_ALL from v$database

SUPPLEME SUP SUP SUP SUP

NO NO NO NO NO

Open additional logs and switch logs (make sure Online redo log and Archive log are consistent)

Alter database add supplemental log data

Alter database add supplemental log data (primary key, unique,foreign key) columns

Alter system switch logfile

Check the log opening again:

SQL > Select SUPPLEMENTAL_LOG_DATA_MIN

2 SUPPLEMENTAL_LOG_DATA_PK

3 SUPPLEMENTAL_LOG_DATA_UI

4 SUPPLEMENTAL_LOG_DATA_FK

SUPPLEMENTAL_LOG_DATA_ALL from v$database

five

SUPPLEME SUP SUP SUP SUP

YES YES YES YES NO

Note: make sure the minimum additional log is opened and the pk,uk,fk additional log is turned on. The additional log of all columns is closed.

If the additional log for all columns is turned on, you need to turn it off using the following statement:

Alter database drop supplemental log data (ALL) columns

If there is a problem, you can fallback with the following statement:

Alter database drop supplemental log data

Alter database drop supplemental log data (primary key, unique,foreign key) columns

Alter system switch logfile

Enable strong log mode in the database:

SQL > alter database force logging

-- Note: here the source library is already dataguard primary DB, so the mandatory log mode has been enabled:

View:

SQL > select FORCE_LOGGING from v$database

FOR

-

YES

SQL >

Close recyclebin

-- Note at the system level, modification is not allowed without adding the DEFERRED parameter

SQL > alter system set recyclebin=off DEFERRED

System altered.

SQL > show parameter recyclebin

NAME TYPE VALUE

-

Recyclebin string on

SQL >

Log out and log in again to view

[oracle@dkdb_primary ~] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed May 13 18:50:42 2015

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL > show parameter recyclebin

NAME TYPE VALUE

-

Recyclebin string OFF

SQL >

Install goldengate on source side and target side

[oracle@dkdb_primary ogg] $. / ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO

Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14

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

GGSCI (dkdb_primary) 1 > CREATE SUBDIRS

Creating subdirectories under current directory / data0/temp/ogg

Parameter files / data0/temp/ogg/dirprm: already exists

Report files / data0/temp/ogg/dirrpt: created

Checkpoint files / data0/temp/ogg/dirchk: created

Process status files / data0/temp/ogg/dirpcs: created

SQL script files / data0/temp/ogg/dirsql: created

Database definitions files / data0/temp/ogg/dirdef: created

Extract data files / data0/temp/ogg/dirdat: created

Temporary files / data0/temp/ogg/dirtmp: created

Stdout files / data0/temp/ogg/dirout: created

GGSCI (dkdb_primary) 2 >

GGSCI (dkdb_primary) 3 > info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER STOPPED

Install oracle sequence support

The users here are the same as those needed to create DDL synchronization. (login source side and destination side perform the creation of users):

SQL > create tablespace urogg datafile'/ opt/oracle/database/oradata/dkhlstd/dkhlstd/urogg01.dbf' size 100m autoextend on NOLOGGING

Tablespace created.

SQL > create user urogg identified by test_oracle1_P default tablespace urogg temporary tablespace temp

User created.

Empowerment:

GRANT CONNECT, RESOURCE, DBA TO urogg

GRANT CREATE TABLE,CREATE SEQUENCE TO urogg;-- is used for users to install DDL and execute SQL scripts.

Edit GLOBALS parameters

Enter. / ggsci to execute on all nodes

EDIT PARAMS. / GLOBALS and add

GGSCHEMA urogg-the specified database user for DDL replication

Save the exit and enter $OGG_HOME to log in to sqlplus / as sysdba to execute the script

SQL > @ sequence.sql

Please enter the name of a schema for the GoldenGate database objects:

Urogg

Setting schema name to UROGG

Source side:

SQL > GRANT EXECUTE on urogg.updateSequence TO urogg

Grant succeeded.

SQL > ALTER TABLE sys.seq$ ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS

Table altered.

SQL >

Target side:

SQL > GRANT EXECUTE on urogg.replicateSequence TO urogg

Grant succeeded.

Edit target side GLOBALS

GGSCI (dkdb_ogg) 10 > edit params. / GLOBALS

-- GGSCHEMA urogg

CHECKPOINTTABLE urogg.checktable-add checkpointtable

Add checkpointtable

GGSCI (dkdb_ogg) 16 > ADD CHECKPOINTTABLE DKOGG.CHECKTABLE

Successfully created checkpoint table urogg.checktable.

Add table-level additional logs:

GGSCI (dkdb_primary) 1 > dblogin userid urogg,password test_oracle1_P

Successfully logged into database.

GGSCI (dkdb_primary) 5 > show user

Parameter settings:

SET SUBDIRS ON

SET DEBUG OFF

Current directory: / data0/temp/ogg

Using subdirectories for all process files

Editor: vi

Reports (.rpt) / data0/temp/ogg/dirrpt

Parameters (.prm) / data0/temp/ogg/dirprm

Stdout (.out) / data0/temp/ogg/dirout

Replicat Checkpoints (.cpr) / data0/temp/ogg/dirchk

Extract Checkpoints (.cpe) / data0/temp/ogg/dirchk

Process Status (. PCS) / data0/temp/ogg/dirpcs

SQL Scripts (.SQL) / data0/temp/ogg/dirsql

Database Definitions (.def) / data0/temp/ogg/dirdef

GGSCI (dkdb_primary) 3 > add trandata TEST_D.*

A warning appears here:

WARNING OGG-00869 、 WARNING OGG-01387

2015-05-11 20:09:36 WARNING OGG-00869 No unique key is defined for table'Tables APPDETAILITY.

All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

Check to confirm:

GGSCI (dkdb_primary) 4 > info trandata TEST_D.*

Logging of supplemental redo log data is enabled for table TEST_D.API_SWITCH.

Columns supplementally logged for table TEST_D.API_SWITCH: API_NAME, ISVALID, API_COMMENT, API_ID.

Note: there is no; number after add trandata TEST_D.*.

Otherwise, the error is as follows:

GGSCI (dkdb_primary) 2 > add trandata test_desk.*

ERROR: No viable tables matched specification.

Create a manager process:

GGSCI (dkdb_primary) 4 > edit param mgr

PORT 7801

DYNAMICPORTLIST 7802-7820

PURGEOLDEXTRACTS / opt/ogg/dirdat/ *, USECHECKPOINTS, MINKEEPDAYS 7

-- configure the DDL parameter area

-- trail file retained for 7 days

PURGEDDLHISTORY MINKEEPDAYS 7, MAXKEEPDAYS 10,FREQUENCYMINUTES 30

PURGEMARKERHISTORY MINKEEPDAYS 7, MAXKEEPDAYS 10

-- configure the general log information area

LAGREPORTHOURS 1

LAGINFOMINUTES 30

LAGCRITICALMINUTES 45

-# # Note. / dirdat/*

-- AUTORESTART EXTRACT *, RETRIES 5, WAITMINUTES 7 automatically start the extract process

GGSCI (dkdb_primary) 5 >

Start the mgr process

GGSCI (dkdb_primary) 5 > start mgr

Manager started.

GGSCI (dkdb_primary) 6 > info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

GGSCI (dkdb_primary) 7 >

Configure the source-side extract process

1. Get encryption

GGSCI (dkdb_primary) 56 > encrypt password test_oracle1_P, ENCRYPTKEY default

Using default key...

Encrypted password: AACAAAAAAAAAAANAOHOJFBNCCHOJHEGIIARCPDNETBLFDEWF

Algorithm used: BLOWFISH

Test:

GGSCI (dkdb_primary) 57 > dblogin userid urogg,password AACAAAAAAAAAAANAOHOJFBNCCHOJHEGIIARCPDNETBLFDEWF, ENCRYPTKEY default

Successfully logged into database.

2. Query whether there are any transactions waiting

Select count (*) from gv$transaction

3. Extract process parameter configuration

GGSCI (dkdb_primary) 5 > edit param extdr

-- basic parameter area

EXTRACT extdr

SETENV (NLS_LANG= "AMERICAN_AMERICA.AL32UTF8")

USERID urogg,PASSWORD AACAAAAAAAAAAANAOHOJFBNCCHOJHEGIIARCPDNETBLFDEWF, ENCRYPTKEY default

REPORTCOUNT EVERY 30 MINUTES,RATE

DISCARDFILE. / dirrpt/extdr.dsc, APPEND, MEGABYTES 1024

DISCARDROLLOVER AT 3:00

WARNLONGTRANS 2h, CHECKINTERVAL 3m

EXTTRAIL. / dirdat/sa

DYNAMICRESOLUTION

DBOPTIONS ALLOWUNUSEDCOLUMN

FETCHOPTIONS NOUSESNAPSHOT

TRANLOGOPTIONS CONVERTUCS2CLOBS

TRANLOGOPTIONS EXCLUDEUSER urogg

-- TRANLOGOPTIONS altarchivelogdest instance dkhlstd / opt/oracle/database/fast_recovery_area

THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 60000 IOLATENCY 60000

-- DDL parameter area, all copied objects and shielded objects are reflected on the source side.

DDL &

INCLUDE MAPPED OBJTYPE 'TABLE' &

INCLUDE MAPPED OBJTYPE 'INDEX' &

INCLUDE MAPPED OBJTYPE 'SEQUENCE' &

INCLUDE MAPPED OBJTYPE 'VIEW' &

INCLUDE MAPPED OBJTYPE 'PROCEDURE' &

INCLUDE MAPPED OBJTYPE 'FUNCTION' &

INCLUDE MAPPED OBJTYPE 'PACKAGE' &

EXCLUDE OPTYPE COMMENT

DDLOPTIONS addtrandata REPORT

-- add object

TABLE TEST_D.*

SEQUENCE TEST_D.*

Configure the data pump process on the source side:

These steps configure the data pump that reads the local trail and sends the data

Across the network to a remote trail.

GGSCI (dkdb_primary) 8 > edit param extpump

-- basic parameter area

EXTRACT extpump

RMTHOST 172.16.1.246, MGRPORT 7801, COMPRESS

PASSTHRU

RMTTRAIL. / dirdat/sa

DYNAMICRESOLUTION

-- object area

TABLE TEST_D.*

SEQUENCE TEST_D.*

Configure DDL objects

Empower urogg users:

GRANT EXECUTE ON utl_file TO urogg

Enter OGG_HOME,sqlplus / as sysdba

Execute the script and enter the ogg user urogg:

@ marker_setup.sql

SQL > @ marker_setup.sql

Marker setup script

You will be prompted for the name of a schema for the Oracle GoldenGate database objects.

NOTE: The schema must be created prior to running this script.

NOTE: Stop all DDL replication before starting this installation.

Enter Oracle GoldenGate schema name:urogg

@ ddl_setup.sql

SQL > @ ddl_setup.sql

Oracle GoldenGate DDL Replication setup script

Verifying that current user has privileges to install DDL Replication...

You will be prompted for the name of a schema for the Oracle GoldenGate database objects.

NOTE: For an Oracle 10g source, the system recycle bin must be disabled. For Oracle 11g and later, it can be enabled.

NOTE: The schema must be created prior to running this script.

NOTE: Stop all DDL replication before starting this installation.

Enter Oracle GoldenGate schema name:urogg

@ role_setup.sql

SQL > @ role_setup.sql

GGS Role setup script

This script will drop and recreate the role GGS_GGSUSER_ROLE

To use a different role name, quit this script and then edit the params.sql script to change the gg_role parameter to the preferred name. (Do not run the script.)

You will be prompted for the name of a schema for the GoldenGate database objects.

NOTE: The schema must be created prior to running this script.

NOTE: Stop all DDL replication before starting this installation.

Enter GoldenGate schema name:urogg

GRANT GGS_GGSUSER_ROLE TO urogg

-- SQL > GRANT GGS_GGSUSER_ROLE TO urogg

-- GRANT GGS_GGSUSER_ROLE TO urogg

-- *

-ERROR at line 1:

-ORA-04098: trigger 'SYS.GGS_DDL_TRIGGER_BEFORE' is invalid and failed re-validation

Turn on DDL

Ddl_enable.sql

SQL > @ ddl_enable.sql

Trigger altered.

Install performance improvement tools

-- in order to provide the performance of DDL replication of OGG, you can add the ddl_pin script to the script started by the database. The script needs to take the parameters of the DDL user of OGG (that is, the user who installs the DDL object, in this case, goldengate). If the script does not execute properly, you need to create a DBMS_SHARED_POOL package in advance (you can create it by executing $ORACLE_HOME/rdbms/admin/ dbmspoll.sql).

-- do the following to create a performance improvement tool

SQL > @ ddl_pin urogg

-- if you need to disable DDL triggers temporarily due to business problems, if enabling DDL has a great impact on performance, you can run the following statement:

SQL > @ ddl_disable.sql

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

-- add extraction / transfer processes and queue files

GGSCI (dkdb_primary) 1 > stop mgr!

Sending STOP request to MANAGER...

Request processed.

Manager stopped.

GGSCI (dkdb_primary) 2 > ADD EXTRACT extdr, TRANLOG, BEGIN 2015-05-21 08:22:22

EXTRACT added.

GGSCI (dkdb_primary) 3 > ADD EXTTRAIL. / dirdat/sa, EXTRACT extdr, MEGABYTES 200

EXTTRAIL added.

GGSCI (dkdb_primary) 5 > ADD EXTRACT extpump, EXTTRAILSOURCE. / dirdat/sa

EXTRACT added.

GGSCI (dkdb_primary) 6 > ADD RMTTRAIL. / dirdat/sa, EXTRACT extpump, MEGABYTES 200

RMTTRAIL added.

GGSCI (dkdb_primary) 7 > info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER STOPPED

EXTRACT STOPPED EXTDR 00:00:00 00:00:43

EXTRACT STOPPED EXTPUMP 00:00:00 00:00:13

GGSCI (dkdb_primary) 8 > start mgr

Manager started.

GGSCI (dkdb_primary) 9 > start ext*

GGSCI (dkdb_primary) 28 > info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

EXTRACT RUNNING EXTDR 00:00:00 00:00:03

EXTRACT RUNNING EXTPUMP 00:00:00 00:16:12

-- Note: modify extract process queue file

GGSCI (dkdb_primary) 61 > ALTER EXTRACT extpump, EXTTRAILSOURCE. / dirdat/sa

EXTRACT altered.

Use data pump to synchronize data

Select current_scn from v$database

SQL > select current_scn from v$database

CURRENT_SCN

-

1442477

SQL >

Data pump export:

Expdp system/test_oracle1_P directory=DATA_PUMP_DIR cluster=n compression=all schemas=TEST_D parallel=2 logfile=expdp201505012.log dumpfile=DKPRODB_EX%U.DMP reuse_dumpfiles=y flashback_scn=1442477

Data pump import:

Impdp SYSTEM/test_oracle1_P DIRECTORY=DATA_PUMP_DIR DUMPFILE=DKPRODB_EX01.DMP, DKPRODB_EX02.DMP LOGFILE=import.log table_exists_action=truncate

View the mgr process:

GGSCI (dkdb_ogg) 1 > info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

GGSCI (dkdb_ogg) 2 > view report mgr

A warning appears

WARNING OGG-00952

Disable triggers:

Select trigger_name,status from dba_triggers where owner='TEST_D'

Declare

V_sql varchar2 (2000)

CURSOR c_trigger IS SELECT 'alter trigger' | | owner | |'. | | trigger_name | | 'disable' from dba_triggers where owner =' TEST_D'

BEGIN

OPEN c_trigger

LOOP

FETCH c_trigger INTO v_sql

EXIT WHEN c_trigger%NOTFOUND

Execute immediate v_sql

End loop

Close c_trigger

End

/

SQL > select trigger_name,status from dba_triggers where owner='TEST_D'

TRIGGER_NAME STATUS

TRIG_IN_UP_T_APPDETAIL DISABLED

Disable foreign keys:

Declare

V_sql varchar2 (2000)

CURSOR c_trigger IS SELECT 'alter table' | | owner | |'. | | table_name | | 'disable constraint' | | constraint_name from dba_constraints where constraint_type='R' and owner = 'TEST_D''

BEGIN

OPEN c_trigger

LOOP

FETCH c_trigger INTO v_sql

EXIT WHEN c_trigger%NOTFOUND

Execute immediate v_sql

End loop

Close c_trigger

End

/

SQL > select table_name,constraint_name from dba_constraints where owner='TEST_D' and constraint_type='R'

No rows selected

SQL >

You can choose to close the archive, depending on the actual situation of the business.

Configure the replicat process on the target side:

Replicat process on target side

Production key

Encrypt password test_oracle1_P, ENCRYPTKEY default

GGSCI (dkdb_ogg) 17 > encrypt password test_oracle1_P, ENCRYPTKEY default

Using default key...

Encrypted password: AACAAAAAAAAAAANAOHOJFBNCCHOJHEGIIARCPDNETBLFDEWF

Algorithm used: BLOWFISH

Configuration process:

Edit params repdr

-- basic parameter area

REPLICAT repdr

USERID urogg, PASSWORD AACAAAAAAAAAAANAOHOJFBNCCHOJHEGIIARCPDNETBLFDEWF, ENCRYPTKEY default

SETENV (NLS_LANG= "AMERICAN_AMERICA.AL32UTF8")

SQLEXEC "ALTER SESSION SET CONSTRAINTS=DEFERRED"

REPORT AT 06:00

REPORTCOUNT EVERY 25 MINUTES, RATE

REPORTROLLOVER AT 02:00

REPERROR DEFAULT, ABEND

ALLOWNOOPUPDATES

ASSUMETARGETDEFS

DISCARDFILE. / dirrpt/repdr.dsc, APPEND, MEGABYTES 1024M

DISCARDROLLOVER AT 02:30

ALLOWNOOPUPDATES

-- the operation types that need to be masked in the DDL parameter region are masked in this area.

DDL include mapped

Ddloptions report

-- DDL error filtering

-- DDLERROR IGNORE

-- DDLERROR IGNORE

-- copy the object area

MAP TEST_D.*, TARGET TEST_D.*

/ *

Report

Valid for Extract and Replicat

Use the REPORT parameter to specify when Extract or Replicat generates interim runtime

Statistics in a process report. The statistics are added to the existing report. By default

Runtime statistics are displayed at the end of a run unless the process is intentionally

Killed.

The statistics for REPORT are carried over from the previous report. For example, if the

Process performed 10 million inserts one day and 20 million the next, and a report is

Generated at 3:00 each day, then the first report would show the first 10 million inserts

And the second report would show those plus the current day's 20 million inserts, totalling

30 million. To reset the statistics when a new report is generated, use the STATOPTIONS

Parameter with the RESETREPORTSTATS option. See page 335.

For more information about using process reports, see the Oracle GoldenGate Windows

And UNIX Administrator's Guide

-- Example

Example 1 REPORT AT 17:00

Example 2 REPORT ON SUNDAY AT 1:00

, /

/ *

REPORTCOUNT

Valid for Extract and Replicat

Use the REPORTCOUNT parameter to report a count of transaction records that Extract or

Replicat processed since startup. Each transaction record represents a logical database

Operation that was performed within a transaction that was captured by Oracle

GoldenGate. The record count is printed to the report file and to the screen.

-- NOTE This count might differ from the number of records that are contained in the Oracle

GoldenGate trail. If an operation affects data that is larger than 4K, it must be

Stored in more than one trail record. Hence, a report count might show 1000

Records (the database operations) but a trail count might show many more records

Than that. To obtain a count of the records in a trail, use the Logdump utility.

You can schedule record counts at regular intervals or after a specific number of records.

Record counts are carried over from one report to the other.

REPORTCOUNT can be used only once in a parameter file. If there are multiple instances of

REPORTCOUNT, Oracle GoldenGate uses the last one.

Default None

Syntax REPORTCOUNT [EVERY]

{RECORDS | SECONDS | MINUTES | HOURS} [, RATE]

, /

-- add replicat process

ADD REPLICAT repdr1, EXTTRAIL. / dirdat/sa

ADD REPLICAT repdr2, EXTTRAIL. / dirdat/sa

-- start the replicat process

GGSCI (dkdb_ogg) 65 > start replicat repdr, aftercsn 1442477

Sending START request to MANAGER...

REPLICAT REPDR starting

-- start the replicat process

-- specify the SCN number to start

Start replicat repdr, aftercsn 1442477

-- specify the rba number to start

Start replicat repdr1, extseqno 5, RBA 2535303

Start replicat repdr2, extseqno 5, RBA 2535303

-- specify a specific time to start

Alter REPDR1,begin yyyy-mm-dd

Start repdr1

GGSCI (dkdb_ogg) 66 > info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

REPLICAT RUNNING REPDR 00:00:00 00:00:01

Create table WIDGET_BAK as select * from P_WIDGET where 1x2 empty table

DML Test:

Update table P_WIDGET set state=6

Commit

View on the standby side:

SQL > select state from test_desk.P_WIDGET

STATE

-

six

six

six

View extract processes on source (primary) side

There will be a warning: WARNING OGG-00869

View the target side:

[root@dkdb_ogg ~] # su-oracle

[oracle@dkdb_ogg ~] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed May 13 16:59:48 2015

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL > select state from test_desk.P_WIDGET

STATE

-

six

six

.

six

34 rows selected.

Here shows that DML has been tested successfully!

DDL Test:

-- # # Source (primary_db):

Create a tabl

SQL > CONN test_desk/pwd4test

Connected.

SQL > create table WIDGET_BAK as select * from P_WIDGET where 1: 2

-- # # View on Standby_db

SQL > CONN test_desk/pwd4test

Connected.

SQL > select count (*) from WIDGET_BAK

COUNT (*)

-

0

SQL > select count (*) from P_WIDGET

COUNT (*)

-

thirty-four

SQL >

-- # # OGG_ Target end

View report repdr process log

2015-05-13 14:04:18 INFO OGG-00482 DDL found, operation [create table WIDGET_BAK as select * from P_WIDGET where 1: 2 (size 80)].

2015-05-13 14:04:18 INFO OGG-00489 DDL is of mapped scope, after mapping new operation [create table TEST_D. "WIDGET_BAK" as select * from QN_DESKTOP_ "

WIDGET where 1: 2 (size 92)].

2015-05-13 14:04:18 INFO OGG-00487 DDL operation included [include mapped], optype [CREATE], objtype [TABLE], objowner [TEST_D], objname [WIDGET_BAK]

.

2015-05-13 14:04:18 INFO OGG-01407 Setting current schema for DDL operation to [TEST_D].

2015-05-13 14:04:18 INFO OGG-00484 Executing DDL operation.

2015-05-13 14:04:18 INFO OGG-00483 DDL operation successful.

2015-05-13 14:04:18 INFO OGG-01408 Restoring current schema for DDL operation to [urogg].

This indicates that the synchronization has been successful. Go to the library to check.

SQL > show user

USER is "TEST_D"

SQL > select count (*) from WIDGET_BAK

COUNT (*)

-

0

SQL > select count (*) from P_WIDGET

COUNT (*)

-

thirty-four

SQL >

View the replicat process:

GGSCI (dkdb_ogg) 16 > info replicat repdr detail

REPLICAT REPDR Last Started 2015-05-13 12:00 Status RUNNING

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

Log Read Checkpoint File. / dirdat/sa000000

2015-05-13 14 04Rose 12.382273 RBA 43978

Extract Source Begin End

. / dirdat/sa000000 2015-05-13 09:12 2015-05-13 14:04

. / dirdat/sa000000 2015-05-13 09:12 First Record

. / dirdat/sa000000 2015-05-13 09:12 2015-05-13 09:12

. / dirdat/sa000000 2015-05-13 09:12 First Record

. / dirdat/sa000000 * Initialized * 2015-05-13 09:12

. / dirdat/sa000000 * Initialized * First Record

Current directory / data0/temp/ogg

Report file / data0/temp/ogg/dirrpt/REPDR.rpt

Parameter file / data0/temp/ogg/dirprm/repdr.prm

Checkpoint file / data0/temp/ogg/dirchk/REPDR.cpr

Checkpoint table urogg.checktable

Process file / data0/temp/ogg/dirpcs/REPDR.pcr

Stdout file / data0/temp/ogg/dirout/REPDR.out

Error log / data0/temp/ogg/ggserr.log

GGSCI (dkdb_ogg) 17 >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.