Alter database stop logical standby 停止不了

Alter database ablort logical standby

Alter database start logical standby 啟動之後發現standby staus 為SQL APPLY NOT ON

Shutdown immediate;發現一直不能停，狀況為：

Stopping Job queue slave processes, flags = 7

Thu Sep 15 17:15:11 2011

Job queue slave processes stopped

Thu Sep 15 17:20:10 2011

Active call for process 782506 user 'ora104' program 'oracle@stcsmesstb (P000)'

SHUTDOWN: waiting for active calls to complete.

然後在OS下：ps –ef|grep p000

找出其PID然後kill;kill -9 $PID

Startup;

Alter database start logical standby;

ITPub博客

logical standby案例二