| Transactions are reaching the destination site and being dequeued, but not being applied [message #75667] |
Tue, 13 January 2004 17:35  |
arin_ortega
Messages: 1
Registered: January 2004
|
Junior Member |
|
|
* Check the apply process latency:
SELECT (hwm_time-hwm_message_create_time)* 86400 "Latency in Seconds",
hwm_message_create_time "Event Creation",
hwm_time "Apply Time",
hwm_message_number "Applied Message #"
FROM v$STREAMS_APPLY_COORDINATOR;
Latency in Seconds Event Cre Apply Tim Applied Message #
------------------ --------- --------- -----------------
0 10-JAN-04 10-JAN-04 0
* Check the Error Queue:
SELECT apply_name, source_database,local_transaction_id, error_message
FROM DBA_APPLY_ERROR;
no rows selected
* Check for any defined conflict resolution:
COLUMN object_owner FORMAT a15
COLUMN object_name FORMAT a15
COLUMN method_name FORMAT a20
COLUMN column_name FORMAT a15
COLUMN resolution_column FORMAT a60
SELECT object_owner,object_name,method_name,resolution_column,column_name
FROM dba_apply_conflict_columns;
no rows selected
* Check object instantiated SCN:
SELECT * FROM dba_apply_instantiated_objects;
SMB0000.WORLD SMB SMB_TRANSAKSI14 TABLE 196832142 0
* Check the current SCN value for the database.
To get the current SCN, use the following:
SET SERVEROUTPUT ON
DECLARE
iscn NUMBER;
BEGIN
iscn := DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER();
DBMS_OUTPUT.PUT_LINE('Current SCN is ' || iscn);
END;
/
Current SCN is 196835162
* Check for trace files in the BACKGROUND_DUMP_DEST
Dump file c:oracleadminsmbudumpsmb_p000_1068.trc
Wed Jan 14 09:11:16 2004
ORACLE V9.2.0.4.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Instance name: smb
Redo thread mounted by this instance: 1
Oracle process number: 22
Windows thread id: 1068, image: ORACLE.EXE (P000)
*** SESSION ID:(22.388) 2004-01-14 09:11:16.296
*** 2004-01-14 09:11:16.296
knllgobjinfo: MISSING Streams multi-version data dictionary!!!
knlldmm: gdbnm=SMB0000.WORLD
knlldmm: objn=18388
knlldmm: objv=1
knlldmm: scn=196824351
----------------------------------------------------------------------
I've tried to set instantiation manually but still can't solved the problem..why this thing happened? (the apply process running smoth previously)
|
|
|
|
| Re: Transactions are reaching the destination site and being dequeued, but not being applied [message #75668 is a reply to message #75667] |
Tue, 13 January 2004 20:02  |
ironmaiden
Messages: 1
Registered: January 2004
|
Junior Member |
|
|
i encountered a similar situaation whle iwas setting up streams. to solve this u need to setup the destination queue and then perform the instantiaition using dbms_flashback pkg. try performing instantiation with exp/imp utility and then configure the apply. after which u start the capture and apply process. u need to follow exactly the same pattern which was listed in the oracle streams document failing which u can get certain unknown errors like these
try this out i guess it should work.
(pretty difficult to interpret these things though.....)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
