Oracle ogg11 installation configuration document 04/06 Update SLTechnology News&Howtos

Oracle ogg11 installation configuration document

2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

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

one。 Initialize the database with RMAN:

Configure the parameter file of the target database:

OGG1.__db_cache_size=318767104

OGG1.__java_pool_size=4194304

OGG1.__large_pool_size=16777216

OGG1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

OGG1.__pga_aggregate_target=293601280

OGG1.__sga_target=545259520

OGG1.__shared_io_pool_size=0

OGG1.__shared_pool_size=192937984

OGG1.__streams_pool_size=0

*. _ optimizer_ignore_hints=FALSE

* .audit_file_dest='/u01/app/oracle/admin/OGG1/adump'

* .audit_trail='db'

* .compatible='11.2.0.4.0'

* .control_files='+DATA1/ogg1/controlfile/control01.dbf','+DATA1/ogg1/controlfile/control02.dbf'#Restore Controlfile

* .db_block_size=8192

* .DB_FILE_NAME_CONVERT='+DATA/phub/datafile/','+DATA1/ogg1/datafile'

* .LOG_FILE_NAME_CONVERT='+DATA/phub/onlinelog/','+DATA1/ogg1/onlinelog/'

* .db_create_file_dest='+DATA1'

* .db_domain=''

* .db_flashback_retention_target=120

* .db_name='OGG1'

* .db_recovery_file_dest='+DATA1'

* .db_recovery_file_dest_size=10737418240

* .DB_UNIQUE_NAME='OGG1'

* .diagnostic_dest='/u01/app/oracle'

* .dispatchers=' (PROTOCOL=TCP) (SERVICE=OGG1XDB)'

* .memory_target=838860800

* .open_cursors=300

* .processes=150

* .remote_login_passwordfile='EXCLUSIVE'

* .undo_tablespace='UNDOTBS1'

[oracle@cwogg admin] $rman target sys/123123@PHUB auxiliary sys/123123@OGG1 nocatalog

Recovery Manager: Release 11.2.0.4.0-Production on Mon Oct 26 16:53:15 2015

Connected to target database: PHUB (DBID=536511065)

Using target database control file instead of recovery catalog

Connected to auxiliary database: OGG1 (not mounted)

RMAN > duplicate target database to OGG1 from active database nofilenamecheck

Starting Duplicate Db at 26-OCT-15

Allocated channel: ORA_AUX_DISK_1

Channel ORA_AUX_DISK_1: SID=131 device type=DISK

Allocated channel: ORA_AUX_DISK_2

Channel ORA_AUX_DISK_2: SID=192 device type=DISK

Contents of Memory Script:

{

Sql clone "create spfile from memory"

}

Executing Memory Script

Sql statement: create spfile from memory

Contents of Memory Script:

{

Shutdown clone immediate

Startup clone nomount

}

Executing Memory Script

Oracle instance shut down

Connected to auxiliary database (not started)

Oracle instance started

Total System Global Area 835104768 bytes

Fixed Size 2257840 bytes

Variable Size 511708240 bytes

Database Buffers 314572800 bytes

Redo Buffers 6565888 bytes

Contents of Memory Script:

{

Sql clone "alter system set db_name =

'' PHUB'' comment=

'' Modified by RMAN duplicate'' scope=spfile''

Sql clone "alter system set db_unique_name =

'' OGG1'' comment=

'' Modified by RMAN duplicate'' scope=spfile''

Shutdown clone immediate

Startup clone force nomount

Backup as copy current controlfile auxiliary format'+ DATA1/ogg1/controlfile/control01.dbf'

Restore clone controlfile to'+ DATA1/ogg1/controlfile/control02.dbf' from

'+ DATA1/ogg1/controlfile/control01.dbf'

Alter clone database mount

}

Executing Memory Script

Sql statement: alter system set db_name =''PHUB'' comment=' 'Modified by RMAN duplicate'' scope=spfile

Sql statement: alter system set db_unique_name =''OGG1'' comment=' 'Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area 835104768 bytes

Fixed Size 2257840 bytes

Variable Size 511708240 bytes

Database Buffers 314572800 bytes

Redo Buffers 6565888 bytes

Starting backup at 26-OCT-15

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: SID=398 device type=DISK

Allocated channel: ORA_DISK_2

Channel ORA_DISK_2: SID=25 device type=DISK

Channel ORA_DISK_1: starting datafile copy

Copying current control file

Output file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_PHUB.f tag=TAG20151026T165351 RECID=13 STAMP=894128033

Channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03

Finished backup at 26-OCT-15

Starting restore at 26-OCT-15

Allocated channel: ORA_AUX_DISK_1

Channel ORA_AUX_DISK_1: SID=69 device type=DISK

Allocated channel: ORA_AUX_DISK_2

Channel ORA_AUX_DISK_2: SID=131 device type=DISK

Channel ORA_AUX_DISK_2: skipped, AUTOBACKUP already found

Channel ORA_AUX_DISK_1: copied control file copy

Finished restore at 26-OCT-15

Database mounted

RMAN-05529: WARNING: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to disk group only.

Contents of Memory Script:

{

Set newname for datafile 1 to

"+ data1"

Set newname for datafile 2 to

"+ data1"

Set newname for datafile 3 to

"+ data1"

Set newname for datafile 4 to

"+ data1"

Set newname for datafile 5 to

"+ data1"

Set newname for datafile 6 to

"+ DATA1/ogg1/datafilellc01.dbf"

Set newname for datafile 7 to

"+ DATA1/ogg1/datafileidx01.dbf"

Backup as copy reuse

Datafile 1 auxiliary format

"+ data1" datafile

2 auxiliary format

"+ data1" datafile

3 auxiliary format

"+ data1" datafile

4 auxiliary format

"+ data1" datafile

5 auxiliary format

"+ data1" datafile

6 auxiliary format

"+ DATA1/ogg1/datafilellc01.dbf" datafile

7 auxiliary format

"+ DATA1/ogg1/datafileidx01.dbf"

Sql 'alter system archive log current'

}

Executing Memory Script

Executing command: SET NEWNAME

Starting backup at 26-OCT-15

Using channel ORA_DISK_1

Using channel ORA_DISK_2

Channel ORA_DISK_1: starting datafile copy

Input datafile file number=00006 name=+DATA/phub/datafile/llc01.dbf

Channel ORA_DISK_2: starting datafile copy

Input datafile file number=00002 name=+DATA/phub/datafile/sysaux.272.891340857

Output file name=+DATA1/ogg1/datafilellc01.dbf tag=TAG20151026T165410

Channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:15

Channel ORA_DISK_1: starting datafile copy

Input datafile file number=00007 name=+DATA/phub/datafile/idx01.dbf

Output file name=+DATA1/ogg1/datafile/sysaux.261.894128051 tag=TAG20151026T165410

Channel ORA_DISK_2: datafile copy complete, elapsed time: 00:04:21

Channel ORA_DISK_2: starting datafile copy

Input datafile file number=00001 name=+DATA/phub/datafile/system.271.891340857

Output file name=+DATA1/ogg1/datafileidx01.dbf tag=TAG20151026T165410

Channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:30

Channel ORA_DISK_1: starting datafile copy

Input datafile file number=00004 name=+DATA/phub/datafile/users.269.891340843

Output file name=+DATA1/ogg1/datafile/system.259.894128311 tag=TAG20151026T165410

Channel ORA_DISK_2: datafile copy complete, elapsed time: 00:02:40

Channel ORA_DISK_2: starting datafile copy

Input datafile file number=00005 name=+DATA/phub/datafile/example.287.891340843

Output file name=+DATA1/ogg1/datafile/users.258.894128337 tag=TAG20151026T165410

Channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:23

Channel ORA_DISK_1: starting datafile copy

Input datafile file number=00003 name=+DATA/phub/datafile/undotbs1.260.891340857

Output file name=+DATA1/ogg1/datafile/undotbs1.264.894128479 tag=TAG20151026T165410

Channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35

Output file name=+DATA1/ogg1/datafile/example.263.894128473 tag=TAG20151026T165410

Channel ORA_DISK_2: datafile copy complete, elapsed time: 00:01:02

Finished backup at 26-OCT-15

Sql statement: alter system archive log current

Contents of Memory Script:

{

Backup as copy reuse

Archivelog like "+ DATA/phub/archivelog/2015_10_26/thread_1_seq_398.284.894128537" auxiliary format

"+ DATA1"

Catalog clone start with "+ DATA1"

Switch clone datafile all

}

Executing Memory Script

Starting backup at 26-OCT-15

Using channel ORA_DISK_1

Using channel ORA_DISK_2

Channel ORA_DISK_1: starting archived log copy

Input archived log thread=1 sequence=398 RECID=784 STAMP=894128536

Output file name=+DATA1/ogg1/archivelog/2015_10_26/thread_1_seq_398.265.894128539 RECID=0 STAMP=0

Channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01

Finished backup at 26-OCT-15

Searching for all files that match the pattern + DATA1

List of Files Unknown to the Database

= =

File Name: + data1/OGG1/datafilellc01.dbf

File Name: + data1/OGG1/datafileidx01.dbf

File Name: + data1/OGG1/ARCHIVELOG/2015_10_26/thread_1_seq_398.265.894128539

File Name: + data1/OGG1/datafile/SYSAUX.261.894128051

File Name: + data1/OGG1/datafile/SYSTEM.259.894128311

File Name: + data1/OGG1/datafile/USERS.258.894128337

File Name: + data1/OGG1/datafile/EXAMPLE.263.894128473

File Name: + data1/OGG1/datafile/UNDOTBS1.264.894128479

File Name: + data1/ASM/ASMPARAMETERFILE/REGISTRY.253.894123127

Cataloging files...

Cataloging done

List of Cataloged Files

File Name: + data1/OGG1/datafilellc01.dbf

File Name: + data1/OGG1/datafileidx01.dbf

File Name: + data1/OGG1/ARCHIVELOG/2015_10_26/thread_1_seq_398.265.894128539

File Name: + data1/OGG1/datafile/SYSAUX.261.894128051

File Name: + data1/OGG1/datafile/SYSTEM.259.894128311

File Name: + data1/OGG1/datafile/USERS.258.894128337

File Name: + data1/OGG1/datafile/EXAMPLE.263.894128473

File Name: + data1/OGG1/datafile/UNDOTBS1.264.894128479

List of Files Which Where Not Cataloged

= =

File Name: + data1/ASM/ASMPARAMETERFILE/REGISTRY.253.894123127

RMAN-07518: Reason: Foreign database file DBID: 0 Database Name:

Datafile 1 switched to datafile copy

Input datafile copy RECID=20 STAMP=894128541 file name=+DATA1/ogg1/datafile/system.259.894128311

Datafile 2 switched to datafile copy

Input datafile copy RECID=21 STAMP=894128542 file name=+DATA1/ogg1/datafile/sysaux.261.894128051

Datafile 3 switched to datafile copy

Input datafile copy RECID=22 STAMP=894128542 file name=+DATA1/ogg1/datafile/undotbs1.264.894128479

Datafile 4 switched to datafile copy

Input datafile copy RECID=23 STAMP=894128542 file name=+DATA1/ogg1/datafile/users.258.894128337

Datafile 5 switched to datafile copy

Input datafile copy RECID=24 STAMP=894128542 file name=+DATA1/ogg1/datafile/example.263.894128473

Datafile 6 switched to datafile copy

Input datafile copy RECID=25 STAMP=894128542 file name=+DATA1/ogg1/datafilellc01.dbf

Datafile 7 switched to datafile copy

Input datafile copy RECID=26 STAMP=894128543 file name=+DATA1/ogg1/datafileidx01.dbf

Contents of Memory Script:

{

Set until scn 6109815

Recover

Clone database

Delete archivelog

}

Executing Memory Script

Executing command: SET until clause

Starting recover at 26-OCT-15

Using channel ORA_AUX_DISK_1

Using channel ORA_AUX_DISK_2

Starting media recovery

Archived log for thread 1 with sequence 398 is already on disk as file + DATA1/ogg1/archivelog/2015_10_26/thread_1_seq_398.265.894128539

Archived log file name=+DATA1/ogg1/archivelog/2015_10_26/thread_1_seq_398.265.894128539 thread=1 sequence=398

Media recovery complete, elapsed time: 00:00:02

Finished recover at 26-OCT-15

Oracle instance started

Total System Global Area 835104768 bytes

Fixed Size 2257840 bytes

Variable Size 511708240 bytes

Database Buffers 314572800 bytes

Redo Buffers 6565888 bytes

Contents of Memory Script:

{

Sql clone "alter system set db_name =

'' OGG1'' comment=

'' Reset to original value by RMAN'' scope=spfile''

Sql clone "alter system reset db_unique_name scope=spfile"

Shutdown clone immediate

Startup clone nomount

}

Executing Memory Script

Sql statement: alter system set db_name =''OGG1'' comment=' 'Reset to original value by RMAN'' scope=spfile

Sql statement: alter system reset db_unique_name scope=spfile

Oracle instance shut down

Connected to auxiliary database (not started)

Oracle instance started

Total System Global Area 835104768 bytes

Fixed Size 2257840 bytes

Variable Size 511708240 bytes

