ORA-16112 - Logical Standby database log apply service hanging....

[Axr2]

It'll be great if you could post the eventual outcome of the TAR.

[Betty]

I got solution from Oracle Tar.

1. I did cold backup of primary DB on March 8, executed the logMiner, the log sequence#29205 includes the special Dict Begin/End.

SQL> SELECT NAME FROM V$ARCHIVED_LOG
2 WHERE (SEQUENCE#=(SELECT MAX(SEQUENCE#) FROM V$ARCHIVED_LOG
3 WHERE DICTIONARY_BEGIN = 'YES' AND STANDBY_DEST= 'NO'));

NAME
--------------------------------------------------------------------------------
arch_1_29205.arc

2. I stopped to do something else.

3. on March 17, did another cold backup copy of DB; then used this cold backup copies(datafiles) as base, and used March 20's backup controlfile.
So I did "recover database using backup controlfile until change SCN", I recovered the Logical DB until March 20.
The end SCN in log 30074(March 20)

4. Then I started LSP " alter database start logical standby apply initial SCN"
the start SCN in log 30075(March 20).

I thought what I did very logically and reasonablly. But Oracle Tar told me --
Go Back to register more logs, until it includes "DICTIONARY_BEGIN = 'YES'".

So I went back to register all logs happened on March 8(#29205), it works.

I asked WHY?
They answered:
"The recovery process will start to check all the logs since the log miner dictionary had been built. Maybe it won't need to apply any of those logs but it will be the starting point.
"

Thanks a lot for everyone!

Betty

[Axr2]

Aah..thanks for the update.