dataguard logical standby issue
- From: "Edward Lewis" <eglewis@xxxxxxxxxxx>
- To: "Edward Lewis" <eglewis@xxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 19 Mar 2007 08:19:35 -0700
On Mon, 19 Mar 2007 04:28:18 -0700, "Edward Lewis" <eglewis@xxxxxxxxxxx>
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@xxxxxxxxxxx
>
> --
> http://www.fastmail.fm - Email service worth paying for. Try it for free
>
--
Edward Lewis
eglewis@xxxxxxxxxxx
--
http://www.fastmail.fm - mmm... Fastmail...
--
//www.freelists.org/webpage/oracle-l
Other related posts:
