General
cancel
Showing results for 
Search instead for 
Did you mean: 

Dataguard logical standby SQL Apply issue

Yash99
Occasional Advisor

Dataguard logical standby SQL Apply issue

Hi,
I'm having a problem with the apply process on
the logical standby. Here are the errors I receive
when starting the apply process:

LOGSTDBY Apply process P004 pid=22 OS id=3245 stopped
ORA-12801: error signaled in parallel query server P004
ORA-00942: table or view does not exist


"LOGSTDBY stmt: GRANT SELECT ON SYS.qt403019_BUFFER TO "SYSMAN".

When I Checked Primary Database the object SYS.qt403019_BUFFER is available, but on logical standby database this object is not available.

Is there any workaround for this.

Regards
Yashwant
3 REPLIES
Yogeeraj_1
Honored Contributor

Re: Dataguard logical standby SQL Apply issue

hi yashwant,

which version of Oracle database is this?

revert!
kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Yash99
Occasional Advisor

Re: Dataguard logical standby SQL Apply issue

Hi
I am using Oracle 10.2.0.3 Enterprise Edition.

Regards
Yashwant Trivedi
Yogeeraj_1
Honored Contributor

Re: Dataguard logical standby SQL Apply issue

hi,

this is issue is a bit similar to Bug No. 4075120.

Can you try the workarounds as suggested in metalink note for the above mentioned BUG?

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)