我在主库新建了个用户，用户名叫abc，这个操作成功同步到了备库。但是当我给abc赋sysdba权限时却无法同步，报权限不足，并且连apply进程都停掉了。虽然在备库可以skip掉这个操作来保证后续操作的同步，但是还是觉得奇怪。难道逻辑备用不能同步grant sysdba 操作？apply进程的权限是什么？
Fri Oct 31 15:57:09 2008
LOGMINER: Turning ON Log Auto Delete
LOGSTDBY Apply process P004 started with pid=32 OS id=456
LOGSTDBY Apply process P005 started with pid=33 OS id=3448
LOGSTDBY Apply process P006 started with pid=34 OS id=648
LOGSTDBY Apply process P007 started with pid=35 OS id=2384
LOGSTDBY Apply process P008 started with pid=36 OS id=1236
Fri Oct 31 15:57:09 2008
LOGMINER: End mining logfile: E:\ORACLE10G\RDBMS\ARC00057_0667388552.001
Fri Oct 31 15:57:09 2008
LOGMINER: Begin mining logfile: E:\ORACLE10G\RDBMS\ARC00058_0667388552.001
Fri Oct 31 15:57:09 2008
LOGMINER: End mining logfile: E:\ORACLE10G\RDBMS\ARC00058_0667388552.001
Fri Oct 31 15:57:09 2008
LOGMINER: Begin mining logfile: E:\ORADATA\ORCL\REDOSTANDBY01.LOG
Fri Oct 31 15:57:10 2008
LOGSTDBY stmt: grant sysdba to abc
LOGSTDBY status: ORA-01031: insufficient privileges
LOGSTDBY id: XID 0x0003.019.00000162, hSCN 0x0000.000bfab4, lSCN 0x0000.000bfab4, Thread 1, RBA 0x003a.00000ff0.10, txnCscn 0x0000.000bfab7, PID 456, ORACLE.EXE (P004)
LOGSTDBY Apply process P004 pid=32 OS id=456 stopped
Fri Oct 31 15:57:10 2008
Errors in file e:\admin\orcl\bdump\orcl_lsp0_2256.trc:
ORA-12801: error signaled in parallel query server P004
ORA-01031: insufficient privileges
LOGSTDBY Apply process P005 pid=33 OS id=3448 stopped
LOGSTDBY Apply process P006 pid=34 OS id=648 stopped
LOGSTDBY Apply process P007 pid=35 OS id=2384 stopped
LOGSTDBY Apply process P008 pid=36 OS id=1236 stopped
LOGSTDBY Analyzer process P003 pid=31 OS id=2364 stopped
[ 本帖最后由 novenbersky 于 2008-10-31 16:43 编辑 ] |
