New Features for DBA’s

Subscribe to Posts by Email


 

Subscriber Count

    701

Disclaimer

All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

Pages

Example 1: GoldenGate Setup & Configuration

On Source & Target Hosts Perform the Following

############################################################

On Source: Unzip the GG Software and Perform the installation & Configuration

###############################################################

[oracle@sourcehost]/data # 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@sourcehost]/data # tar -xvf ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip

[oracle@sourcehost]/data/ggate # ./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.

## Create Directories

GGSCI (sourcehost) 1> create subdirs

Creating subdirectories under current directory /data/ggate

Parameter files                /data/ggate/dirprm: already exists

Report files                   /data/ggate/dirrpt: created

Checkpoint files               /data/ggate/dirchk: created

Process status files           /data/ggate/dirpcs: created

SQL script files               /data/ggate/dirsql: created

Database definitions files     /data/ggate/dirdef: created

Extract data files             /data/ggate/dirdat: created

Temporary files                /data/ggate/dirtmp: created

Stdout files                   /data/ggate/dirout: created

GGSCI (targethost) 2>

#############################################################################

On Target: Unzip the GG Software and Perform the installation & Configuration

##############################################################################

[oracle@targethost]/data # 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@targethost]/data # tar -xvf ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip

[oracle@sourcehost]/data/ggate # ./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 (targethost) 1> create subdirs

Creating subdirectories under current directory /data/ggate

Parameter files                /data/ggate/dirprm: already exists

Report files                   /data/ggate/dirrpt: created

Checkpoint files               /data/ggate/dirchk: created

Process status files           /data/ggate/dirpcs: created

SQL script files               /data/ggate/dirsql: created

Database definitions files     /data/ggate/dirdef: created

Extract data files             /data/ggate/dirdat: created

Temporary files                /data/ggate/dirtmp: created

Stdout files                   /data/ggate/dirout: created

GGSCI (targethost) 2>

############################################################

On Source & Target: Prepare Source Database for GG Replication 

###############################################################

1. Ensure The database is in archive log mode

2. Create Necessary tablespace and goldengate user in database

SQL> create tablespace ggs_data datafile '/data/GGS/Base/ggs_data01.dbf' size 200m;

SQL> create user ggs_owner identified by ggs_owner default tablespace ggs_data temporary tablespace temp;

SQL> grant connect,resource to ggs_owner;

SQL> grant select any dictionary, select any table to ggs_owner;

SQL> grant create table to ggs_owner;

SQL> grant flashback any table to ggs_owner;

SQL> grant execute on dbms_flashback to ggs_owner;

SQL> grant execute on utl_file to ggs_owner;

SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;

SQL> alter session set recyclebin=OFF;

SQL> exec dbms_goldengate_auth.grant_admin_privilege('GGS_OWNER');

SQL> grant select any dictionary to GGS_OWNER;

SQL> grant insert any table to GGS_OWNER;

SQL> grant update any table to GGS_OWNER;

 

SQL> grant delete any table to GGS_OWNER;

Also Configure DDL Replication, Run the following scripts from goldengate software directory

@marker_setup

@ddl_setup

@role_setup

grant ggs_ggsuser_role to ggs_owner;

@ddl_enable

@ddl_pin GGS_OWNER