Amazon books

Wednesday, March 3, 2010

Some GoldenGate Tips

Here is a review of some commands used to install and administer Oracle Golden Gate on Unix.

##############################################################
--GG Installations

--GG Command line
./ggsci

--Create directories
CREATE SUBDIRS

--Add Manager default port
EDIT PARAMS MGR
--insert port value 7809 and save

--Change recyclebin initialization parameters to off
alter system set recyclebin=off scope=spfile;
shutdown immediate
startup

--Login / as sysdba and run the following script
SQL>@marker_setup.sql
SQL>@ddl_setup.sql (Specify schema, INITIALSETUP (for first installation),YES to purge recyclebin)
SQL>@role_setup.sql

--Grant the GG role to Extract users
SQL>GRANT GGS_GGSUSER_ROLE TO GG;

--Enable triggers
SQL>@ddl_enable.sql

--Enable Supplemental Data on Database
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

--Create GG Server user
SQL> create user GGSERVER identified by ggserver123;

SQL> grant dba to GGSERVER;




--Start Manager
GGSCI (dbms.f2c.com.br) 2> START MANAGER


--Stop Manager
GGSCI (dbms.f2c.com.br) 2> STOP MANAGER [!]

--Start all extract groups
START EXTRACT *X*

--Show history of last commands
HISTORY

--Execute a command sequence
OBEY file_name_commands
--Example
ADD EXTRACT myext, TRANLOG, BEGIN now
START EXTRACT myext
ADD REPLICAT myrep, EXTTRAIL /ggs/dirdat/aa
START REPLICAT myrep
INFO EXTRACT myext, DETAIL
INFO REPLICAT myrep, DETAIL

--Create GLOBALS file
EDIT PARAMS ./GLOBALS
--Insert the line below to set GG schema user
GGSCHEMA gg

--Login on Database
DBLOGIN USERID gg, PASSWORD gg
##############################################################

I will post more ASAP!

Best Regards,
Paulo Portugal

No comments:

Post a Comment