Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> physical standby database managed/non-managed
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 25 2006 - 09:11:51 CST
![]() |
![]() |