Sample Header Ad - 728x90

Oracle Redo Log shipping from PRIMARY to PRIMARY

0 votes
1 answer
37 views
I am setting up online and archived redo shipping from a source database (PRIMARY) to destination database (PRIMARY). I cannot use a STANDBY database as destination as I have to setup real time downstream capture using Oracle XStream and standby databases are READ only. The issue I am facing is once I setup both DBs following instructions from here and here , I am able to receive the archived redo log files (I see the files showing up after a log switch). But, I am not receiving online redo log files, which is required for real time capture. Anyone setup this and maybe help with what might be missing? Please note that if I switch the destination DB from PRIMARY to STANDBY I receive both online and archived redo log files, but it doesn't serve my purpose. I am using the simple remote login password mode to communicate between the two DBs.
Asked by Ashok (1 rep)
May 8, 2025, 04:33 AM
Last activity: Jul 4, 2025, 08:38 AM