ogg操作手冊

《ogg操作手冊》由會員分享，可在線閱讀，更多相關《ogg操作手冊（20頁珍藏版）》請在裝配圖網上搜索。

1 ogg 操 作 手 冊 版本 V1 0 2 目錄 1 源端庫準備工作 3 1 1 創(chuàng)建 ogg 管理用戶并授權 5 1 2 安裝 telnet 工具 5 1 3 磁盤使用情況 6 2 源端 ogg 準備工作 6 2 1 設置 ogg 環(huán)境變量 6 2 2 上傳 ogg 軟件到相關目錄 6 2 3 登陸 8 2 4 創(chuàng)建 def 文件 8 2 5 創(chuàng)建 Manager 進程 8 2 6 創(chuàng)建 Extract 進程 9 2 7 創(chuàng)建 Pump 進程 9 2 8 開啟源端進程 10 2 9 查看進程狀態(tài) 10 3 目標端 ogg 準備工作 11 3 1 磁盤使用情況 11 3 2 創(chuàng)建用戶并授權 11 3 2 設置 ogg 環(huán)境變量 11 3 3 上傳 ogg 軟件到相關目錄 12 3 4 登陸 13 3 5 添加檢查點系統(tǒng)表 13 3 6 創(chuàng)建 Manager 進程 13 3 7 創(chuàng)建 Replicat 進程 14 3 8 開啟目標端進程 15 3 9 查看目標端進程的狀態(tài) 15 3 1 源端庫準備工作 oracle rac1 ps ef grep ogg grep v grep 查看業(yè)務系統(tǒng)是否安裝過 ogg oracle rac1 sqlplus as sysdba SQL show parameter processes 查詢 oracle 最大連接數(shù) SQL select count from v process 查詢當前連接數(shù) SQL archive log list 查看是否開啟歸檔 Database log mode Archive Mode Automatic archival Enabled 開啟狀態(tài) Archive destination ARCHDG Oldest online log sequence 342 Next log sequence to archive 343 Current log sequence 343 開啟歸檔的步驟 SQL shutdown immediate 必須是 immediate 一至性關閉數(shù)據(jù)庫 4 SQL startup mount 開啟數(shù)據(jù)庫到 mount 狀態(tài) SQL alter system set log archive dest 1 location archdg 指定歸檔日志存放的路徑 SQL alter database archivelog 開啟歸檔 SQL alter database open 打開數(shù)據(jù)庫 SQL alter system switch logfile 切換歸檔 SQL alter system archive log current 切換歸檔 SQL SELECT FORCE LOGGING FROM V DATABASE 查看是否開啟強制日志 SQL alter database force logging 開啟強制日志的命令 SQL select supplemental log data min from v database 查看是否開啟附加日志 SQL alter database add supplemental log data 開啟附加日至命令 5 SQL alter system switch logfile 切換歸檔 1 1 創(chuàng)建 ogg 管理用戶并授權 SQL create user cas sgcis identified by Sap12345 SQL grant connect to cas sgcis SQL grant SELECT ANY DICTIONARY to cas sgcis SQL grant select any table to cas sgcis 1 2 安裝 telnet 工具 oracle rac1 rpm ivh telnet 0 17 47 el6 3 1 x86 64 rpm oracle rac1 rpm ivh telnet server 0 17 47 el6 3 1 x86 64 rpm 源端和目標端都要安裝 telnet 編輯設置 etc xinetd d telnet 將 disable yes 設置成 disable no echo pts 0 etc securetty echo pts 1 etc securetty service xinetd restart 設置 root 遠程登錄 6 1 3 磁盤使用情況 oracle rac1 df h Filesystem Size Used Avail Use Mounted on dev sda3 145G 19G 119G 14 tmpfs 1 5G 980M 457M 69 dev shm dev sda1 291M 39M 238M 14 boot 2 源端 ogg 準備工作 oracle rac1 mkdir ogg 創(chuàng)建 ogg 目錄 oracle rac1 chown oracle oinstall R ogg oracle rac1 chmod 775 R ogg 2 1 設置 ogg 環(huán)境變量 oracle rac1 vi bash profile export OGG HOME ogg oracle rac1 bash profile 2 2 上傳 ogg 軟件到相關目錄 oracle rac1 ogg unzip ogg112101 fbo ggs Linux x64 ora11 g 64bit zip 7 oracle rac1 ogg tar xvf fbo ggs Linux x64 ora11g 64b it tar 解壓 ogg 軟件 oracle rac1 ogg cp ORACLE HOME lib libnnz11 so ogg oracle rac1 ogg cp ORACLE HOME lib libclntsh so 11 1 ogg 拷貝 ogg 所需要的共享文件 oracle rac1 ogg ggsci GGSCI rac1 1 create subdirs 初始化 ogg 目錄 Creating subdirectories under current directory ogg Parameter files ogg dirprm already exists Report files ogg dirrpt created Checkpoint files ogg dirchk created Process status files ogg dirpcs created SQL script files ogg dirsql created Database definitions files ogg dirdef created Extract data files ogg dirdat created Temporary files ogg dirtmp created Stdout files ogg dirout created 8 2 3 登陸 GGSCI rac1 1 dblogin userid cas sgcis password Sap12345 2 4 創(chuàng)建 def 文件 GGSCI rac1 1 edit params fdpm def defsfile ogg dirdef fdpmaster ah def userid CAS SGCIS password Sap12345 table fdpmaster ah G LINE oracle rac1 ogg defgen paramfile dirprm fdpm def prm 生成 def 定義文件 oracle rac1 ogg scp ogg dirdef fdpmaster ah def root 192 168 1 205 ogg dirdef 把定義文件傳到目標端 2 5 創(chuàng)建 Manager 進程 GGSCI edit params mgr PORT 8333 DYNAMICPORTLIST 8334 8999 AUTOSTART ER AUTORESTART EXTRACT RETRIES 5 WAITMINUTES 3 PURGEOLDEXTRACTS dirdat usecheckpoints minkeepdays 3 LAGREPORTHOURS 1 9 LAGINFOMINUTES 30 LAGCRITICALMINUTES 45 2 6 創(chuàng)建 Extract 進程 GGSCI rac1 2 edit params extract extract extract GETTRUNCATES GETUPDATEBEFORES FETCHOPTIONS FETCHPKUPDATECOLS dynamicresolution userid CAS SGCIS password Sap12345 TRANLOGOPTIONS ASMUSER sys asm ASMPASSWORD oracle exttrail ogg dirdat a5 table fdpmaster ah G LINE GGSCI rac1 2 add extract Extract tranlog threads 2 begin now GGSCI rac1 2 add exttrail ogg dirdat a5 extract Extract 2 7 創(chuàng)建 Pump 進程 GGSCI rac1 2 edit params pump extract pump passthru 10 dynamicresolution userid CAS SGCIS password Sap12345 rmthost 192 168 1 205 mgrport 8333 rmttrail ogg dirdat a5 table fdpmaster ah G LINE GGSCI rac1 2 add extract Pump exttrailsource ogg dirdat a5 GGSCI rac1 2 add rmttrail ogg dirdat a5 extract Pump 2 8 開啟源端進程 GGSCI rac1 3 start mgr GGSCI rac1 3 start Extract GGSCI rac1 3 start Pump 2 9 查看進程狀態(tài) GGSCI rac1 4 info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING Extract 00 00 00 00 00 07 EXTRACT RUNNING Pump 00 00 00 00 00 01 11 3 目標端 ogg 準備工作 3 1 磁盤使用情況 root node01 df h Filesystem Size Used Avail Use Mounted on dev sda3 145G 19G 119G 14 tmpfs 1 5G 980M 457M 69 dev shm dev sda1 291M 39M 238M 14 boot 3 2 創(chuàng)建用戶并授權 mysql create user dbscale identified by oracle Query OK 0 rows affected 0 02 sec mysql grant ALL PRIVILEGES on to dbscale Query OK 0 rows affected 0 12 sec root node01 mkdir ogg 創(chuàng)建 ogg 目錄 3 2 設置 ogg 環(huán)境變量 root node01 vi bash profile 12 export OGG HOME ogg root node01 bash profile 3 3 上傳 ogg 軟件到相關目錄 root node01 unzip ggs Linux x64 MySQL 64bit zip root node01 tar xvf ggs Linux x64 MySQL 64bit tar 解壓 ogg 軟件 oracle rac1 ogg ggsci GGSCI rac1 1 create subdirs 初始化 ogg 目錄 Creating subdirectories under current directory ogg Parameter files ogg dirprm created Report files ogg dirrpt created Checkpoint files ogg dirchk created Process status files ogg dirpcs created SQL script files ogg dirsql created Database definitions files ogg dirdef created Extract data files ogg dirdat created Temporary files ogg dirtmp created Stdout files ogg dirout created 13 3 4 登陸 GGSCI rac1 1 dblogin sourcedb mysql ogg 192 168 1 210 23 306 userid dbscale password oracle GGSCI rac1 1 dblogin sourcedb mysql ogg userid root passw ord oracle 3 5 添加檢查點系統(tǒng)表 GGSCI rac1 1 edit params GLOBALS checkpointtable mysql ogg chktab GGSCI rac1 1 add checkpointtable mysql ogg chktab 3 6 創(chuàng)建 Manager 進程 GGSCI edit params mgr PORT 8333 DYNAMICPORTLIST 8334 8999 AUTOSTART ER AUTORESTART EXTRACT RETRIES 5 WAITMINUTES 3 PURGEOLDEXTRACTS dirdat usecheckpoints minkeepdays 3 LAGREPORTHOURS 1 LAGINFOMINUTES 30 LAGCRITICALMINUTES 45 14 3 7 創(chuàng)建 Replicat 進程 GGSCI node01 2 edit params replicat replicat replicat sourcedefs ogg dirdef fdpmaster ah def GETTRUNCATES applynoopupdates dboptions nolimitrows INSERTUPDATES INSERTDELETES INSERTALLRECORDS REPERROR DEFAULT ABEND TARGETDB mysql ogg 192 168 1 210 23306 userid dbscale passw ord oracle Map fdpmaster ah G LINE target yxjcsjpt fdpmaster ah G LINE colmap usedefaults informatica row id GETENV RECORD RO WID informatica date time GETENV GGHEADER COMMITTIM ESTAMP informatica flag CASE GETENV GGHEADER OPTYPE DELETE D UPDATE CASE GETENV GGHEADER BEFOREAFT ERINDICATOR BEFORE D AFTER I 0 PK UPDATE CASE GETENV GGHEADER BEFOREAFTERINDICATOR BEFORE D A FTER I 0 INSERT I SQL COMPUPDATE CASE GETENV G GHEADER BEFOREAFTERINDICATOR BEFORE D AFTER I 0 15 0 informatica ogg seq COLSTAT NULL GGSCI node01 2 add replicat replicat exttrail ogg dirdat a5 checkpointtable mysql ogg chktab 3 8 開啟目標端進程 GGSCI node01 2 start mgr GGSCI node01 2 start Replicat 3 9 查看目標端進程的狀態(tài) GGSCI node01 DBLOGIN as dbscale 54 info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING REPLICAT RUNNING Replicat 00 00 00 00 00 02 16 17 18 19 20