阅读背景:

GoldentGate Oracle to Oracle 初始化详解

来源:互联网 

一、安装GoldenGate[源端,目标端]

    1、创建ogg目录
    [root@source ~]# mkdir /DBSoft/ogg
    [root@source ~]# cd /DBSoft/ogg/

    2、解压缩ogg安装介质
    [root@source ogg]# unzip /root/OGG_v11_for_ora11g_linux64.zip
    Archive: /root/OGG_v11_for_ora11g_linux64.zip
      inflating: ggs_Linux_x64_ora11g_64bit_v11_1_1_0_0_078.tar
      inflating: OGG_WinUnix_Rel_Notes_11.1.1.0.0_078.pdf
      inflating: README.txt

    3、可以看到介质包含一个tar包,pdf文件以及一个readme
    [root@source ogg]# ll
    total 201016
    -rw-rw---- 1 root root 205096960 Jul 29 2010 ggs_Linux_x64_ora11g_64bit_v11_1_1_0_0_078.tar
    -rwxrwxr-x 1 root root 500964 Aug 6 2010 OGG_WinUnix_Rel_Notes_11.1.1.0.0_078.pdf
    -rwxrwxr-x 1 root root 26726 Aug 3 2010 README.txt

    4、修改ogg目录所属组为oinstall及所属用户为oracle
    [root@source ogg]# cd ..
    [root@source DBSoft]# ll
    total 32
    drwxr-x--- 3 oracle oinstall 4096 Sep 2 22:40 admin
    drwxr-xr-x 6 oracle oinstall 4096 Sep 2 22:44 cfgtoollogs
    drwxr-xr-x 3 oracle oinstall 4096 Sep 2 22:38 checkpoints
    drwxrwxr-x 11 oracle oinstall 4096 Sep 2 22:39 diag
    drwxr-x--- 4 oracle oinstall 4096 Sep 2 22:41 fast_recovery_area
    drwxr-xr-x 2 oracle oinstall 4096 Sep 3 10:27 ogg
    drwxrwx--- 5 oracle oinstall 4096 Sep 2 22:39 oraInventory
    drwxr-xr-x 3 oracle oinstall 4096 Sep 2 22:32 product

    [root@source DBSoft]# chown -R oracle:oinstall ogg/
    [root@source DBSoft]# su - oracle

    5、再次进入ogg目录,解压缩ogg主程序文件
    [oracle@source ~]$ cd /DBSoft/ogg/
    [oracle@source ogg]$ ll
    total 201016
    -rw-rw---- 1 oracle oinstall 205096960 Jul 29 2010 ggs_Linux_x64_ora11g_64bit_v11_1_1_0_0_078.tar
    -rwxrwxr-x 1 oracle oinstall 500964 Aug 6 2010 OGG_WinUnix_Rel_Notes_11.1.1.0.0_078.pdf
    -rwxrwxr-x 1 oracle oinstall 26726 Aug 3 2010 README.txt

    #正在解压缩
    [oracle@source ogg]$ tar -xvf ggs_Linux_x64_ora11g_64bit_v11_1_1_0_0_078.tar
    bcpfmt.tpl
    bcrypt.txt
    chkpt_ora_create.sql
    cobgen
    convchk
    db2cntl.tpl
    ddl_access.tpl
    ddl_cleartrace.sql
    ddlcob
    ddl_db2_os390.tpl
    ddl_db2.tpl
    ddl_ddl2file.sql
    ddl_disable.sql
    ddl_enable.sql
    ddlgen
    ddl_informix.tpl
    ddl_mss.tpl
    ddl_mysql.tpl
    ddl_nopurgeRecyclebin.sql
    ddl_nssql.tpl
    ddl_ora10.sql
    ddl_ora10upCommon.sql
    ddl_ora11.sql
    ddl_ora9.sql
    ddl_oracle.tpl
    ddl_pin.sql
    ddl_purgeRecyclebin.sql
    ddl_remove.sql
    ddl_session1.sql
    ddl_session.sql
    ddl_setup.sql
    ddl_sqlmx.tpl
    ddl_status.sql
    ddl_staymetadata_off.sql
    ddl_staymetadata_on.sql
    ddl_sybase.tpl
    ddl_tandem.tpl
    ddl_tracelevel.sql
    ddl_trace_off.sql
    ddl_trace_on.sql
    defgen
    demo_more_ora_create.sql
    demo_more_ora_insert.sql
    demo_ora_create.sql
    demo_ora_insert.sql
    demo_ora_lob_create.sql
    demo_ora_misc.sql
    demo_ora_pk_befores_create.sql
    demo_ora_pk_befores_insert.sql
    demo_ora_pk_befores_updates.sql
    emsclnt
    extract
    freeBSD.txt
    ggMessage.dat
    ggsci
    help.txt
    keygen
    libicudata.so.38
    libicui18n.so.38
    libicuuc.so.38
    libxerces-c.so.28
    libxml2.txt
    logdump
    marker_remove.sql
    marker_setup.sql
    marker_status.sql
    mgr
    notices.txt
    params.sql
    replicat
    reverse
    role_setup.sql
    server
    sqlldr.tpl
    tcperrs
    UserExitExamples/
    UserExitExamples/ExitDemo_lobs/
    UserExitExamples/ExitDemo_lobs/Makefile_lob.SOLARIS
    UserExitExamples/ExitDemo_lobs/readme.txt
    UserExitExamples/ExitDemo_lobs/exitdemo_lob.c
    UserExitExamples/ExitDemo_lobs/Makefile_lob.AIX
    UserExitExamples/ExitDemo_lobs/Makefile_lob.LINUX
    UserExitExamples/ExitDemo_lobs/Makefile_lob.HPUX
    UserExitExamples/ExitDemo_lobs/exitdemo_lob.vcproj
    UserExitExamples/ExitDemo_passthru/
    UserExitExamples/ExitDemo_passthru/Makefile_passthru.AIX
    UserExitExamples/ExitDemo_passthru/Makefile_passthru.LINUX
    UserExitExamples/ExitDemo_passthru/Makefile_passthru.SOLARIS
    UserExitExamples/ExitDemo_passthru/exitdemopassthru.vcproj
    UserExitExamples/ExitDemo_passthru/readme.txt
    UserExitExamples/ExitDemo_passthru/exitdemo_passthru.c
    UserExitExamples/ExitDemo_passthru/Makefile_passthru.HP_OSS
    UserExitExamples/ExitDemo_passthru/Makefile_passthru.HPUX
    UserExitExamples/ExitDemo_more_recs/
    UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.AIX
    UserExitExamples/ExitDemo_more_recs/readme.txt
    UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.vcproj
    UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.SOLARIS
    UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.LINUX
    UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.HPUX
    UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.c
    UserExitExamples/ExitDemo/
    UserExitExamples/ExitDemo/exitdemo.c
    UserExitExamples/ExitDemo/Makefile_exit_demo.HPUX
    UserExitExamples/ExitDemo/Makefile_exit_demo.SOLARIS
    UserExitExamples/ExitDemo/readme.txt
    UserExitExamples/ExitDemo/exitdemo.vcproj
    UserExitExamples/ExitDemo/Makefile_exit_demo.HP_OSS
    UserExitExamples/ExitDemo/Makefile_exit_demo.LINUX
    UserExitExamples/ExitDemo/Makefile_exit_demo.AIX
    UserExitExamples/ExitDemo_pk_befores/
    UserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.vcproj
    UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.HPUX
    UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.AIX
    UserExitExamples/ExitDemo_pk_befores/readme.txt
    UserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.c
    UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.LINUX
    UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.SOLARIS
    usrdecs.h
    zlib.txt

    6、解压缩完之后,执行ggsci命令进入OGG交互界面
    [oracle@source ogg]$GGSCI
    GGSCI (source) 1>

    7、创建OGG所需目录
    GGSCI (source) 1> create subdirs

    Creating subdirectories under current directory /DBSoft/ogg

    Parameter files /DBSoft/ogg/dirprm: created
    Report files /DBSoft/ogg/dirrpt: created
    Checkpoint files /DBSoft/ogg/dirchk: created
    Process status files /DBSoft/ogg/dirpcs: created
    SQL script files /DBSoft/ogg/dirsql: created
    Database definitions files /DBSoft/ogg/dirdef: created
    Extract data files /DBSoft/ogg/dirdat: created
    Temporary files /DBSoft/ogg/dirtmp: created
    Veridata files /DBSoft/ogg/dirver: created
    Veridata Lock files /DBSoft/ogg/dirver/lock: created
    Veridata Out-Of-Sync files /DBSoft/ogg/dirver/oos: created
    Veridata Out-Of-Sync XML files /DBSoft/ogg/dirver/oosxml: created
    Veridata Parameter files /DBSoft/ogg/dirver/params: created
    Veridata Report files /DBSoft/ogg/dirver/report: created
    Veridata Status files /DBSoft/ogg/dirver/status: created
    Veridata Trace files /DBSoft/ogg/dirver/trace: created
    Stdout files /DBSoft/ogg/dirout: created


    GGSCI (source) 2>exit

    8、至此我们可以看到目录已经创建,OGG安装初始化完成
    [oracle@source ogg]$ ls -ltr dir*
    dirver:
    total 28
    drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 trace
    drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 status
    drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 report
    drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 params
    drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 oosxml
    drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 oos
    drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 lock

    1、创建ogg目录
    [



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: