This discussion is archived
1 Reply Latest reply: Feb 24, 2012 4:50 AM by Balazs Papp RSS

Reporting database creation without purging any data

User488092-OC Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points