ogg操作手冊(cè)

《ogg操作手冊(cè)》由會(huì)員分享，可在線閱讀，更多相關(guān)《ogg操作手冊(cè)（20頁(yè)珍藏版）》請(qǐng)?jiān)谘b配圖網(wǎng)上搜索。

1 ogg 操 作 手 冊(cè) 版本 V1 0 2 目錄 1 源端庫(kù)準(zhǔn)備工作 3 1 1 創(chuàng)建 ogg 管理用戶并授權(quán) 5 1 2 安裝 telnet 工具 5 1 3 磁盤使用情況 6 2 源端 ogg 準(zhǔn)備工作 6 2 1 設(shè)置 ogg 環(huán)境變量 6 2 2 上傳 ogg 軟件到相關(guān)目錄 6 2 3 登陸 8 2 4 創(chuàng)建 def 文件 8 2 5 創(chuàng)建 Manager 進(jìn)程 8 2 6 創(chuàng)建 Extract 進(jìn)程 9 2 7 創(chuàng)建 Pump 進(jìn)程 9 2 8 開(kāi)啟源端進(jìn)程 10 2 9 查看進(jìn)程狀態(tài) 10 3 目標(biāo)端 ogg 準(zhǔn)備工作 11 3 1 磁盤使用情況 11 3 2 創(chuàng)建用戶并授權(quán) 11 3 2 設(shè)置 ogg 環(huán)境變量 11 3 3 上傳 ogg 軟件到相關(guān)目錄 12 3 4 登陸 13 3 5 添加檢查點(diǎn)系統(tǒng)表 13 3 6 創(chuàng)建 Manager 進(jìn)程 13 3 7 創(chuàng)建 Replicat 進(jìn)程 14 3 8 開(kāi)啟目標(biāo)端進(jìn)程 15 3 9 查看目標(biāo)端進(jìn)程的狀態(tài) 15 3 1 源端庫(kù)準(zhǔn)備工作 oracle rac1 ps ef grep ogg grep v grep 查看業(yè)務(wù)系統(tǒng)是否安裝過(guò) ogg oracle rac1 sqlplus as sysdba SQL show parameter processes 查詢 oracle 最大連接數(shù) SQL select count from v process 查詢當(dāng)前連接數(shù) SQL archive log list 查看是否開(kāi)啟歸檔 Database log mode Archive Mode Automatic archival Enabled 開(kāi)啟狀態(tài) Archive destination ARCHDG Oldest online log sequence 342 Next log sequence to archive 343 Current log sequence 343 開(kāi)啟歸檔的步驟 SQL shutdown immediate 必須是 immediate 一至性關(guān)閉數(shù)據(jù)庫(kù) 4 SQL startup mount 開(kāi)啟數(shù)據(jù)庫(kù)到 mount 狀態(tài) SQL alter system set log archive dest 1 location archdg 指定歸檔日志存放的路徑 SQL alter database archivelog 開(kāi)啟歸檔 SQL alter database open 打開(kāi)數(shù)據(jù)庫(kù) SQL alter system switch logfile 切換歸檔 SQL alter system archive log current 切換歸檔 SQL SELECT FORCE LOGGING FROM V DATABASE 查看是否開(kāi)啟強(qiáng)制日志 SQL alter database force logging 開(kāi)啟強(qiáng)制日志的命令 SQL select supplemental log data min from v database 查看是否開(kāi)啟附加日志 SQL alter database add supplemental log data 開(kāi)啟附加日至命令 5 SQL alter system switch logfile 切換歸檔 1 1 創(chuàng)建 ogg 管理用戶并授權(quán) 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 源端和目標(biāo)端都要安裝 telnet 編輯設(shè)置 etc xinetd d telnet 將 disable yes 設(shè)置成 disable no echo pts 0 etc securetty echo pts 1 etc securetty service xinetd restart 設(shè)置 root 遠(yuǎn)程登錄 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 準(zhǔn)備工作 oracle rac1 mkdir ogg 創(chuàng)建 ogg 目錄 oracle rac1 chown oracle oinstall R ogg oracle rac1 chmod 775 R ogg 2 1 設(shè)置 ogg 環(huán)境變量 oracle rac1 vi bash profile export OGG HOME ogg oracle rac1 bash profile 2 2 上傳 ogg 軟件到相關(guān)目錄 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 把定義文件傳到目標(biāo)端 2 5 創(chuàng)建 Manager 進(jìn)程 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 進(jìn)程 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 進(jìn)程 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 開(kāi)啟源端進(jìn)程 GGSCI rac1 3 start mgr GGSCI rac1 3 start Extract GGSCI rac1 3 start Pump 2 9 查看進(jìn)程狀態(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 目標(biāo)端 ogg 準(zhǔn)備工作 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)建用戶并授權(quán) 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 設(shè)置 ogg 環(huán)境變量 root node01 vi bash profile 12 export OGG HOME ogg root node01 bash profile 3 3 上傳 ogg 軟件到相關(guān)目錄 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 添加檢查點(diǎn)系統(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 進(jìn)程 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 進(jìn)程 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 開(kāi)啟目標(biāo)端進(jìn)程 GGSCI node01 2 start mgr GGSCI node01 2 start Replicat 3 9 查看目標(biāo)端進(jìn)程的狀態(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