As of Replicate 6.5, when working with Oracle endpoint using Attunity log reader to access redo log the following grant is required for capturing RESETLOGS operations:
Grant SELECT ON V_$DATABASE_INCARNATION
If Replicate detects that the user sepcified in the endpoint setting does not have the required permission, a warning will be written to the log and the task will continue as normal.
However, when replicating from a RAC environment and/or capturing RESETLOGS operation, not setting this permission may result in data loss and may cause the following error to be written to the log:
]E: Cannot find any Archived Redo log in the current incarnation (probably, the provided destination id is incorrect), thread ..
Resolution
To solve this error you can either add the missing premission i.e.:
Grant SELECT ON V_$DATABASE_INCARNATION
or
turn off the supportResetLog option. i.e. :
- Go to Oracle source endpoint --> Advanced tab --> scroll down to the internal parameters
- on the text box please add the following : supportResetLog
- Uncheck the box
