DR using Data Guard Exercise
We will be going through a DR exercise using DataGuard in an EBS 12.0.6 on a database 10.2.0.5 environment. In this exercise we want to simulate a failover in which the secondary database takes over and we keep it like that for some tests. That would not be difficult. We do not want to touch Production.
The difficult question is (and this maybe a bit stupid) is there a way to bring it back as secondary database without going through a new backup restore procedure which is a a longterm job.
Say at 7am we simulate the failover and the secondary DG database becomes a primary. The network is like interrupted. Than, at 9am, we roll back the dataguard database as secondary of the primary. I remember reading something as possible, but I cannot find it.