A standby database can be used to create the target database to ensure that the data is same as the source database before the replication starts. Using standby database for data instantiation is a wise choice when almost every schema of the source database is to be replicated. Once the standby database is ready, select a particular SCN to start replication from and recover the standby database up to that SCN. You can then run the setup wizard of Dbvisit Replicate to configure the replication.
Example
...
| Server/Database | Name |
|---|---|
| Source database | reptest1 |
| Source server | dbvldemo101 (Linux) |
| Standby/Target database | reptest2 |
| Target server | dbvldemo102(Linux) |
| TNS alias for source database | reptest1 |
| TNS alias for target database | reptest2 |
1. Create the standby database using RMAN or by using Dbvisit Standby
2. Once confirm that no transactions are pending on the source database and all the tables to be replicated are idle, get the current SCN.
...