goldengate施工文档-南京廖华答案网

goldengate施工文档下载本文

Goldengate施工文档（生产库部分）

按照此文档施工需求：

1．镜像库需要安装oracle数据库，字符集为utf8

2. 施工介质------(ggs_Linux_x64_ora11g_64bit_v11_1_1_0_0_078.tar)需要上传至镜像服务器/u01/app/upload目录下。并授权给oracle用户

第一步：准备工作

登录生产服务器：

1. 检查环境变量

[root@localhost ~]# su - oracle

[oracle@localhost ~]$ vi .bash_profile -------------------------编辑oracle用户的环境变量配置文件 # .bash_profile

# Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11g/db_1 export ORACLE_SID=orcl

export NLS_LANG=AMERICAN_AMERICA.al32UTF8 export PATH=$PATH:$ORACLE_HOME/bin export LANG=zh_CN.UTF-8

export PATH=$PATH:$ORACLE_BASE/goldengate export

LD_LIBRARY_PATH=$ORACLE_BASE/goldengate:$LD_LIBRARY_PATH :$ORACLE_HOME/lib

主要查看蓝色字体部分，没有的话添加上！光标用上下键移动至文件末尾，摁i键进入编辑模式，摁Enter键换行，然后输入上面的蓝色字体部分，最后摁Esc键，然后输入:wq!再摁回车键保存退出

2. 检查数据库是否开启归档

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 19 20:42:59 2012

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> archive log list;-----------------------------------------------（查看是否开启归档） Database log mode Archive Mode----------------------------(归档模式) Automatic archival Enabled

Archive destination /archive-----------------------------（归档日志路径，牢记，后面会用到）

Oldest online log sequence 10 Next log sequence to archive 12 Current log sequence 12

SQL> archive log list;

Database log mode No Archive Mode----------------------------（非归档模式） Automatic archival Disabled

Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 7 Current log sequence 9

若数据库为非归档模式，当联系当地数据库管理员开启归档模式！

附(开启归档命令)：设置为归档模式 SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@localhost ~]$ exit logout

[root@localhost ~]# mkdir /archive

[root@localhost ~]# chown oracle:oinstall /archive [root@localhost ~]# su - oracle

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 20 21:41:19 2012

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> show parameter log

SQL> alter system set log_archive_dest_1='location=/archive' scope=spfile; SQL> alter system set log_archive_format='%s_%t_%r.arc' scope=spfile;

SQL> shutdown immediate ----------- 一致性停库（切记联系当地数据库管理员，取得同意方可停库）

SQL> startup mount

SQL> alter database archivelog ; SQL> alter database open; SQL> alter system switch logfile;

第二步：安装goldengate软件

1. 创建goldengate数据库用户

SQL> select name from v$datafile;

NAME

-------------------------------------------------------------------------------- /u01/app/oracle/oradata/orcl/system01.dbf /u01/app/oracle/oradata/orcl/sysaux01.dbf /u01/app/oracle/oradata/orcl/undotbs01.dbf /u01/app/oracle/oradata/orcl/users01.dbf /u01/app/oracle/oradata/orcl/example01.dbf /u01/app/oracle/oradata/orcl/test1.dbf /u01/app/oracle/oradata/orcl/test2.dbf

SQL> CREATE SMALLFILE TABLESPACE \/u01/app/oracle/oradata/orcl/ggs.dbf' SIZE 200M;---------------------------------------(注意蓝色字体部分的路径必须和上面查出来的保持一致) SQL> create user GGMGR identified by oracle default tablespace GGS; SQL>grant connect to ggmgr; SQL>grant resource to ggmgr;

SQL>grant CREATE SESSION, ALTER SESSION to ggmgr;

Word文档下载：goldengate施工文档.doc

搜索更多:goldengate施工文档