Yes, but this is only limited to the Oracle GoldenGate classic capture. Oracle GoldenGate integrated capture can only capture from a primary database that is open for read/write.
Resources
- Oracle GoldenGate Documentation (12.2): 11.6 Configuring Capture in Oracle Active Data Guard Only Mode
- GoldenGate Real-Time Replication from Active Standby Database to SQL Server 2012 Target