At times this question arises about the need to stop Post after has processed transactions up to a specific SCN number from source. This solution delves on the feasibility of it.
General information.
It is not possible to direct the Post process to stop after it has processed transactions up to a specific SCN number from source. There is an indirect way to achieve this. Here are the steps:
1. Quiet the source database.
2. Note the last SCN #.
3. Issue flush from source database as below:
sp_ctrl>flush o.SID (where SID denotes the Oracle SID of the source)
4. Open the database for users.
5. The Post will stop due to flush. It would have processed the transactions up to the SCN # noted in step 2.
6. Start Post after having completed any maintenance/tasks that were to be done on target.
The point to be noted here is that the procedure requires downtime on source database. Moreover, it does not stop Post on any SCN # as desired by the user but only on a specific SCN that was the last SCN prior to downtime on the source database.
Â
