Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Dataguard - SRL unassigned on Standby

Dataguard - SRL unassigned on Standby

From: Sanjay Madan <madan.sanjay_at_gmail.com>
Date: Thu, 23 Nov 2006 12:32:46 +0530
Message-ID: <9eb766040611222302o432f4bc0h90b6b4272c38b36d@mail.gmail.com>


Hi all,

Ora9205
AIX 5.3 We have set up DataGuard in the Max Performance mode. (SERVICE=DG_STY LGWR ASYNC=20480 OPTIONAL REOPEN=30 NOAFFIRM NET_TIMEOUT=60) The standby is about 2000 Kms away and connectivity is via a 4MBps line. Connectivity is NOT good.

The ORLs are being ported properly to the standby and the managed recovery is also taking place.

However, LGWR is reporting connection errors and we are getting these comments in the alert_PRIMARY.log:

Thu Nov 23 11:00:49 2006
LGWR: Completed archiving log 5 thread 1 sequence 6958 LGWR received timedout error from KSR
No action necessary. ARCH will attempt to transmit log file LGWR: Error 2 closing archivelog file 'DG_STY' Thu Nov 23 11:01:48 2006
Errors in file /ora/admin/primary/bdump/aaa_lgwr_2130034.trc: ORA-00002: Message 2 not found; product=RDBMS; facility=ORA LGWR: Error 2 disconnecting from destination LOG_ARCHIVE_DEST_2 standby host 'DG_STY' The SECONDARY alert log does not report any errors BUT the Standby Redo Logs created there are still unassigned. They are NOT being used at all. ( The number and size of the SRLs match the ORL of the primary).

Have tried a metalinked and googled, but havnt been able to locate anything significant.

Any pointers ??

Thanks

Sanjay

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 23 2006 - 01:02:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US