OGG server #1
***************************- ogg-srv01.oracak.ru
1. After completing the initial load, it is necessary to start the change-synchronization replicat r_quik2
[oracle] $>
. ~/.profile.postgres.gg21
./ggsci
ggsci>
start r_quik2
2. Start the change-synchronization REPLICAT on the target system after verifying the completion of the initial load
OGG server #1
***************************
- ogg-srv01.oracak.ru
ggsci>
start replicat r_quik2, atcsn 18/18A8BC08
info all
3. Check for errors in the log
[oracle] $>
. ~/.profile.postgres.gg21
tail -100f $GG/ggserr.log
4. Verify the number of rows in replicated tables
-- Quantitative comparison of rows
select 'BONDS',count(*) from stock.BONDS union
select 'BONDS_ARCH',count(*) from stock.BONDS_ARCH union
select 'BONDS_SETTING',count(*) from stock.BONDS_SETTING union
select 'BONDS_SETTING_ARCH',count(*) from stock.BONDS_SETTING_ARCH union
select 'BONDS_ZAJVKA',count(*) from stock.BONDS_ZAJVKA union
select 'BONDS_ZAJVKA_ARCH',count(*) from stock.BONDS_ZAJVKA_ARCH union
select 'CLIENT_ACCOUNT',count(*) from stock.CLIENT_ACCOUNT union
select 'CLIENT_ACCOUNT_ARCH',count(*) from stock.CLIENT_ACCOUNT_ARCH union
select 'DIVIDENTS',count(*) from stock.DIVIDENTS union
select 'JOB_LOGS',count(*) from stock.JOB_LOGS union
select 'PORTFOLIO',count(*) from stock.PORTFOLIO union
select 'PORTFOLIO_ARCH',count(*) from stock.PORTFOLIO_ARCH union
select 'QUOTES',count(*) from stock.QUOTES union
select 'QUOTES_ANALYST_15M',count(*) from stock.QUOTES_ANALYST_15M union
select 'QUOTES_ANALYST_1D',count(*) from stock.QUOTES_ANALYST_1D union
select 'QUOTES_ANALYST_1H',count(*) from stock.QUOTES_ANALYST_1H union
select 'QUOTES_ARCH',count(*) from stock.QUOTES_ARCH union
select 'QUOTES_VOLUME',count(*) from stock.QUOTES_VOLUME union
select 'QUOTES_VOLUME_ARCH',count(*) from stock.QUOTES_VOLUME_ARCH union
select 'REPORT_BENEFIT',count(*) from stock.REPORT_BENEFIT union
select 'REPORT_BENEFIT_COMPARATOR',count(*) from stock.REPORT_BENEFIT_COMPARATOR union
select 'REPORT_EDU',count(*) from stock.REPORT_EDU union
select 'REPORT_EDU_COMPARATOR',count(*) from stock.REPORT_EDU_COMPARATOR union
select 'SDELKA',count(*) from stock.SDELKA union
select 'SDELKA_ARCH',count(*) from stock.SDELKA_ARCH union
select 'SIGNAL',count(*) from stock.SIGNAL union
select 'SIGNAL_ARCH',count(*) from stock.SIGNAL_ARCH union
select 'TRADING_EDU',count(*) from stock.TRADING_EDU union
select 'TRADING_PROD',count(*) from stock.TRADING_PROD union
select 'TRADING_PROD_ARCH',count(*) from stock.TRADING_PROD_ARCH order by 1;
<<< Back Next >>>
