Inserting data to generating archive logs
For testing purposes, Dbvisit has the facility to create test data. This simulates the loading of the databases with data to generate new archive logs. Dbvisit can then be tested with “full” archive logs to determine if the network and hardware is sufficient to be able to handle the capacity.

To generate test data use the dbv_functions -T option:

dbv_functions -T w120n
>>> Creating test table and inserting test data into w120n.
Test table dbvisit.dbv_test_data created.
Test table dbvisit.dbv_test_data dropped.

The data is inserted into a new table created in the Dbvisit database schema and then the table is dropped after completion of the insert to ensure that the database is left in the same state as when the command was started.

To add more data, a cycle number can be given:

dbv_functions -T w120n 2
>>> Creating test table and inserting test data into w120n.
Test table dbvisit.dbv_test_data created.
Insert cycle 1 completed. Rows inserted: 49974
Insert cycle 2 completed. Rows inserted: 99948
Test table dbvisit.dbv_test_data dropped.

This has added 99,948 rows and then dropped the table.

The higher the cycle number, the more data is added:

dbv_functions -T w120n 5
>>> Creating test table and inserting test data into w120n.
Test table dbvisit.dbv_test_data created.
Insert cycle 1 completed. Rows inserted: 49974
Insert cycle 2 completed. Rows inserted: 99948
Insert cycle 3 completed. Rows inserted: 199896
Insert cycle 4 completed. Rows inserted: 399792
Insert cycle 5 completed. Rows inserted: 799584
Test table dbvisit.dbv_test_data dropped.

This has added 799,584 records to the database, and then dropped the table.

After running the command, Dbvisit can be run as normal to transfer the archive log files to the standby server.
To see the size of the archive logs and statistics of the transfer see http://blog.dbvisit.com/dbvisit-tip-of-the-week-1/