Changes in primary are not getting updated on logical standby [message #359459] |
Sun, 16 November 2008 12:24  |
pramod_garre
Messages: 6 Registered: April 2008
|
Junior Member |
|
|
Hi gentlemen,
We have configured Logical standby for one of our databases.We have followed all the things mentioned in oracle documentation and all the views related to logical standby are showing accurate results.but if we change some data in primary for instance,inserting some rows in table and switch log files and after it applied on logical standby ,these rows are not appearing in standby tables??what must be the problem???
|
|
|
|
Re: Changes in primary are not getting updated on logical standby [message #359467 is a reply to message #359462] |
Sun, 16 November 2008 12:58   |
pramod_garre
Messages: 6 Registered: April 2008
|
Junior Member |
|
|
Yes ..I did the follwing
I commited in primary and then i switched the logfile in primary.Alert log at standby and the related views at standby are as follows
Alert log of logical standby
LOGMINER: Begin mining logfile: /oradata_two/Adb/archive_standby/arch1_39_667920052.dbf
Sun Nov 16 23:33:06 2008
LOGMINER: End mining logfile: /oradata_two/Adb/archive_standby/arch1_39_667920052.dbf
Sun Nov 16 23:33:33 2008
And this is log is applied on standby as per it's views
select NAME,THREAD#,SEQUENCE# from dba_logmnr_log;
NAME
--------------------------------------------------------------------------------
THREAD# SEQUENCE#
---------- ----------
/oradata_two/Adb/archive_standby/arch1_33_667920052.dbf
1 33
/oradata_two/Adb/archive_standby/arch1_39_667920052.dbf
1 39
but this query shows the following output
SQL> select max(sequence#) from V$LOG_HISTORY ;
MAX(SEQUENCE#)
--------------
1
i started logical stndby apply process but still why it is not applying event every log is reached standby and evtn though alert log shows that log miner is mining every log .
|
|
|
|
Re: Changes in primary are not getting updated on logical standby [message #359470 is a reply to message #359469] |
Sun, 16 November 2008 13:37   |
pramod_garre
Messages: 6 Registered: April 2008
|
Junior Member |
|
|
select * from V$LOGSTDBY_STATE;
PRIMARY_DBID SESSION_ID REALTIME_APPLY STATE
------------ ---------- ---------------------------------------- ----------------------------------------
1475211572 1 N IDLE
SQL> select to_char(EVENT_TIME,'DD-MON-YY:HH24:MI:SS'),CURRENT_SCN,COMMIT_SCN,EVENT,STATUS from DBA_LOGSTDBY_EVENTS;
TO_CHAR(EVENT_TIME CURRENT_SCN COMMIT_SCN EVENT
------------------ ----------- ---------- --------------------------------------------------------------------------------
STATUS
----------------------------------------------------------------------------------------------------------------------------------
15-NOV-08:11:43:20
ORA-16111: log mining and apply setting up
2 ;
APPLIED_SCN APPLIED_TIME RESTART_SCN RESTART_TIME LATEST_SCN LATEST_TIME MINING_SCN MINING_TIME
----------- ------------------ ----------- ------------------ ---------- ------------------ ---------- ------------------
240321 16-NOV-08:23:35:22 240305 16-NOV-08:23:34:42 240321 16-NOV-08:23:35:22 240322 16-NOV-08:23:35:22
The above SCN and timings are advancing as and when log shipping done and alert log of standby shows log mining is done
|
|
|
|
|
|