Initializing the Transaction Logs

When you initialize a transaction log, you must ensure that all of the data is processed by Oracle GoldenGate first, and then you must delete and re-add the Extract group and its associated trail.

Stop the application from accessing the database. This stops more transaction data from being logged.
Connect the Admin Client command line using the CONNECT command.
Issue the SEND EXTRACT command with the LOGEND option for the primary Extract group. This command queries Extract to determine whether or not Extract is finished processing the records that remain in the transaction log.
```
SEND EXTRACT group LOGEND
```
Continue issuing the command until it returns a YES status, indicating that there are no more records to process.
On the target system, issue the SEND REPLICAT command with the STATUS option. This command queries Replicat to determine whether or not it is finished processing the data that remains in the trail.
```
SEND REPLICAT group STATUS
```

Continue issuing the command until it shows 0 records in the current transaction, for example:

Sending STATUS request to REPLICAT REPSTAB...
Current status:
  Seqno 0, Rba 9035
  0 records in current transaction.

Stop the primary Extract group, and the Replicat group.
```
STOP EXTRACT group
STOP REPLICAT group
```

Delete the Extract and Replicat groups.

DELETE EXTRACT group
DELETE REPLICAT group

Using standard operating system commands, delete the trail files.
Stop the database.
Initialize and restart the database.
Recreate the primary Extract group.
```
ADD EXTRACT group TRANLOG, BEGIN NOW
```
Recreate the local trail (if used).
```
ADD EXTTRAIL trail, EXTRACT group
```
Recreate the remote trail.
```
ADD RMTTRAIL trail, EXTRACT group
```
Recreate the Replicat group.
```
ADD REPLICAT group, EXTTRAIL trail
```

Start Extract and Replicat.

START EXTRACT group 
START REPLICAT group