Home » Server Options » Data Guard » Archive log rejected On Logical Standby database (Oracle 10g R2 + 10.2.0.3.0)
Archive log rejected On Logical Standby database [message #306260] Thu, 13 March 2008 08:40 Go to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Hi,

Actually i configured logical standby database in two different node.

My Primary database: wasim and Logical database = babu (both database located on different systems).

My problem archive log rejected on logical standby database. But tnsping is working well. I want to know why it's rejected. I tried ASYNC and SYNC types but still facing problem.


On Primary database:

alter system set LOG_ARCHIVE_DEST_2=
 'SERVICE=babu LGWR ASYNC
  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
  DB_UNIQUE_NAME=babu'


Alert log On Primary Database:

ALTER SYSTEM SET log_archive_dest_2='SERVICE=BABU.SAMIINDIA LGWR ASYNC
  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
  DB_UNIQUE_NAME=babu' SCOPE=BOTH;
Wed Mar 12 17:35:40 2008
Thread 1 advanced to log sequence 255
  Current log# 2 seq# 255 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\WASIM\REDO02.LOG
Wed Mar 12 17:35:42 2008
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
LNS: Archive log rejected (thread 1 sequence 255) at host 'BABU.SAMIINDIA'
Wed Mar 12 17:41:06 2008
ALTER SYSTEM SET log_archive_dest_2='SERVICE=babu LGWR ASYNC
   VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
   DB_UNIQUE_NAME=babu' SCOPE=BOTH;
LNSb started with pid=52, OS id=3364
Wed Mar 12 17:41:18 2008
LGWR: Archive log rejected (thread 1 sequence 256) at host 'babu'


On Standby Database

alter system set log_archive_dest_2 =
'SERVICE=WASIM LGWR ASYNC
   VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
   DB_UNIQUE_NAME=wasim'


Alert log On Standby Database:

-- Connected User is Valid
RFS[10]: Assigned to RFS process 5856
RFS[10]: Identified database type as 'logical standby'
Primary database is in MAXIMUM PERFORMANCE mode
Wed Mar 12 17:48:28 2008
RFS LogMiner: Client enabled and ready for notification
Archive log rejected (thread 1 sequence 258) by RFS clients
Wed Mar 12 17:48:32 2008
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid


Or, It's bug in 10.2.0.3 ? Kindly explain me.

Babu B




Re: Archive log rejected On Logical Standby database [message #306277 is a reply to message #306260] Thu, 13 March 2008 09:35 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
With free advice you get what you paid for it.

You could try

alter database register logical logfile

HTH & YMMV

Provided without any warranty of completeness or correctness.
Re: Archive log rejected On Logical Standby database [message #306368 is a reply to message #306277] Thu, 13 March 2008 23:09 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Thank You. I'll try that.

>>Provided without any warranty of completeness or correctness.

Sorry for my apologies.

Babu
Previous Topic: Invisible Indexes
Next Topic: Open mode for Standby Database
Goto Forum:
  


Current Time: Thu Mar 28 17:03:42 CDT 2024