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

Note: Oracle DG (master-> slave 1-> slave 2) cascade mode

Main library: 10.118.242.216 sid_name=sfpay2 standby 1: 10.118.242.215 sid_name=sfpay2 = > ogg main library ogg library 1: 10.118.230.27 sid_name=sfpay3 = > ogg standby 1 ogg library 2: 10.118.242.214 sid_name=sfpay1 = > ogg standby 2

Ogg mode: one capture process, multiple pump processes (one-to-many mode)

When ogg has multiple instances in one database, configure the setenv parameters (oracle_sid,nls_lang, oracle_home) and remember that the tnsname.ora corresponds well. Note the time zone on the ogg source side and the target side.

There is no need to do checkpoint on the ogg extract side, and the slave database can only do DML ogg synchronization, which is not supported by DDL.

-Database Language and Character Set: NLS_LANG = "AMERICAN_AMERICA.AL32UTF8" NLS_LANGUAGE = "AMERICAN" NLS_TERRITORY = "AMERICA" NLS_CHARACTERSET = "AL32UTF8"

SourceContext: SourceModule: [er.redo.ora] SourceID: [/ scratch/aime1/adestore/views/aime1_adc4150256/oggcore/OpenSys/src/app/er/redo/oracl e/redoora.c] SourceFunction: [REDO_validate_config] SourceLine: [5980] ThreadBacktrace: [12] elements: [/ data/gg11.2/libgglog.so (CMessageContext::AddThreadContext () + 0x1e) [0x7f9bedb5ad2e]]: [/ data/gg11.2/libgglog.so (CMessageFactory::CreateMessage (CSourceContext*, unsigned in t) ) + 0x2ec) [0x7f9bedb5388c]]: [/ data/gg11.2/libgglog.so (_ MSG_ERR_DDL_STANDBY_NOT_SUPPORTED (CSourceContext*, CMessag eFactory::MessageDisposition) + 0x2c) [0x7f9bedb43e16]]: [/ data/gg11.2/extract (REDO_validate_config (int, unsigned int*) Int*) + 0xdc9) [0x6a4ab9]]: [/ data/gg11.2/extract (redo_log_setup () + 0x34) [0x57abf4]]: [/ data/gg11.2/extract (extract_main (int)) Char**) + 0x3bf) [0x57e0ef]]: [/ data/gg11.2/extract (ggs::gglib::MultiThreading::MainThread::ExecMain () + 0x4f) [0x633 09f]]: [/ data/gg11.2/extract (ggs::gglib::MultiThreading::Thread::RunThread (ggs::gglib::MultiThreading::Thread:: ThreadArgs*) + 0x104) [0x6332f4]]: [/ data/gg11.2/extract (ggs::gglib::MultiThreading::MainThread::Run (int) Char**) + 0x8b) [0x6333fb]]: [/ data/gg11.2/extract (main+0x2c) [0x57dc5c]]: [/ lib64/libc.so.6 (_ _ libc_start_main+0xfd) [0x383e61ed5d]]: [/ data/gg11.2/extract (_ gxx_personality_v0+0x3b2) [0x4f64aa]]

2015-11-25 11:33:05 ERROR OGG-00520 DDL replication is not supported for standby databases.

2015-11-25 11:33:05 ERROR OGG-01668 PROCESS ABENDING. -

Test results: all the data initial words on the source side (DG slave 1) are subject to the DG main database (scn, data export). The ogg operation on the source side (DG slave 1) requires the execution of ogg scripts and trandata log on the DG main library. Parameters can be ignored.

1: the main library executes ogg script 2: log out all ddl methods because standby database does not support the DDL mode of ogg. 3: on the ogg source side, dg slave library 1 may be in disabled status when info trandata schema.*, but the DG master library enable is fine. GGSCI (sfpay.datatest.mysql02) 40 > info trandata dm_ord.*

Logging of supplemental redo log data is disabled for table DM_ORD.TEMP_20151105_T.

4: parameters of source end:

GGSCI (sfpay.datatest.mysql02) 46 > dblogin userid ogg@ogg Password: Successfully logged into database.

GGSCI (sfpay.datatest.mysql02) 49 > view params mgr

