點擊上方“IT那活兒”,關(guān)注后了解更多內(nèi)容,不管IT什么活兒,干就完了!!!
前提條件檢查
1)數(shù)據(jù)庫版本源庫不低于11203;
2)推薦patch參考1557031.1以及2193391.1;
3)檢查是否存在不支持的對象類型;
4)Latest GoldenGate/Database (OGG/RDBMS) Patch recommendations ( Doc ID 2193391.1 。
實施環(huán)境
實施流程
影響范圍及風險評估
配置goldengate軟件均在線完成, 不需要停止業(yè)務,備庫初始化需要在源庫導出一份數(shù)據(jù),導數(shù)據(jù)在夜間業(yè)務閑時操作;goldengate配置完成后,對主機性能有1-3%的影響。
實施環(huán)境準備
操作系統(tǒng)用戶建議使用Oracle用戶也可使用新建用戶,但該用戶必須加入到oinstall組,該用戶使用與oracle相同的profile文件,操作系統(tǒng)必須為該用戶開放一定的CPU、內(nèi)存等資源限制,可以通過ulimit –a查看,建議在/etc/security/limits.conf中設置和oracle用戶一致,本次實施使用已有的oracle用戶。
確保為 Oracle 和 Oracle Goldengate 運行用戶配置動態(tài)庫路徑。確保 Oracle 數(shù)據(jù)庫的運行庫(
#export SHLIB_PATH=$ORACLE_HOME/lib32:$SHLIB_PATH:$SHLIB_PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:$LD_LIBRARY_PATH
Oracle GoldenGate 只需要復制兩端的 IP 地址之間能夠建立 TCP 連接,一個 Goldengate 復制鏈路需要 10 個 TCP 動態(tài)端口,具體端口建議使用 7839~7949。
hosts配置
192.168.79.26 oggsre
192.168.79.27 oggtar
goldengate軟件安裝目錄1GB,trail文件目錄根據(jù)歸檔量計算,除此之外,還應該考慮BR目錄和臨時目錄(ogg使用的臨時目錄)。
分配表空間,大小不小于日志組大小--分配表空間,大小不小于日志組大小。
set linesize 150
col FILE_NAME for a50
select tablespace_name ,file_name from dba_data_files;
select bytes/1024/1024from v$log;
CREATETABLESPACE goldengate DATAFILE +DATA size 1G autoextend on maxsize 10G;
創(chuàng)建用戶并授權(quán):
CREATEUSER GOLDENGATE IDENTIFIED BY goldengate DEFAULTTABLESPACE GOLDENGATE TEMPORARYTABLESPACETEMP;
GRANTCONNECTTO GOLDENGATE;
GRANTALTERANYTABLETO GOLDENGATE;
GRANTALTERSESSIONTO GOLDENGATE;
GRANTCREATESESSIONTO GOLDENGATE;
GRANT FLASHBACK ANYTABLETO GOLDENGATE;
GRANTSELECTANY DICTIONARY TO GOLDENGATE;
GRANTSELECTANYTABLETO GOLDENGATE;
GRANT RESOURCE TO GOLDENGATE;
GRANTEXECUTEANYTYPETO GOLDENGATE;
GRANTSELECTANYTRANSACTIONTO GOLDENGATE;
GRANTCREATEany TABLE,CREATEany SEQUENCE TO goldengate ;
GRANTINSERTANYTABLETO GOLDENGATE;
GRANTUPDATEANYTABLETO GOLDENGATE;
GRANTDELETEANYTABLETO GOLDENGATE;
GRANTCREATEANYINDEXTO GOLDENGATE;
grant unlimited tablespaceto goldengate ;
grantexecuteon DBMS_FLASHBACK to goldengate;
grant COMMENTANYTABLE to goldengate;
alter system set enable_goldengate_replication=true sid=* scope=both;
exec dbms_goldengate_auth.grant_admin_privilege(goldengate)
12c授權(quán)語法如下:
exec dbms_goldengate_auth.grant_admin_privilege(C##GGADMIN,container=>ALL);
grant dba to c##ggadmin container=all;
不建議使用DBA權(quán)限替GOldenGate所需要的權(quán)限。
set line 350 pages 999
col NAME for a15
col LOG_MODE for a15
col OPEN_MODE for a15
col PLATFORM_NAME for a25
col FORCE_LOGGING for a20
col SUPPLEMENTAL_LOG_DATA_MIN for a25
SELECT
NAME,
LOG_MODE,
OPEN_MODE,
PLATFORM_NAME,
FORCE_LOGGING,
SUPPLEMENTAL_LOG_DATA_MIN
FROM
V$DATABASE;
select log_mode from v$database;
確認補充日志是否打開:
SQL> SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;
SUPPLEMENTAL_LOG_DATA_MIN
-------------------------
NO
打開源端的補充日志:
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
Verify that it is enabled:
SQL> SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;
SUPPLEMENTAL_LOG_DATA_MIN
-------------------------
YES
C
注:打開補充日志最好在夜里業(yè)務很少的時候進行。如果是 RAC 需要在每個節(jié)點上都執(zhí)行。完成后建議執(zhí)行一次歸檔操作:
alter system archive log current;
select NAME,FORCE_LOGGING from v$database;
alter database FORCE LOGGING;
set line 350 pages 999
col NAME for a15
col LOG_MODE for a15
col OPEN_MODE for a15
col PLATFORM_NAME for a25
col FORCE_LOGGING for a20
col SUPPLEMENTAL_LOG_DATA_MIN for a25
SELECT
NAME,
LOG_MODE,
OPEN_MODE,
PLATFORM_NAME,
FORCE_LOGGING,
SUPPLEMENTAL_LOG_DATA_MIN
FROM
V$DATABASE;
The output of the query must be YES for both properties。
修改spfile,重啟生效,rac可以指定節(jié)點修改,臨時修改到內(nèi)存可以使用如下命令:
alter system set streams_pool_size=1500m scope=memory sid=ringdb1;
配置過程
上傳并解壓軟件;
執(zhí)行runInstaller,按照提示完成安裝;
測試控制臺:
以 oracle(運行用戶)用戶身份登錄;分別在源端和目標端執(zhí)行:./ggsci;
如果成功進入控制臺,說明環(huán)境滿足 GoldenGate 要求。
源端和目標端配置過程一樣。
生成密文:
GGSCI (goldengate)1> ENCRYPT PASSWORD goldengate EncryptKey Default --為密碼字符goldengate生成密文
Using Blowfish encryption with DEFAULT key.
Encrypted password: AACAAAAAAAAAAAKAPATACEHBIGQGCFZCCDIGAEMCQFFBZHVC --生成的密文
Algorithm used: BLOWFISH
編輯mgr參數(shù)文件:
view params mgr
PORT 7809
DYNAMICPORTLIST 7840-7849
ACCESSRULE, PROG SERVER, ALLOW
AUTOSTART EXTRACT *
AUTORESTART EXTRACT * retries 5 waitminutes 3
--AUTOSTART REPLICAT *
--AUTORESTART REPLICAT * retries 5 waitminutes 1
PURGEOLDEXTRACTS /oracle/ogg/dirdat/*,usecheckpoints, minkeepdays 2
LAGREPORTMINUTES 10
LAGREPORTHOURS 1
LAGINFOMINUTES 30
LAGCRITICALMINUTES 60
--STARTUPVALIDATIONDELAY 5
--USERID goldengate, PASSWORD goldengate
USERID goldengate, PASSWORD AACAAAAAAAAAAAKAPATACEHBIGQGCFZCCDIGAEMCQFFBZHVC, ENCRYPTKEY DEFAULT
PURGEDDLHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 5, FREQUENCYMINUTES 30 --觸發(fā)器模式需要配置
PURGEMARKERHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 5, FREQUENCYMINUTES 30
安裝用戶添加:
dblogin userid goldengate,password goldengate
add schematrandata oggsre
dblogin userid goldengate,password GoldenGate_23
add trandata SPCLUSDP.t_opencloselog
add trandata SPCLUSDP.t_personaldownreport
不使用add trandata user.* ,因為新加的表不會自動打開附加日志。
按照用戶添加驗證:
info SCHEMATRANDATA scott
按照表添加的驗證:
info trandata SPCLUSDP.t_busgrouplooptone
排除外部表和已確認臨時表的抽取:
set line 230 pages 999
col OWNER for a25
col DEFAULT_DIRECTORY_NAME for a15
col ACCESS_TYPE for a12
col ACCESS_PARAMETERS for a45
col REJECT_LIMIT for a10
select * from dba_external_tables;
編輯參數(shù):
edit params ext_01
--base parameter
extract ext_01
SETENV (ORACLE_SID = test)
SETENV (ORACLE_HOME = /oracle/app/oracle/product/11.2.0/db)
SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
USERID goldengate, PASSWORD AACAAAAAAAAAAAKAPATACEHBIGQGCFZCCDIGAEMCQFFBZHVC, ENCRYPTKEY DEFAULT
-- SOURCECATALOG yzxdb
exttrail /oracle/ogg/dirdat/ex
TRANLOGOPTIONS EXCLUDEUSER goldengate
numfiles 5000
TRANLOGOPTIONS INTEGRATEDPARAMS (max_sga_size 512, parallelism 4)
DISCARDFILE /oracle/ogg/dirrpt/ext_01.dsc,APPEND,MEGABYTES 100
DISCARDROLLOVER AT 3:00
REPORTCOUNT EVERY 30 MINUTES, RATE
REPORTROLLOVER AT 9:00
--TRANLOGOPTIONS CHECKPOINTRETENTIONTIME 20
WARNLONGTRANS 2h, CHECKINTERVAL 30m
--TRANLOGOPTIONS INCLUDEREGIONID --和時間格式相關(guān),不報錯就不添加
--map objects
SEQUENCE oggsre.*;
Table oggsre.*;
TABLEEXCLUDE oggsre.emp ;
--ddl support
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
TRANLOGOPTIONS FETCHPARTIALLOB,GETCTASDML --CAST支持,記錄insert的日志,保證數(shù)據(jù)一致,但處理大表時,replicat性能極差
DDLOPTIONS ADDTRANDATA --取決于添加附件日志的方式
-- DDLOPTIONS GETREPLICATES --添加附加日志的語句是否復制, 和是否配置DDLOPTIONS ADDTRANDATA有關(guān)
-- DDLOPTIONS NOCROSSRENAME --12c 已經(jīng)廢棄
--LOGALLSUPCOLS
--UPDATERECORDFORMAT compact
-- Performance optimization
cachemgr cachesize 512M, cachedirectory /oracle/ogg/dirtmp 10G
BR BRINTERVAL 40M, BRDIR BR
如果是pdb環(huán)境,應該在pdb級別運行sequence.sql 支持腳本,和在pdb內(nèi)進行授權(quán);
首先在源配置GLOBALS文件,如果為打開DDL復制已經(jīng)配置過,可以跳過該步:
ggsci>EDIT PARAMS ./GLOBALS --在該文件中添加以下內(nèi)容
GGSCHEMA goldengate --指定的進行DDL復制的數(shù)據(jù)庫用戶
在源端和目標端均需要以sysdba用戶執(zhí)行以下腳本:
sqlplus>connect /as sysdba
Sqlplus>@sequence.sql --該文件在/ggs目錄下
輸入用戶:goldengate
授權(quán):
在源端進行授權(quán):
SQL> GRANT EXECUTE on goldengate.updateSequence TO goldengate;
SQL>alter table sys.seq$ add supplemental log data(primary key) columns;
在目標進行授權(quán):
SQL>GRANT EXECUTE on goldengate.replicateSequence TO goldengate;
在源端和目標端進程參數(shù)中配置:
Extract和pump均配置:
SEQUENCE zly.seq1;或者SEQUENCE zly.*;
TABLE zly.*;
replicat中需要配置:
MAP zly.seq1, TARGET zly.seq1;
或者是MAP zly.*, TARGET zly.*;這樣就包括了表和序列;
(不能在replicat中配置成SEQUENCE gtj.seq1的形式)。
序列在復制過程中,replicat缺省會CHECKSEQUENCEVALUE,確保目標大于原的序列值。
create sequence gtj.seq1
minvalue 1
maxvalue 99999999
start with 1 increment by 2
cache 20
cycle;
sequence不建議加入復制。
優(yōu)化建議
replicat進程拆分:多帶帶進程配置sequence復制;
確保目標端next_value值大于源端,算法如下:
source_highwater_value + (source_cache_size * source_increment_size * source_RAC_nodes) <= target_highwater_value
Cycle的影響
如果序列有cycle,目標端必然先達到最大值,然后從循環(huán)從最小值開始,這違背了目標端next_value值大于源端的原則。
解決方案:
--DBOPTIONS _MAXSEQUENCEDISTANCE
確保replicat進程配置參數(shù)CheckSequenceValue。
DBLOGIN USERID goldengate, PASSWORD goldengate
REGISTER EXTRACT ext_01 DATABASE
ADD EXTRACT ext_01, INTEGRATED TRANLOG, BEGIN NOW
ADD EXTTRAIL /oracle/ogg/dirdat/ex, EXTRACT ext_01, MEGABYTES 50
start ext_01
info all
pdb按如下方式注冊:
REGISTER EXTRACT ext_01 DATABASE CONTAINER(yzxdb)
編輯參數(shù):
extract pmp_01
SETENV (ORACLE_SID = test)
SETENV (ORACLE_HOME = /oracle/app/oracle/product/11.2.0/db)
passthru
rmthost goldengate,mgrport 7809, compress
rmttrail /oracle/ogg/dirdat/rt
DISCARDFILE /oracle/ogg/dirrpt/pmp_01.dsc,APPEND,MEGABYTES 100
DISCARDROLLOVER AT 9:00
REPORTROLLOVER AT 9:00
REPORTCOUNT EVERY 1 HOURS, RATE
table oggsre.*;
------- sequence-----
SEQUENCE oggsre.*;
注冊datapump進程:
DBLOGIN USERID goldengate, PASSWORD goldengate
ADD EXTRACT pmp_01 EXTTRAILSOURCE /oracle/ogg/dirdat/ex --extract進程trial文件位置
ADD RMTTRAIL /oracle/ogg/dirdat/rt, EXTRACT pmp_01, MEGABYTES 500 --遠程trial文件位置
target端mgr進程啟動后啟動datapump進程。
基于scn做一致性備份恢復。
查詢當前scn:
col current_scn for 9999999999999999999999999999
select current_scn from v$database;
確保數(shù)據(jù)庫中事物啟動時間晚于capture進程啟動時間。
Select start_time from gv$transaction where to_date(start_time, yyyy-mm-dd hh24:mi:ss)
(20XX-05-03 11:20:55, yyyy-mm-dd hh24:mi:ss);
導出數(shù)據(jù):
vi schema.par
userid= "/ AS SYSDBA"
directory=ogg_dump
dumpfile=obj_%U.dmp
logfile=exp.log
parallel=6
flashback_scn=
schemas=oggsre
cluster=n
EXCLUDE = TABLE:"IN ( , )" --根據(jù)情況確定(排除外部表和臨時表)
nohup expdp parfile=schema.par &
備庫恢復數(shù)據(jù):
vi impscheam.par
userid= "/ AS SYSDBA"
directory=ogg_dump
dumpfile=obj_%U.dmp
logfile=imp.log
parallel=6
schemas=oggtar
cluster=n
impdp parfile= impsche
am.par
備庫禁用觸發(fā)器,外鍵約束,job等。
禁用外鍵約束:
select alter table ||owner||.||table_name|| disable
constraint ||constraint_name||; from dba_constraints
where constraint_type in (R) and owner = SUBADMIN order by status,owner;
執(zhí)行返回的sql語句。
禁用觸發(fā)器:
select alter trigger ||owner||.||trigger_name||
disable; from dba_triggers where owner =SUBADMIN order by status,owner;
執(zhí)行返回的sql,但是新創(chuàng)建的觸發(fā)器,在備庫任然需要手動禁用,這在生產(chǎn)中顯然不可取,因此不采用該方式處理觸發(fā)器問題。
在replicat進程配置如下參數(shù)限制,配置該參數(shù)后,備庫的觸發(fā)器將不會被觸發(fā)(即使觸發(fā)器狀態(tài)為enable)。
DBOPTIONS SUPPRESSTRIGGERS。
禁用job
備庫設置如下參數(shù)job和Schedul被
alter system set job_queue_processes=0 scope=both;
也可多帶帶禁用job:
select execute DBMS_IJOB.BROKEN(||job||,TRUE); commit;
from dba_jobs
where schema_user in (MIGUAPP,MGSTATIS,MIGU_BO,MIGUAPPTEST,TYQK,MGACTIVEMQ) and BROKEN=N;
set linesize 300 pages 999
col OWNER for a20
col JOB_NAME for a45
col JOB_CREATOR for a25
col ENABLED for a10
col START_DATE for a25
col NEXT_RUN_DATE for a25
col LAST_START_DATE for a25
col REPEAT_INTERVAL for a50
select OWNER,JOB_NAME,ENABLED,to_char(START_DATE,yyyy/mm/dd hh:mm) START_DATE,to_char(LAST_START_DATE,yyyy/mm/dd hh:mm) LAST_START_DATE,to_char(NEXT_RUN_DATE,yyyy/mm/dd hh:mm) NEXT_RUN_DATE,REPEAT_INTERVAL ,RUN_COUNT from dba_scheduler_jobs where owner in (MIGUAPP,MGSTATIS,MIGU_BO,MIGUAPPTEST,TYQK,MGACTIVEMQ);
exec dbms_scheduler.disable(name => lower(delete_4_old_records),force => true);
mgr配置同source端mgr配置。
編輯replicat參數(shù):
--base parameter
REPLICAT rep_01
SETENV (ORACLE_SID = test)
SETENV (ORACLE_HOME = /oracle/app/oracle/product/11.2.0/db)
SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
USERID goldengate, PASSWORD AACAAAAAAAAAAAKAPATACEHBIGQGCFZCCDIGAEMCQFFBZHVC, ENCRYPTKEY DEFAULT
DISCARDFILE /oracle/ogg/dirrpt/rep_01.dsc,APPEND,MEGABYTES 100
DISCARDROLLOVER AT 3:00
DBOPTIONS INTEGRATEDPARAMS(parallelism 4)
DBOPTIONS SUPPRESSTRIGGERS -- 不觸發(fā)觸發(fā)器
DBOPTIONS DEFERREFCONST -- 不校驗外鍵約束
ASSUMETARGETDEFS
REPERROR DEFAULT, ABEND
REPORTCOUNT EVERY 60 MINUTES, RATE
REPORTROLLOVER AT 9:00
numfiles 5000
cachemgr cachesize 512M, cachedirectory /oracle/ogg/dirtmp 2GB
--map objects
Map oggsre.*, target oggtar.*;
--LIMITROWS
--ddl map
--DDL INCLUDE MAPPED,EXCLUDE OBJNAME ".
--sequence parameter
DBOPTIONS _MAXSEQUENCEDISTANCE 50
--performance
--優(yōu)化相關(guān)
DBOPTIONS INTEGRATEDPARAMS (COMMIT_SERIALIZATION DEPENDENT_TRANSACTIONS) --按照事務依賴關(guān)系提交
BATCHSQL
GROUPTRANSOPS 100
replicat進程正常運行,goldengate運行用戶需要適當?shù)臋?quán)限。
grant execute on utl_file to goldengate;
--grant dba to goldengate;
grant create table,create sequence to goldengate;
exec dbms_goldengate_auth.grant_admin_privilege(goldengate)
添加replicat進程:
DBLOGIN USERID goldengate, PASSWORD goldengate
add replicat rep_01 integrated exttrail /oracle/ogg/dirdat/rt
start replicat rep_01, aftercsn
遇到錯誤
啟動報錯:
WARNING OGG-01877 Missing explicit accessrule for server collector
解決:
This is just part of the new security in GoldenGate 12.2.
As mentioned above by Vinodh you should add the ACCESSRULE
parameter to the mgr.prm file. This is telling the Manager
what systems can have access to the manager in order to
start a task or a collector. The minimum required to make this message go away is
ACCESSRULE, PROG SERVER, ALLOW
It is designed to allow you to specify specific access to
specific machines on the network. This provides an
additional layer of security for the manager process. I see
this message regardless of whether the systems are in the same or different subnets.
ERROR OGG-02912 Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later。
20XX-05-31 00:33:17 INFO OGG-01971 The previous message, INFO OGG-02776, repeated 1 times.
Source Context :
SourceModule : [ggdb.ora.ddl]
SourceID : [../gglib/ggdbora/ddlora.c]
SourceMethod : [metadata_from_logminer]
SourceLine : [1267]
ThreadBacktrace : [16] elements
: [/opt/oragate/goldengate/libgglog.so(CMessageContext::AddThreadContext())]
: [/opt/oragate/goldengate/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
: [/opt/oragate/goldengate/libgglog.so(_MSG_(CSourceContext*, int, CMessageFactory::MessageDisposition))]
: [/opt/oragate/goldengate/extract()]
: [/opt/oragate/goldengate/extract()]
: [/opt/oragate/goldengate/extract(RedoAPI::createInstance(ggs::gglib::ggdatasource::DataSource*, ggs::gglib::ggapp::ReplicationContext*))]
: [/opt/oragate/goldengate/extract(ggs::er::OraTranLogDataSource::setup())]
: [/opt/oragate/goldengate/extract(ggs::gglib::ggapp::ReplicationContext::establishStartPoints(char, ggs::gglib::ggdatasource::DataSourceParams const&))]
: [/opt/oragate/goldengate/extract(ggs::gglib::ggapp::ReplicationContext::initializeDataSources(ggs::gglib::ggdatasource::DataSourceParams&))]
: [/opt/oragate/goldengate/extract()]
: [/opt/oragate/goldengate/extract(ggs::gglib::MultiThreading::MainThread::ExecMain())]
: [/opt/oragate/goldengate/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
: [/opt/oragate/goldengate/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
: [/opt/oragate/goldengate/extract(main)]
: [/lib64/libc.so.6(__libc_start_main)]
: [/opt/oragate/goldengate/extract()]
20XX-05-31 00:33:17 ERROR OGG-02912 Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later.
20XX-05-31 00:33:17 ERROR OGG-01668 PROCESS ABENDING.
執(zhí)行sql:
[oracle@VUSDPDB-1 goldengate]$ pwd
/opt/oragate/goldengate
[oracle@VUSDPDB-1 goldengate]$ ll prvtlmpg
prvtlmpg.plb prvtlmpg_uninstall.sql
[oracle@VUSDPDB-1 goldengate]$ ll prvtlmpg.plb
-rwxr-xr-x 1 oracle oinstall 9487 May 27 2015 prvtlmpg.plb
[oracle@VUSDPDB-1 goldengate]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun May 31 00:39:46 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @prvtlmpg.plb
Oracle GoldenGate Workaround prvtlmpg
This script provides a temporary workaround for bug 17030189.
It is strongly recommended that you apply the official Oracle
Patch for bug 17030189 from My Oracle Support instead of using
this workaround.
This script must be executed in the mining database of Integrated
Capture. You will be prompted for the username of the mining user.
Use a double quoted identifier if the username is case sensitive
or contains special characters. In a CDB environment, this script
must be executed from the CDB$ROOT container and the mining user
must be a common user.
=========================== WARNING ==========================
You MUST stop all Integrated Captures that belong to this mining
user before proceeding!
================================================================
Enter Integrated Capture mining user: goldengate ## 數(shù)據(jù)庫里的ogg運行用戶
Installing workaround...
No errors.
No errors.
No errors.
Installation completed.
SQL>
SQL>
錯誤信息:
20XX-05-31 00:59:54 ERROR OGG-25127 Received an error
reply requesting a graceful shutdown. (Reply received is GSOutput file /data/goldengate/trail/us000000 is not in any
allowed output directories..).
20XX-05-31 00:59:54 ERROR OGG-01668 PROCESS ABENDING.
處理辦法:
配置允許的文件路徑:
EDIT PARAMS ./GLOBALS
ALLOWOUTPUTDIR /data/goldengate/trail
不支持的對象
dblink
GoldenGate可以通過復制源表支持對于同義詞或者DBLink的復制。由于對于這些對象本身的操作發(fā)生于其所鏈接的源數(shù)據(jù)庫對象,數(shù)據(jù)庫日志中并不記錄對這些鏈接目標對象的操作,因此GoldenGate不復制對同義詞或者DBLink本身的操作,但這些操作會應用在源表上并產(chǎn)生日志,因此可以通過復制源表復制變化。
create job 不支持復制。
create trigger 是可以復制的,且enable狀態(tài),所以必須手工設置為disable或replicat參數(shù)(DBOPTIONS SUPPRESSTRIGGERS)。
create tablespace 可以復制,支持路徑轉(zhuǎn)換,eg: DDLSUBST SREDATADG with TARDATADG。
cast語句(create table as select * from cat),按本地數(shù)據(jù)執(zhí)行,因此可能主庫和備庫數(shù)據(jù)不一致。
flashback table * to scn **** -- 可以支持復制。
flashback table * to before drop -- 不支持復制。
遠程霧化視圖,需要網(wǎng)絡連通,--涉及到的dblink需要手工創(chuàng)建 。
END
文章版權(quán)歸作者所有,未經(jīng)允許請勿轉(zhuǎn)載,若此文章存在違規(guī)行為,您可以聯(lián)系管理員刪除。
轉(zhuǎn)載請注明本文地址:http://specialneedsforspecialkids.com/yun/129533.html
OGG Integrated Native DDL簡單測試 img{ display:block; margin:0 auto !important; width:100%; } body{ width:75%;...
摘要:編碼結(jié)束后,調(diào)用函數(shù),來銷毀和編碼器。調(diào)用函數(shù)對參數(shù)中的格式音頻數(shù)據(jù)幀進行解碼,參數(shù)中存放解碼后的音頻數(shù)據(jù)幀。調(diào)用函數(shù)來銷毀和解碼器說重點當做即時通信產(chǎn)品,像微信這種的手機端,它們接受到很有可能就是協(xié)議壓縮后的音頻文件。 showImg(https://segmentfault.com/img/bVbtzkh?w=1024&h=682); 這么牛逼的輪子,肯定要美圖鎮(zhèn)樓 Speex是一...
閱讀 1347·2023-01-11 13:20
閱讀 1686·2023-01-11 13:20
閱讀 1133·2023-01-11 13:20
閱讀 1860·2023-01-11 13:20
閱讀 4103·2023-01-11 13:20
閱讀 2705·2023-01-11 13:20
閱讀 1386·2023-01-11 13:20
閱讀 3599·2023-01-11 13:20