Export a replica-creation packet
You create a replica by generating replica-creation packets and sending them to the sites that will host the database replicas. You do this with the mkreplica –export command.
During the export phase of replica creation, the replica creation command locks the database while copying it. The database is locked for the entire length of time the command runs; logins are not allowed.
- Verify that no users are logged in to the database. If users are logged in to the database during a mkreplica –export, any changes they make even after the database is unlocked are lost.
- Upgrade the database to use the most recent version of the schema.
- Verify that the data code page value is set to the code page used by the site that will import the replica creation packet. If the code pages are incompatible, packet import fails.
The time required to create the packet depends on the size of the database and can be up to twice as long as the time required to make a copy of the database or run a backup procedure. Therefore, you must schedule the export phase of replica creation during nonbusiness hours for your site. You must also cancel any scheduled backups for the duration of the export phase.
multiutil mkreplica –export –clan telecomm –site boston_hub –family PRODA
–user susan –password passwd –maxsize 50m –fship –workdir c:\temp\packets
–sclass cq_default goldengate:sanfran_hub