Transactional to Reporting DB replication

 Hey Guys, Here is the setup running on 11.2.0.2 and the key requirements

1. Primary/Transactional database running RAC. As part of the application requirements, data in this database will be held to a maximum of 2 years - for data in the tables. Most tables are interval partitioned and partitions get dropped off periodically. All good here
2. We now need to create a Reporting database with exactly the same schema setup as the transactional. Data needs to flow from the Transactional system 'periodically' - a suitable 'lag' is yet to be determined. The key requirement for this database is that there is no purging of data as it happens in the Transactional database. In other words, you could have data in this database spanning 10+ years