Database Buffers 314572800 bytes

Redo Buffers 6565888 bytes

Sql statement: CREATE CONTROLFILE REUSE SET DATABASE "OGG1" RESETLOGS ARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 292

LOGFILE

GROUP 1 ('+ data1','+ data1') SIZE 50 M REUSE

GROUP 2 ('+ data1','+ data1') SIZE 50 M REUSE

GROUP 3 ('+ data1','+ data1') SIZE 50 M REUSE

DATAFILE

'+ DATA1/ogg1/datafile/system.259.894128311'

CHARACTER SET AL32UTF8

Contents of Memory Script:

{

Set newname for tempfile 1 to

"+ data"

Set newname for tempfile 2 to

"+ DATA/phub/tempfile/tmp01.dbf"

Switch clone tempfile all

Catalog clone datafilecopy "+ DATA1/ogg1/datafile/sysaux.261.894128051"

"+ DATA1/ogg1/datafile/undotbs1.264.894128479"

"+ DATA1/ogg1/datafile/users.258.894128337"

"+ DATA1/ogg1/datafile/example.263.894128473"

"+ DATA1/ogg1/datafilellc01.dbf"

"+ DATA1/ogg1/datafileidx01.dbf"

Switch clone datafile all

}

Executing Memory Script

Executing command: SET NEWNAME

Renamed tempfile 1 to + data in control file

Renamed tempfile 2 to + DATA/phub/tempfile/tmp01.dbf in control file

Cataloged datafile copy

Datafile copy file name=+DATA1/ogg1/datafile/sysaux.261.894128051 RECID=1 STAMP=894128569

Cataloged datafile copy

Datafile copy file name=+DATA1/ogg1/datafile/undotbs1.264.894128479 RECID=2 STAMP=894128569

Cataloged datafile copy

Datafile copy file name=+DATA1/ogg1/datafile/users.258.894128337 RECID=3 STAMP=894128569

Cataloged datafile copy

Datafile copy file name=+DATA1/ogg1/datafile/example.263.894128473 RECID=4 STAMP=894128569

Cataloged datafile copy

Datafile copy file name=+DATA1/ogg1/datafilellc01.dbf RECID=5 STAMP=894128569

Cataloged datafile copy

Datafile copy file name=+DATA1/ogg1/datafileidx01.dbf RECID=6 STAMP=894128569

Datafile 2 switched to datafile copy

Input datafile copy RECID=1 STAMP=894128569 file name=+DATA1/ogg1/datafile/sysaux.261.894128051

Datafile 3 switched to datafile copy

Input datafile copy RECID=2 STAMP=894128569 file name=+DATA1/ogg1/datafile/undotbs1.264.894128479

Datafile 4 switched to datafile copy

Input datafile copy RECID=3 STAMP=894128569 file name=+DATA1/ogg1/datafile/users.258.894128337

Datafile 5 switched to datafile copy

Input datafile copy RECID=4 STAMP=894128569 file name=+DATA1/ogg1/datafile/example.263.894128473

Datafile 6 switched to datafile copy

Input datafile copy RECID=5 STAMP=894128569 file name=+DATA1/ogg1/datafilellc01.dbf

Datafile 7 switched to datafile copy

Input datafile copy RECID=6 STAMP=894128569 file name=+DATA1/ogg1/datafileidx01.dbf

Contents of Memory Script:

{

Alter clone database open resetlogs

}

Executing Memory Script

Database opened

Finished Duplicate Db at 26-OCT-15

Be sure to deal with temporary tablespaces:

SQL > alter database tempfile'+ DATA/phub/tempfile/tmp01.dbf' drop

Database altered.

SQL > alter tablespace temp add tempfile'+ DATA1/ogg1/tempfile/tmp01.dbf' size 1024M

Tablespace altered.

[oracle@ogg1 ~] $srvctl status listener-l listener

Listener LISTENER is enabled

Listener LISTENER is running on node (s): ogg1

[oracle@ogg1] $srvctl add database-d OGG1-o / u01/app/oracle/product/11.2.0/db_1/

[oracle@ogg1] $srvctl status database-d OGG1

Database is not running.

[oracle@ogg1] $srvctl start database-d OGG1

[oracle@ogg1] $srvctl status database-d OGG1

Database is running.

[oracle@ogg1 ~] $su-grid

Password:

[grid@ogg1] $crsctl stat res-t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

Ora.DATA1.dg

ONLINE ONLINE ogg1

Ora.LISTENER.lsnr

ONLINE ONLINE ogg1

