Dear All,
We have a primary running continous archiving to a secondary. We managed to test fail-over to the secondary by stopping the database in the primary. Then some transactions were tested in the secondary. It was acting well as a primary to accept both read and write.
Now we want to revert this acting primary back to secondary and bring up the actual primary. We know that the secondary had gone out of synch in ahead of primary. So we do a PITR in this secondary before the time when the initial primary was brought down. Now the primary is up and the secondary is brought up as hot-standby. The secondary complaints that it cannot recover because its Timeline 2 does not match with the Timeline 1 of the primary.
How can this be resolved?
Thank you.
Regards,
Selvam