This content has been marked as final. Show 1 reply
Maybe a very simple way would be to stop the processes on your target database and start them at specified time.
The problem would be to know the time when stopping them again...
- at 2am you stop the capture process with: exec DBMS_CAPTURE_ADM.START_CAPTURE('+capture_name+');
- then at 3pm, you stop the process again with: exec DBMS_CAPTURE_ADM.STOP_CAPTURE('+capture_name+');
You would have to check if 1 hour is sufficient to capture all the data made in the day... and don't delete ArchiveLog before...