Ora.asm

ONLINE ONLINE ogg1 Started

Ora.ons

OFFLINE OFFLINE ogg1

Cluster Resources

Ora.cssd

1 ONLINE ONLINE ogg1

Ora.diskmon

1 OFFLINE OFFLINE

Ora.evmd

1 ONLINE ONLINE ogg1

Ora.ogg1.db

1 ONLINE ONLINE ogg1 Open

The following actions are performed in both the source and target libraries:

Install GoldenGate softwar

[oracle@cwogg] $mkdir-p / u01/ogg/

[oracle@cwogg U01] $cd ogg/

[oracle@cwogg ogg] $ls

Ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip

[oracle@cwogg ogg] $unzip ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip

Archive: ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip

Inflating: fbo_ggs_Linux_x64_ora11g_64bit.tar

Inflating: OGG_WinUnix_Rel_Notes_11.2.1.0.1.pdf

Inflating: Oracle GoldenGate 11.2.1.0.1 README.txt

Inflating: Oracle GoldenGate 11.2.1.0.1 README.doc

[oracle@cwogg ogg] $tar-xvf fbo_ggs_Linux_x64_ora11g_64bit.tar

Configure environment variables:

Export PATH=/u01/ogg:$PATH

Export LD_LIBRARY_PATH=/u01/ogg:$LD_LIBRARY_PATH

Export GGATE=/u01/ogg

Create an ogg directory:

GGSCI (cwogg) 1 > create subdirs

Creating subdirectories under current directory / u01/ogg

Parameter files / u01/ogg/dirprm: already exists

Report files / u01/ogg/dirrpt: created

Checkpoint files / u01/ogg/dirchk: created

Process status files / u01/ogg/dirpcs: created

SQL script files / u01/ogg/dirsql: created

Database definitions files / u01/ogg/dirdef: created

Extract data files / u01/ogg/dirdat: created

Temporary files / u01/ogg/dirtmp: created

Stdout files / u01/ogg/dirout: created

Check data archiving mode, attach logs, force logs

SQL > shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL > startup mount

ORACLE instance started.

Total System Global Area 835104768 bytes

Fixed Size 2257840 bytes

Variable Size 662703184 bytes

Database Buffers 163577856 bytes

Redo Buffers 6565888 bytes

Database mounted.

SQL > alter database force logging

Database altered.

SQL > alter database add supplemental log data

Database altered.

SQL > alter database archivelog

Database altered.

SQL > alter database open

Database altered.

SQL > select log_mode,supplemental_log_data_min,force_logging from v$database

LOG_MODE SUPPLEME FOR

ARCHIVELOG YES YES

Create a user to store DDL information and empower it

SQL > create user ogg identified by ogg default tablespace users temporary tablespace temp

User created.

SQL > grant connect,resource to ogg

Grant succeeded.

SQL > grant execute on utl_file to ogg

Grant succeeded.

SQL > grant create table,create sequence to ogg

Grant succeeded.

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:ogg

Marker setup table script complete, running verification script...

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

Setting schema name to OGG

MARKER TABLE

MARKER SEQUENCE

Script complete.

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:ogg

Working, please wait...

Spooling to file ddl_setup_spool.txt

Checking for sessions that are holding locks on Oracle Golden Gate metadata tables...

Check complete.

Using OGG as an Oracle GoldenGate schema name.

Working, please wait...

DDL replication setup script complete, running verification script...

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

Setting schema name to OGG

CLEAR_TRACE STATUS:

Line/pos Error

No errors No errors

CREATE_TRACE STATUS:

Line/pos Error

No errors No errors

TRACE_PUT_LINE STATUS:

Line/pos Error

No errors No errors

INITIAL_SETUP STATUS:

Line/pos Error

No errors No errors

DDLVERSIONSPECIFIC PACKAGE STATUS:

Line/pos Error

No errors No errors

DDLREPLICATION PACKAGE STATUS:

Line/pos Error

No errors No errors

DDLREPLICATION PACKAGE BODY STATUS:

Line/pos Error

No errors No errors

DDL IGNORE TABLE

DDL IGNORE LOG TABLE

DDLAUXPACKAGE STATUS:

Line/pos Error

No errors No errors

DDLAUX PACKAGE BODY STATUS:

Line/pos Error

No errors No errors

SYS.DDLCTXINFOPACKAGE STATUS:

Line/pos Error

No errors No errors

SYS.DDLCTXINFOPACKAGE BODY STATUS:

Line/pos Error

No errors No errors

