Looking for suggestions on how smart DG folks would implement a logical (or physical) DG scenario where NO sqlnet (and NO tunneling) is an option. Will only be able to sftp archive log files from primary to standby. Is it possible? Is it possible to fake it out? I need the logical database to be updateable, as in a rolling upgrade style, while still being able to perform sql apply from the primary when necessary to recync changes.
Looking at 11.2.0.x SPARC platforms on both sides, not that it would influence options.
Looking to NOT create a 100% custom solution of triggers from primary site, etc.
It might be possible but I would be worried about it becoming a maintenance nightmare.
This Oracle note has information on moving Data Guard network traffic to a separate network.
Data Guard Transport Considerations on Oracle Database Machine (Exadata) (Doc ID 960510.1)
To me the smart thing is to keep things as simple as possible.
This whole project is a maintenance nightmare :-)
That docid still assumes basic network sqlnet connectivity between the primary and standby sites, which I do not have. The best I have is that I have sftp arc files to a dmz landing zone, then copy to local database server.
Thank you for suggestion
At some point we are not using Data Guard anymore, we are doing "Log shipping".
In theory you could setup Oracle file watcher and dynamically create the sql to register the logs but you give up so much.
You cannot query from the Primary to check sync.
You cannot do a real switchover.
Backup's on the Standby are not much of an option.
Failover would almost guarantees loss of data.
The list goes on...
I can setup a home security system to make myself free safe. But if I lock it down too tight at some point I don't free more security, I feel like a prisoner.
I wish you luck