Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: physical standby database managed/non-managed

Re: physical standby database managed/non-managed

From: Carel-Jan Engel <>
Date: Wed, 25 Jan 2006 16:42:01 +0100 (CET)
Message-ID: <>


ssh allows for port-forwarding, if your network guys didn't diable this. I it is possible to create a so-called tunnel through portforwarding, even when several hops are involved.

I use this on a regular basis when I perform remote support. I can open tora or raptor from my desktop at home on a server of a customer, hopping from firewall through management server to the db-server. Actually I map a local port to the SQL*Net port of the db-server of the customer. The local tnsnames resolves the connect alias top the port I defined on localhost.

This allows for dataguard redo forwarding as well. When you use ssh with a compressing cipher-type you can even have the benefit of faster transfer.


Regards, Carel-Jan

If you think education is expensive, try ignorance. (Derek Bok) ===

> Hi,
> We need to implement physical standby database. Primary and standby
> will be in two separate networks behind their own firewalls. Security
> guys dont allow to ping from one server to other server. I can not
> create sqlnet connection either.
> So from primary I ssh to a hop server and from there I ssh to standby.
> Under given situation I assume that I can not set up data guard. Or is
> there any way I can implement data guard? Is any suggestion to network
> security folks that will let me connect from primary to standby
> without opening any security risk?
> I have started looking into alternative solution using non-managed
> standby. I created a standby database. I am copying the archived logs
> from primary manually and applying on standby. Standby running behind
> the primary acceptable here. Moving the archived logs will be
> implemented through a perl script that will be called from cronjob.
> In this script I have command "Recover standby database;" After that
> if I do AUTO it applies all archived logs and give ORA-00308 for next
> (not yet there) archived log.
> This is the way it is supposed to be.
> Is there any way that standby recover to the last available archived
> log and comes out cleanly? How can I query the last archived log file
> applied on the standby database?
> Thanks
> Sandeep
> --

Received on Wed Jan 25 2006 - 09:42:01 CST

Original text of this message