Once Dbvisit Standby has been tested manually and is functioning correctly, it should be scheduled to ensure the standby database is automatically updated.
Schedule Dbvisit Standby through Task Scheduler in windows or other scheduling tool on both the primary and standby server to fully automate and complete the Dbvisit Standby process. How often Dbvisit Standby is scheduled will be an individual choice.
Dbvisit Standby can also be scheduled using the build in scheduler with Dbvserver.
Choose Scheduling through either Task Scheduler or DBSERVER to schedule Dbvisit Standby - NOT BOTH
Scheduling Dbvisit Standby through Task Scheduler
1. Ensure the Task Scheduler service is started.
2. Open the Scheduled Tasks.
3. Click on "Add Scheduled Task"
4. In the Scheduled Task Wizard click on "Browse".
5. Find the Dbvisit Standby executable.
6. Type a name for the task. Type "Dbvisit <DDC>" (in example below the database name is w102n). Select "Perform this task: Daily". Click Next.
7. Select the time and day you want the task to start. Select "Every day". The start time and start date do not need to be changed if you want the task to start straight away. Click Next.
8. Enter the password of the current user. That will be the user that will run Dbvisit Standby. Click Next.
9. Tick the box "Open advanced properties….". Click on Finish.
10. Add the database name as the first parameter to the Dbvisit Standby executable. In this example the database name is w102n.
11. Click on the "Schedule" tab, and then on "Advanced".
12. Specify "Repeat Task". If you want to execute Dbvisit Standby every 10 minutes, then select 10 minutes. Otherwise select another interval. Always ensure the "Duration" is set to 24 hours for daily tasks.
13. Click on OK. The new schedule will be shown. Click on OK.
14. The new task will now be shown.
15. Repeat the same on standby server.
16. Dbvisit Standby is now scheduled on the primary and the standby server.
17. The schedule will continue to be active in the background when the users logs off.
Oracle RAC
Dbvisit Standby needs to be scheduled separately on each primary node in the Oracle RAC. It is recommended that Dbvisit Standby is scheduled at different times on each node. For example:
node1 – Schedule every hour at 00, 15, 30, 45
node2 – Schedule every hour at 05, 20, 35, 50
Dbvserver - Scheduling Dbvisit Standby through build in scheduler.
Dbvisit Standby can be scheduled in the build in scheduler that comes with Dbvserver. This does require the dbvserverd process to be running at all times on both the primary and standby servers.
1. Choose Run from the main menu.
2. Choose Run Interactive.
3. Click on Primary Server tab set schedule and click on Save Schedule.
4. Click on Standby Server tab set schedule and click on Save Schedule.
The dbvserverd process must be running on the standby server.