1 Reply Latest reply on Feb 24, 2012 12:50 PM by Balazs Papp

    Reporting database creation without purging any data

    User488092-OC
      We want to create a reporting database where no 'Purge' operation can be performed & all the records will be retained .Production DB & reporting DB are at different geographic location.In this scenario; what tool should be used for replication ? Can we achieve this using Data guard ? Can streaming be done over the WAN ? Does streaming has lot of overheads due to which performance may get hampered
        • 1. Re: Reporting database creation without purging any data
          Balazs Papp
          Can we achieve this using Data guard ?
          no
          Can streaming be done over the WAN ?
          sure
          Does streaming has lot of overheads due to which performance may get hampered
          in a downstream scenario, all you have to do is to transport the archivelogs to other site, both capture and apply is done on the target site, no overhead on source site (however processing can be quite demanding on the target site)
          you can write your own DDL/DML handlers according to your needs