Unanswered: How to put database in rollforward pending ?
We have a requirement on our mirror to rollforward the mirror to 5:30pm for today. In production a table was truncated mistakenly. Even though table data was recovered from some live data available, the QA team wants to test this recovered table against data just before the truncation.
So mirror was restored today morning. How can get existing mirror DB to rollforward to point in time to 5:30pm ??
I needed to know that previously restored database cannot be carried on to point-in-time in future. Getting logs from production.
That is not logical either, but is there a kind of trick that once rollforward completed database could be put into rollforward state and the rollforward further to 5:30 pm. I need only one table which is in one tablespace.