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
] 
Blog
Search
Help
Members
Register
Login
Home
