Re: dataguard logical standby issue

What about the bug 4938674

can it be about it

it looks similar

On 3/19/07, Edward Lewis <eglewis_at_fastmail.fm> wrote:
>
>
> On Mon, 19 Mar 2007 04:28:18 -0700, "Edward Lewis" <eglewis_at_fastmail.fm>
> said:
> > Hello,
> > 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".
> >
> > Some background on this. From what I understand, the SYSMAN
> > schema was added to the primary, through the install of OEM.
> > The archive logs are being delivered to the standby. Once the apply
> > process starts, it appears to have problems with the new objects
> > created in SYSMAN.
> >
> > I've been in contact with Oracle support, but so far a resolution
> > has not been found. They have recommended running several variations
> > of the DBMS_LOGSTDBY command.
> >
> > exec dbms_logstdby.skip_error('GRANT OBJECT', null, null, null);
> >
> > exec dbms_logstdby.skip_transaction(7,13,107377);
> >
> > EXECUTE DBMS_LOGSTDBY.SKIP(stmt => 'COMMENT TABLE' , schema_name =>
> > 'SYSMAN' , object_name =>
> > null);
> > Has anyone experienced this ? Any recommendations ?
> >
> > thanks.
> > ed
> >
> > environment : sun 10, oracle 10.2.0.2
> > --
> > Edward Lewis
> > eglewis_at_fastmail.fm
> >
> > --
> > http://www.fastmail.fm - Email service worth paying for. Try it for free
> >
> --
> Edward Lewis
> eglewis_at_fastmail.fm
>
> --
> http://www.fastmail.fm - mmm... Fastmail...
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
A. Coskan GUNDOGAR

Oracle DBA

http://coskan.wordpress.com

--
http://www.freelists.org/webpage/oracle-l