On Mon, 19 Mar 2007 04:28:18 -0700, "Edward Lewis" <eglewis@(protected)>
> 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
: error signaled in parallel query server P004
: 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 10.2.0.2
> Edward Lewis
> http://www.fastmail.fm - Email service worth paying for. Try it for free
http://www.fastmail.fm - mmm... Fastmail...