dmarchivelogavailable - Mark archive log as available

Use this command only after the complete Oracle archive log file has been shipped from the system where your Oracle database is installed. By issuing this command, you are indicating to CDC Replication that the shipped Oracle archive log file is complete and can now be used for replication.

Note: You do not need to run this command if you are using Oracle Data Guard to ship your archived logs. This command is only necessary if you are using scripts or some other method to ship your archived logs to a secondary system that is accessible to CDC Replication.

If your production database is in an Oracle RAC environment and the thread ID is not included in the archive log file name, you must do the following:

  • Specify the thread ID in the -t parameter of this command.
  • Place the archive logs in subdirectories that are named using the thread number. For example, /archivelog/mycdcsystem/1 for thread 1 and /archivelog/mycdcsystem/2 for thread 2.
Note: This command will return a warning message if you add a file out of order, but will still mark the log as available.

Syntax

dmarchivelogavailable [-I <name>] [-L <locale>] [-t <thread>] [-q <log-sequence-number>] -d <filename>

Parameters

[-I <name>]
The name of the CDC Replication instance. You can set the TSINSTANCE environment variable to the name of your CDC Replication instance. After this is complete, you no longer have to specify the instance when issuing commands.
[-L <locale>]
The locale if different from the user locale (for example, en_ca).
[-t <thread>]
The thread ID of the Oracle archive log. If your database environment is not Oracle RAC, the thread ID will always be 1. This parameter is optional.
[-q <log-sequence-number>]
The Oracle archive log sequence number.
-d <filename>
Specify the name (including extension) and the fully qualified path to the archive log file being registered as it appears on the backup Oracle database. For example, you can specify the following value: /archivelog/arch_1_22781.arc

Result

This command returns a value of 0 if the command was successful and a non-zero value if the command fails.

Examples

dmarchivelogavailable -I MYINSTANCE -t 1 -d /archivelog/arch_1_22781.arc

Indicates to CDC Replication that archive log arch_1_22781.arc with thread ID 1 is now available for replication for the specified instance.

dmarchivelogavailable -I MYINSTANCE -t 1 -d /archivelog/arch_1_22782.arc

Indicates to CDC Replication that archive log arch_1_22782.arc with thread ID 1 is now available for replication for the specified instance.