{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"align","parameters":{"macroParams":{"atlassian-macro-output-type":{"value":"BLOCK"}},"macroMetadata":{"schemaVersion":{"value":"1"},"title":"Align"}}},"content":[{"type":"paragraph","content":[{"text":"Dbvisit Standby must be scheduled on both the primary (all primary RAC nodes) ","type":"text"},{"text":"and","type":"text","marks":[{"type":"strong"}]},{"text":" standby servers. ","type":"text"}]},{"type":"paragraph","content":[{"text":"It is possible to schedule Dbvisit only on the ","type":"text"},{"text":"primary","type":"text","marks":[{"type":"strong"}]},{"text":" server using the INITIATE_DBVISIT_ON_STANDBY variable. Ensure you understand the implication before using this feature. See variable INITIATE_DBVISIT_ON_STANDBY ","type":"text"},{"text":"in the ","type":"text"},{"text":" ","type":"text"},{"text":"Dbvisit Standby configuration variables (DDC)","type":"text","marks":[{"type":"link","attrs":{"href":"https://dbvisit.atlassian.net/wiki/spaces/dbdc/pages/591159"}}]},{"text":" ","type":"text"},{"text":" section ","type":"text"},{"text":"for more details.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Preferred scheduling method","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"},{"text":"Dbvisit Standby can be scheduled using Dbvserver (see ","type":"text"},{"text":"Scheduling Dbvisit Standby with Dbvserver scheduler - all platforms","type":"text","marks":[{"type":"link","attrs":{"href":"https://dbvisit.atlassian.net/wiki/spaces/dbdc/pages/591134"}},{"type":"strong"}]},{"text":").","type":"text"},{"type":"hardBreak"},{"text":"If Dbvisit Standby is scheduled in Dbvserver then ","type":"text"},{"text":"no","type":"text","marks":[{"type":"strong"}]},{"text":" other scheduling software is required.","type":"text"},{"type":"hardBreak"},{"type":"hardBreak"},{"text":"A decision must on the maximum time that the standby database may be behind the primary database. This is a business decision, but certain factors play a key role. These are:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Speed of the network","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Activity on the database","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Speed of the disks","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Compression method chosen and CPU power to compress and uncompress archive log files.","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"A good recommended time frame is to schedule Dbvisit Standby every 10 minutes on both the primary and standby servers. ","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Using CRON to schedule Dbvisit Standby","type":"text"}]},{"type":"paragraph","content":[{"text":"If Dbvserver is not running, then Dbvisit Standby can be scheduled in cron or other scheduling software. ","type":"text"}]},{"type":"paragraph","content":[{"text":"To schedule Dbvisit Standby, add a cron entry to the Oracle software owner on both the ","type":"text"},{"text":"primary and standby server.","type":"text","marks":[{"type":"strong"}]},{"text":" This entry will run 24x7 and every 10 minutes. It is recommended that the standby cron is scheduled a little later than the primary cron. This ensures there are log files to be applied when Dbvisit Standby executes on the standby server.","type":"text"},{"type":"hardBreak"},{"text":"To edit the cron type in crontab -e","type":"text"}]}]},{"type":"paragraph","content":[{"text":"Primary server:","type":"text","marks":[{"type":"strong"}]}]},{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"legacy-content","text":"","parameters":{"nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"width":{"value":"5%"}},"macroMetadata":{"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"text":" ","type":"text"}]}]}],"version":1},"reason":"A column macro in a rich body macro can't be created or edited in the new editor.","cxhtml":"5%

"}}},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"legacy-content","text":"","parameters":{"nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"width":{"value":"95"}},"macroMetadata":{"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"panel","attrs":{"panelColor":"CCC","panelType":"custom"},"content":[{"type":"paragraph","content":[{"text":"# Dbvisit - Standby Database Technology from Avisit Solutions Limited ","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":"00,10,20,30,40,50 * * * * /usr/local/dbvisit/standby/dbvisit dbvisitp >>/dev/null 2>&1","type":"text","marks":[{"type":"code"}]}]}]},{"type":"paragraph","content":[{"text":"Where Dbvisitp is the name of the database and Dbvisit Standby is installed in the /usr/local/dbvisit/standby directory.","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":">>/dev/null 2>&1 is optional.","type":"text","marks":[{"type":"code"}]}]}]}],"version":1},"reason":"A column macro in a rich body macro can't be created or edited in the new editor.","cxhtml":"95

CCC

# Dbvisit - Standby Database Technology from Avisit Solutions Limited 
00,10,20,30,40,50 * * * * /usr/local/dbvisit/standby/dbvisit dbvisitp >>/dev/null 2>&1

Where Dbvisitp is the name of the database and Dbvisit Standby is installed in the /usr/local/dbvisit/standby directory.

>>/dev/null 2>&1 is optional.

"}}}]},{"type":"paragraph","content":[{"text":"Standby server:","type":"text","marks":[{"type":"strong"}]}]},{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"legacy-content","text":"","parameters":{"nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"width":{"value":"5%"}},"macroMetadata":{"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"text":" ","type":"text"}]}]}],"version":1},"reason":"A column macro in a rich body macro can't be created or edited in the new editor.","cxhtml":"5%

"}}},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"legacy-content","text":"","parameters":{"nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"width":{"value":"95"}},"macroMetadata":{"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"panel","attrs":{"panelColor":"CCC","panelType":"custom"},"content":[{"type":"paragraph","content":[{"text":"#Dbvisit - Standby Database Technology from Avisit Solutions Limited ","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":"05,15,25,35,45,55 * * * * /usr/local/dbvisit/standby/dbvisit dbvisitp >>/dev/null 2>&1","type":"text","marks":[{"type":"code"}]}]}]},{"type":"paragraph","content":[{"text":"Where Dbvisitp is the name of the database and Dbvisit Standby is installed in the /usr/local/dbvisit/standby directory.","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":">>/dev/null 2>&1 is optional.","type":"text","marks":[{"type":"code"}]}]}]}],"version":1},"reason":"A column macro in a rich body macro can't be created or edited in the new editor.","cxhtml":"95

CCC

#Dbvisit - Standby Database Technology from Avisit Solutions Limited 
05,15,25,35,45,55 * * * * /usr/local/dbvisit/standby/dbvisit dbvisitp >>/dev/null 2>&1

Where Dbvisitp is the name of the database and Dbvisit Standby is installed in the /usr/local/dbvisit/standby directory.

>>/dev/null 2>&1 is optional.

"}}}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"Dbvisit Standby must be scheduled on both the primary and standby server.","type":"text"}]}]},{"type":"paragraph","content":[{"text":"Oracle RAC","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":" 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:","type":"text"},{"type":"hardBreak"},{"text":" node1 – Schedule every hour at 00, 15, 30, 45","type":"text"},{"type":"hardBreak"},{"text":" node2 – Schedule every hour at 05, 20, 35, 50","type":"text"}]}],"version":1}

Scheduling Dbvisit Standby - Linux/Unix