primary arch process is stuck
stellrSep 9 2010 — edited Sep 9 2010My 11.2.0.1/linux based standby db_recovery_file_dest space, where arch logs are written, filled up and I did not catch it for a day or so. I've caught the standby up now via a rman incremental backup. However, there is this arch process on the primary that appears to be stuck. I have evidence that this log, 8269, was never written to to the primary:
SQL> select process,status,client_process,sequence# from v$managed_standby;
PROCESS STATUS CLIENT_P SEQUENCE#
--------- ------------ -------- ----------
ARCH CLOSING ARCH 8660
ARCH CLOSING ARCH 8658
ARCH OPENING ARCH 8269
ARCH CLOSING ARCH 8659
LNS WRITING LNS 8661
What should I do to clear up this hung arch process? This seems like a bug. Support is dragging it's feet.
Edited by: user11986251 on Sep 9, 2010 6:50 AM
Edited by: user11986251 on Sep 9, 2010 6:51 AM