RESETLOG operation

Sometimes you must execute a RESETLOG operation on a database, for example after an Oracle abort shutdown. This operation creates a new incarnation of the database.

A RESETLOG operation does the following things:

• Archives the current online redo logs if they are accessible
• Erases the contents of the online redo logs
• Resets the log sequence number to 1
• Creates the online redo log files if they do not currently exist
• Updates all current data files and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and timestamp

If the CDC Replication Engine for Oracle databases is restarted after a RESETLOG operation, replication fails because CDC Replication can read logs only from the current incarnation of the database. To allow CDC Replication to resume replication, you must run CDC Replication in recovery mode. In recovery mode, CDC Replication reads logs from the previous incarnation of the database. CDC Replication Engine for Oracle databases includes a command-line utility, dmfailoverrecovery, to implement this recovery mode.

For details on the command and recovery procedure, see Recovering the CDC Replication Engine for Oracle databases after a database failover operation.