Port 7809 dynamicportlist 7810-7900 userid ogg@ogg,password ogg autorestart extract *, waitminutes 2 retries 7 lagreporthours 1 laginfominutes 30 lagcriticalminutes 45 purgeoldextracts. / dirdat/*,usecheckpoints,minkeepdays 5 purgeddlhistory minkeepdays 3 maxkeepdays 5 PURGEMARKERHISTORY MINKEEPDAYS 20 PURGEMARKERHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 5, FREQUENCYMINUTES 20

GGSCI (sfpay.datatest.mysql02) 50 > view params exp001

Extract exp001 setenv (ORACLE_HOME= "/ u01/app/oracle/product/11.2.0.4/dbhome_1") setenv (NLS_LANG= "AMERICAN_AMERICA.AL32UTF8") dynamicresolution gettruncates numfiles 5000 userid ogg@ogg,password ogg tranlogoptions convertucs2clobs TRANLOGOPTIONS LOGRETENTION DISABLED TRANLOGOPTIONS DBLOGREADER tranlogoptions altarchivelogdest primary instance sfpay2 / data/archivelog-- TRANLOGOPTIONS ASMUSER sys@ASM,ASMPASSWORD oracle123-- THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 20000 reportcount every 2 minutes,rate discardfile. / dirrpt/exp001.dsc,append,megabytes 1000 warnlongtrans 3m exttrail. / dirdat/p1-- ddl include all-- ddloptions addtrandata Report-add test table dm_sypay.* Table dm_ord.*

GGSCI (sfpay.datatest.mysql02) 51 > view params pump214

Extract pump214 passthru report at 02:00 reportrollover at 02:10 rmthost 10.118.242.214 rmthost Mgrport 7809 rmttrail. / dirdat/t1 dynamicresolution numfiles 2000-- add tables table dm_sypay.*; table dm_ord.*

GGSCI (sfpay.datatest.mysql02) 52 > view params pump01

Extract pump01 setenv (ORACLE_SID= "sfpay3") passthru report at 02:00 reportrollover at 02:10 rmthost 10.118.230.27 extract pump01 setenv Mgrport 7809 rmttrail. / dirdat/e1 dynamicresolution numfiles 2000-- add tables table dm_sypay.*; table dm_ord.*

GGSCI (sfpay.datatest.mysql02) 53 > info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING EXTRACT RUNNING EXP001 00:00:00 unknown EXTRACT RUNNING PUMP01 00:00:00 00:00:09 EXTRACT RUNNING PUMP214 00:00:00 00:00:09

Add capture extract process group on source: GGSCI > add extract exp001, tranlog, begin now-- (, threads 2)-- add process group GGSCI > add exttrail. / dirdat/p1, extract exp001, megabytes 500-add local exttrial file.

Add pump process group and target exttrail file to source:

-- before starting, configure the target parameters and start the mgr process--

GGSCI > add extract pump214, exttrailsource. / dirdat/p1, begin now-- add pump process group GGSCI > add rmttrail. / dirdat/t1, extract pump214, megabytes 500-- add remote trail file

GGSCI > add extract pump01, exttrailsource. / dirdat/p1, begin now-- add pump process group GGSCI > add rmttrail. / dirdat/e1, extract pump01, megabytes 500-- add remote trail file

5. Rep214 on target:

GGSCI (sfpay-asmtest) 18 > view params. / GLOBALS

GGSCHEMA OGG CHECKPOINTTABLE OGG.CHECKPOINT

GGSCI (sfpay-asmtest) 19 > view params mgr

Port 7809 dynamicportlist 7810-7900 userid ogg@ogg,password ogg autorestart extract *, waitminutes 2 retries 7 lagreporthours 1 laginfominutes 30 lagcriticalminutes 45 purgeoldextracts. / dirdat/*,usecheckpoints,minkeepdays 5 purgeddlhistory minkeepdays 3 maxkeepdays 5 PURGEMARKERHISTORY MINKEEPDAYS 20 PURGEMARKERHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 5, FREQUENCYMINUTES 20

GGSCI (sfpay-asmtest) 20 > view params rep214

REPLICAT rep214 SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8) USERID ogg@ogg, PASSWORD ogg DISCARDFILE. / dirrpt/rep214.dsc, PURGE, MAXBYTES 104857600 sqlexec "Alter session set constraints=deferred" REPORT AT 01:59 reportrollover at 02:00-handlecollisions reperror default,abend REPORTCOUNT EVERY 30 MINUTES, RATE DDL INCLUDE MAPPED, EXCLUDE INSTR 'SHRINK SPACE' ddloptions report assumetargetdefs checksequencevalue allownoopupdates dynamicresolution numfiles 2000-ERROR IGNORE DDLERROR 10636 IGNORE-20151028 add MAP dm_sypay.*, TARGET dm_sypay.*; MAP dm_ord.*,TARGET dm_ord.*; pump01 similarly, skip.

6. Data initialization expdp through flshback_scn, DG main library.

7. Launch on target: GGSC > add replicat rep214, exttrail. / dirdat/e1, begin now GGSCI > start replicat, aftercsn 6553589

8, test:

9, complete.

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.