Error: Could Not Open Last Archive Redo Log

Issue

Connection setup tests fail with the following error:

Connection tests failed. Validating access to redo log: Could not open last archive redo log

Environment

• Connector: Oracle
• Storage: ASM (Automatic Storage Management)
• Incremental sync method: Binary Log Reader
• Redo log type: Archived redo logs

Resolution

To resolve this issue:

1. Grant the Fivetran user permission to manage directories and access necessary packages:
   • GRANT CREATE ANY DIRECTORY TO <fivetran_user>;
   • GRANT DROP ANY DIRECTORY TO <fivetran_user>;
   • GRANT EXECUTE ON PKG_HVR_BFILE TO <fivetran_user>;
   • GRANT SELECT ANY TABLE TO <fivetran_user>;
   You may also need to grant access to system tables, such as SYS.TABPART$, SYS.TABCOMPART$, and SYS.TABSUBPART$.

2. For a multitenant database, grant the following additional privileges:
   • GRANT ALTER SESSION TO <fivetran_user>;
   • GRANT SET CONTAINER TO <fivetran_user>;
3. For ASM, verify the following:
   • The staging directory is valid and accessible on the local file system.
   • The Oracle operating system user has read and write access to the directory.
   • The CREATE ANY DIRECTORY and DROP ANY DIRECTORY privileges are granted.
   • Fivetran can access the PKG_HVR_BFILE or FIVETRAN_BFILE package.
4. Confirm that the most recent archived redo log exists at the path referenced by the Oracle directory object and is accessible on disk.

Cause

This issue occurs when the Fivetran database user lacks the directory management privileges or package access required for ASM validation. Without these permissions, Fivetran can't access the most recent archived redo log, even if the file exists on disk.