Login  Register

ssh tunnel in dataguard

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

ssh tunnel in dataguard

seuss
2 posts
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
| More
Print post
Permalink

Re: ssh tunnel in dataguard

seuss
2 posts
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Re: ssh tunnel in dataguard

ErmanArslansOracleBlog
Administrator
5731 posts
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.)