DDL HISTORY TABLE

DDL HISTORY TABLE (1)

DDL DUMP TABLES

DDL DUMP COLUMNS

DDL DUMP LOG GROUPS

DDL DUMP PARTITIONS

DDL DUMP PRIMARY KEYS

DDL SEQUENCE

GGS_TEMP_COLS

GGS_TEMP_UK

DDL TRIGGER CODE STATUS:

Line/pos Error

No errors No errors

DDL TRIGGER INSTALL STATUS

DDL TRIGGER RUNNING STATUS

ENABLED

STAYMETADATA IN TRIGGER

OFF

DDL TRIGGER SQL TRACING

DDL TRIGGER TRACE LEVEL

LOCATION OF DDL TRACE FILE

/ u01/app/oracle/diag/rdbms/phub/PHUB/trace/ggs_ddl_trace.log

Analyzing installation status...

STATUS OF DDL REPLICATION

SUCCESSFUL installation of DDL Replication software components

Script complete.

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:ogg

Wrote file role_setup_set.txt

PL/SQL procedure successfully completed.

Role setup script complete

Grant this role to each user assigned to the Extract, GGSCI, and Manager processes, by using the following SQL command:

GRANT GGS_GGSUSER_ROLE TO

Where is the user assigned to the GoldenGate processes.

SQL > grant GGS_GGSUSER_ROLE to ogg

Grant succeeded.

SQL > @ ddl_enable.sql

Trigger altered.

Test goldengate

3.1 configure Manager on Source and Target

GGSCI (cwogg) 6 > view params mgr

Port 7500

Dynamicportlist 7500-7505

Autorestart extract *, waitminutes 2, retries 5

GGSCI (cwogg) 3 > start mgr

Manager started.

GGSCI (cwogg) 4 > info mgr

Manager is running (IP port cwogg.7500).

3.2Configuring replication queues for SourceDB (ASM management)

GGSCI (cwogg) 2 > view params ext1

Extract ext1

Setenv (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)

Userid ogg,password ogg

Rmthost 172.16.30.226, mgrport 7500

Rmttrail / u01/ogg/dirdat/ht

(TRANLOGOPTIONS ASMUSER SYS@ASM,ASMPASSWORD 123123

TRANLOGOPTIONS ALTARCHIVELOGDEST primary instance PHUB + DATA/phub/archivelog/) is equivalent to the following parameters, in version 11.2.0.4

TRANLOGOPTIONS DBLOGREADER

Ddl include mapped objname scott.*

Table scott.*

Increase extraction:

GGSCI (orcl1) 20 > add extract ext1,tranlog, begin now

GGSCI (orcl1) 20 > add exttrail / u01/ogg/dirdat/lt, extract ext1

3.4 configure TargetDB synchronization queues

3.4.1 add checkpoint table on the Target side:

GGSCI (ogg1) 1 > edit params. / GLOBALS

CHECKPOINTTABLE ogg.CKPT_TABLE

GGSCI (ogg1) 2 > dblogin userid ogg,password ogg

Successfully logged into database.

Note that this user was created by enabling DDL in the Source library, and I also created this user in the Target library.

GGSCI (ogg1) 3 > add checkpointtable ogg.CKPT_TABLE

Successfully created checkpoint table ogg.CKPT_TABLE.

3.4.2 create a synchronization queue

GGSCI (ogg1) 8 > view params rep1

Replicat rep1

Setenv (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)

ASSUMETARGETDEFS

Userid ogg,password ogg

Discardfile / u01/ogg/dirdat/rep1_discard.txt,append, megabytes 10

DDL

Map scott.*, target scott.*

GGSCI (ogg1) 31 > add replicat rep1,exttrail / u01/ogg/dirdat/ht, checkpointtable ogg.CKPT_TABLE

REPLICAT added.

Verify dml synchronization: (source library)

SQL > select count (*) from t_emp

COUNT (*)

twenty-eight

SQL > insert into t_emp select * from t_emp

28 rows created.

SQL > commit

Commit complete.

The target library has been synchronized:

SQL > select count (*) from t_emp

COUNT (*)

fifty-six

DDL synchronization:

SQL > drop table tasking emptiness; (source database)

Table dropped.

SQL > desc t_emp

ERROR:

ORA-04043: object t_emp does not exist

Target Library:

SQL > desc t_emp

ERROR:

ORA-04043: object t_emp does not exist

Log information:

2015-10-27 15:27:24 INFO OGG-01407 Setting current schema for DDL operation to [SYS].

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.

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.