Re: dataguard logical standby issue
A. Coskan Gundogar
What about the bug 4938674
can it be about it
it looks similar
On 3/19/07, Edward Lewis <email@example.com> wrote:
On Mon, 19 Mar 2007 04:28:18 -0700, "Edward Lewis" <firstname.lastname@example.org>
> 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 =>
> Has anyone experienced this ? Any recommendations ?
> environment : sun 10, oracle
> Edward Lewis
- Email service worth paying for. Try it for free
- mmm... Fastmail...
A. Coskan GUNDOGAR
Oracle DBA http://coskan.wordpress.com