ssh tunnel in dataguard

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

ssh tunnel in dataguard

seuss
hi i was following your post from a while ago on how to use an ssh tunnel to compress logs instead of signing up for advanced compression.  is there a way to verify the logs are using the tunnel and the difference in compression?  also, does the StaticConnectIdentifier need to be edited in the DG broker?
Reply | Threaded
Open this post in threaded view
|

Re: ssh tunnel in dataguard

seuss
Reply | Threaded
Open this post in threaded view
|

Re: ssh tunnel in dataguard

ErmanArslansOracleBlog
Administrator
This is related with custom log shipping.
It is an old method, where you don't use Dataguard. So DGBroker is out of scope normally.
I mean, there is no DGBroker in the picture.
The solution is custom here. The data is encrypted inside the tunnel. So when the data (archivelog) is out of the tunnel, it is decrypted automatically.
As for the validation, the validation is automatically done, while you are applying the transferred archives to your standby. If you can't apply them, then you will see an ORA error caused by a corruption (most probably)

If you need to have more features, you can add your own customizations to this method. (some MD5 or other type of comparison feature may also work for you.)