...
| No Format |
|---|
APPLY is waiting for first redo log switch, initialization NOT yet complete. |
Please check the following:
...
| No Format |
|---|
dbvrep> healthcheck ERROR: Could not connect to APPLY, it is down or unreachable. (Connection refused) Connectivity test for APPLY: FAILED ERROR: Could not connect to APPLY, it is down or unreachable. (Connection refused) Connectivity test for MINE: PASSED 2 processes checked. |
2) . Find out which ports are being used and ensure all ports listed above are open on the specific servers.
...
Please see APPLY (or MINE) cannot connect - connectivity issues for more information.
3) . Find out the internal tables have been replicated. The Applied records should match the Mine records and show 100%:
| No Format |
|---|
dbvrep> list progress all Progress of replication d112F: total/this execution -------------------------------------------------------------------------------------------------------------------------------------------- DBVREP.DBRSOBJ$: 100% Mine:75679/75679 Unrecov:0/0 Applied:75679/75679 Conflicts:0/0 Last:25/11/2013 21:48:37/OK DBVREP.DBRSUSER$: 100% Mine:103/103 Unrecov:0/0 Applied:103/103 Conflicts:0/0 Last:25/11/2013 11:41:01/OK -------------------------------------------------------------------------------------------------------------------------------------------- |
4) . Are all tables not being replicated or just a subset? If a subset is replicated, please ensure all the tables to be prepared are known to Dbvisit Replicate. Use the "list prepare" to check which tables are known to Dbvisit Replicate.
| No Format |
|---|
dbvrep>list prepare |
| Note |
|---|
...
When the apply process is not run as the default APPLY, then use the "CHOOSE REPLICATION" command to choose the appropriate process. For example, if the process is called APPLY2, then use "CHOOSE REPLICATION APPLY2" |
5) . Check that the particular table exists in the Dbvisit Replicate data dictionary table. The following query on the run as the Dbvisit Replicate owner on the target database can be run to verify:
...
Only the tables listed in this table will be replicated. To replicate other tables use the PREPARE command.