7 Replies Latest reply: Mar 8, 2013 6:14 PM by jgarry RSS

    How to capture TXs from Archive Logs to replay them on 10g database

    user10651321
      Hi Experts,

      I am looking for a way to capture a TXs from one database and create a script or use it with tool, so we can capture TXs close to production while testing changes being impleted in database.

      Env:

      OS: Redhat Linux 5.0
      DB: 10.2.0.4

      Actualy Requirement: We have active-active Golden Gate setup done for one of our DB and once a quater we make changes in the database using DDL (CREATE / ALTER - TABLES, FUNCTIONS, TRIGGERS, etc). We are 24/7 environment and hence no downtime is affordable. What I like to know is a way to capture all TXs from one of the DB and create a script so we can run them while we are testing new changes in the database. Something like DBMS_WORKLOAD_CAPTURE Package (Available only after 11gR1) or some tools available in the market.

      I also tried loking into LoadRunner but felt it works with App tier than DB, I may be wrong there.

      Please guide me with this requirement.

      Apprecaite all the help in advance.

      Regards,
      MS