No Data Found Error with Oracle Logical Standby

From AMCPU Wiki

I found this error in my alert logfile on the logical standby database:

LOGMINER: Begin mining logfile: /u02/oradata/intremdb/archive1/standby/1_226_676748374.dbf
Thu Jan 29 12:43:59 2009
LOGSTDBY stmt: Oper=LOB_WRITE, SegOwner=ARADMIN, SegName=ACTLINK_OPEN, SegType=TABLE, User=
LOGSTDBY status: ORA-01403: no data found
LOGSTDBY id: XID 0x0006.027.00000e18, hSCN 0x0000.003e2b1a, lSCN 0x0000.003e2b1a, Thread 1, RBA 0x00e2.0000c237.c0, txnCscn 0x0000.003e2b1c, PID 29139, oracle@cyclone (P004)
LOGSTDBY Apply process P004 pid=30 OS id=29139 stopped
Thu Jan 29 12:43:59 2009
Errors in file /u01/app/oracle/admin/intremdb/bdump/intremdb_lsp0_29129.trc:
ORA-12801: error signaled in parallel query server P004
ORA-01403: no data found

After some research I found the resolution here:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/manage_ls.htm#i1016645

Basically, you have to reinstantiate the object listed in the error above as SegName (ACTLINK_OPEN) in this case which is a SegType=TABLE. To reinstantiate, first disable the SQL Apply:

SQL> ALTER DATABASE STOP LOGICAL STANDBY APPLY;

Then rebuild the object by executing a specific stored procedure:

SQL> EXECUTE DBMS_LOGSTDBY.INSTANTIATE_TABLE('ARADMIN', 'ACTLINK_OPEN', 'intremdb');

Finally, restart the SQL Apply:

SQL> ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;