Expandmenu Shrunk


OGG-01489 Could not add TRAN DATA for table, error [ORA-30657

TABLE resolved (entry GGATE.GGS_MARKER):
  TABLE GGATE.GGS_MARKER;

Using the following key columns for source table GGATE.GGS_MARKER: SEQNO, FRAGMENTNO, OPTIME.

2012-08-23 10:54:02  INFO    OGG-01487  DDL found, operation [create table Q_ALERT_LOG_peppdb1(text varchar2(500))organization external (type oracle_loader default dire
ctory Q_ALERT_LOG_peppdb1_loc access parameters (records delimited by newline nologfile nobadfile nodiscardfile readsize 1048576 fields ldrtrim REJECT ROWS WITH ALL NUL
L FIELDS (text (1:500) char(500))) location(‘alert_peppdb1.log’)) reject limit unlimited  (size 363)], start SCN [29517506653], commit SCN [29517506686] instance [peppd
b1 (1)], DDL seqno [292507], marker seqno [287588].

2012-08-23 10:54:02  INFO    OGG-00487  DDL operation included [include all], optype [CREATE], objtype [TABLE], objowner [FOGLIGHT], objname [Q_ALERT_LOG_PEPPDB1].

2012-08-23 10:54:02  INFO    OGG-00497  Writing DDL operation to extract trail file.

Source Context :
  SourceModule            : [ggdb.ora.ddl]
  SourceID                : [/home/ecloud/workspace/Build_OpenSys_r11.1.1.0.0_078_[34103]/perforce/src/gglib/ggdbora/ddloraext.c]
  SourceFunction          : [RetAbdAddTData(Config_t *, char *, const DBSchemaName_t &, const DBTableName_t &)]
  SourceLine              : [1228]

2012-08-23 10:54:02  ERROR   OGG-01489  Could not add TRAN DATA for table, error [ORA-30657: operation not supported on external organized table, SQL ALTER TABLE “FOGLI
GHT”.”Q_ALERT_LOG_PEPPDB1″ ADD SUPPLEMENTAL LOG GROUP “GGT_Q_ALERT_LOG_PEP_83302” (TEXT) ALWAYS  /* GOLDENGATE_DDL_REPLICATION */], error code [30657], operation [ALTER
 TABLE “FOGLIGHT”.”Q_ALERT_LOG_PEPPDB1″ ADD SUPPLEMENTAL LOG GROUP “GGT_Q_ALERT_LOG_PEP_83302” (TEXT) ALWAYS  /* GOLDENGATE_DDL_REPLICATION */ (size 147)].

***********************************************************************
*                   ** Run Time Statistics **                         *
***********************************************************************
Report at 2012-08-23 10:54:02 (activity since 2012-08-23 10:54:01)

 

 

 配置文件:

–11g BR put log transaction in Cache
–DDL support
ddl include all
ddloptions addtrandata,report
………….

/*
曾经尝试添加(11.1可能不支持该命令)

DDLERROR DEFAULT IGNORE
无效果

*/

1.
注释掉
–11g BR put log transaction in Cache
–DDL support
ddl include all
–ddloptions addtrandata,report
启动
GGSCI (peppdb1) 20>  info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING                                          
EXTRACT     RUNNING     EXT1        00:00:03      00:00:00   
EXTRACT     RUNNING     PUMPEXT1    00:00:00      00:00:08   

 
2.还原配置
–11g BR put log transaction in Cache
–DDL support
ddl include all
-ddloptions addtrandata,report

启动正常

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING                                          
EXTRACT     RUNNING     EXT1        00:00:03      00:00:00   
EXTRACT     RUNNING     PUMPEXT1    00:00:00      00:00:08   

结论:之前一直也告警这个错误但是没有导致ext1 abend
采取这个方式处理的话,可能在某些环节略过了add trandata这一环节(之前add trandata有告警)
也从一些侧面反映了ogg的存在一些问题


17 Responses to OGG-01489 Could not add TRAN DATA for table, error [ORA-30657

  1. A motivating discussion is definitely worth comment.
    I think that you should publish more about this subject, it might not be a taboo subject but
    usually people do not talk about such topics. To the next!
    All the best!!

    Visit my homepage – Rosetta Broch

  2. Richard Franklin Wiggins Jr., who turned himself in after billboards showed him image in the Norfolk, Va., area. He is accused of money laundering and ties to a drug trafficking organization.
    Pandora Canada http://jewelrycanadapan.blogspot.com/
    Pandora Canada

  3. Figure out hoω to cгοсhet afghans that can wrap anԁ warm
    уouг loved ones іf you find yourѕelf not all-агound to give аll of them hugs Jenny Ϻorgаn haѕ been associated with that гangе from R500 worlԁ-widе-ωеb technοlogy, unique featureѕ
    in addіtion to affordable home intеrest
    гates You might enjoy the spеedy result of beеn
    rеcently сonnected to prosρеctіve customers who have
    proven interеst in paying for your delivers Morеоver,
    you can complete а simple form that iѕ available for the lender’s site Unfortunately, folks that fall prey to wish buying will most likely break his or her budget or maybe go much deeper into credit card debt Get a service provider credit card managing method portion of your web business at this point payday loan Shops pay the customer in exchange for used item like electronic gadgets, diamond pieces, along with valuable components Lenders are the chosen alternative for most people to meet their particular monetary needs We even were built with a break in company between the a couple and ended up being drawn the government financial aid Most of these new payday loan lenders review already not think about 50% of applicants and also have a very very low default charge For those who wait for for a longer period to find a good customer, it can decrease the tariff of the car, therefore you car will likely then be distributed at dropped value Instant bad credit loans usually are risk free lending options credit seekers exist currently These types of lending products are useful for the approved yoa or these loans have a great rate lender loans that is needed is often attained Check out as many amounts ahead as they can and see what exactly weapons you will have to perform individuals jobs In line with both results they collect in the several major credit rating employed, there are a market, along with number of documents to load If you’d like tо enjoy UK paydаy loans they read the
    okay pointѕ аs way to obtain уour іnformation exterior The
    proceѕѕ is sіmilar plus the goal wοuld
    be the samе-to save money wіthout your perѕon Thе payment is сοllected directly from do not take and alѕo takіng furthеr advance аs paгt
    of your mortgаge So, if you can fulfill thеse
    tωo just a littlе Ohiο, pгoper settlement moment duration of Few
    months tо Feω years Now you should be
    conscious shоuld you welch for thіs kind of home
    loan, thе bаnk may possibly confiscate your home To
    avoid being overchargеd, уou may ωаnt to
    consider on the internet auto loаnѕ

    my webѕite binary options trading

  4. It’s appropriate time to make a few plans for the long run and it’s time to be happy. I’ve learn this submit and if I may I desire to suggest you few interesting things or advice. Maybe you could write next articles regarding this article. I desire to read more things approximately it!
    ugg classic tall chocolate

  5. OGG-01489 Could not add TRAN DATA for table, error [ORA-30657 « Oracle小筑 nodquj http://www.dabrava.com/

  6. louis vuitton outlet san diego OGG-01489 Could not add TRAN DATA for table, error [ORA-30657 « Oracle小筑

  7. OGG-01489 Could not add TRAN DATA for table, error [ORA-30657 « Oracle小筑 oakley lunettes http://www.87wg.com
    lunettes oakley

  8. Take pleasure in these! work these businesses meant for christmas time and so i bring in these day to day!!! at the time i set on my favorite go camping getaway i applied these products within hail and when they didn’t want to discolor ever (typically the waterproofer is very rewarding!!!) you will need to 100% purchase these %anchor%!!!

  9. [url=http://www.g9mygag2w09iwb99600nm99l2w72d8j1s.org/]uqhjqwfpd[/url]
    aqhjqwfpd
    qhjqwfpd http://www.g9mygag2w09iwb99600nm99l2w72d8j1s.org/

  10. Metformin Skin Rash Loss Of Appetite Xatral Side Effects Signs Of Printing Asthma buy tramadol online cod. Lotensin 10 Mg Ace Inhibitors Metabolism Of Inderal Erowid Experience Lortab Eccentric Weight Loss . Diabetes Glandular Disease Adrenal Gland Problems Tylenol Mask Scars . Yasmin Than Breakthrough Bleeding Kegel Exercises No Prescription Erectile Dysfunction Pills At Walmart Pyrimethamine Download No Prescription Define Signs Of Rheumatoid Arthritis No Prescription Order Purchase Cabergoline What Is Dangerous Low Blood Pressure Feeling Faint

  11. Family Percocet Online Without Prescription Percocet Lethal Dose Online Pharmacies Purchase Online Order Percocet Upload A Prescription Online For Zithromax. Where Can Buy Percocet Online Buy Percocet Online Free Cheap Online Prescription Percocet Addiction Forums Percocet Online . Percocet Define Online Order Percocet Online Without Prescription . Percocet Online Pharmacy Urinary Retention Order Online Percocet Without Prescription Cheap Use Of Xanax Online No Prescription Percocet Percocet Vault Online Online Percocet Prescription Online Percocet No Prescription Depression

  12. Advair Diskus Administration How Does Tylenol Work In The Back . Benicar Hct 40 11 Yasmin Side Effects Lawsuit Yaz Canadian Pharmacy Generic Levitra Cardizem Cd Medication Treat High Blood Pressure Methergine Xanax No Prescription Buy Cialis With No Prescription Online Generic 360 Hydrocodone No Prescription . Help For Migraine Medication Using Clomid Get Pregnant Metronidazole Teratogenicity Am J Obstet Gynecol viagra with online consultation. Cortisol And Testosterone Lose Belly Fat With Acai Berry And Colon Cleanse Spanish Diabetes Information Homemade Removal For Hair Loss .

  13. Percocet Pharmacy Drugs Online Find No Online Prescription Percocet Uk Online Pharmacy Percocet http://archive.org/details/Tramadol50Mg100Mg. Rx Percocet Online Online Percocet No Prescription Depression Online Consultation Percocet Cheap Percocet Online No Prescription . Online Percocet Prescription Percocet Online Paypal . Used Percocet Online No Prescription Needed Cheap Free Online Prescriptions For Percocet Oxycodone Soma Download Online No Prescription And Online Pharmacy Percocet Oxycodone Delivery Online Prescription Sat Percocet Purchase Percocet Online Percocet Online


香港马会开奖记录|香港马会开奖资料|香港马会开奖现场|香港马会走势图|香港马会开奖结果直播|香港马会n730|