在配置GG时,添加抽取进程extya:
GGSCI>add extract extya ,tranlog,begin now
GGSCI>start extya 时报错:
ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, extya.prm: The number of Oracle redo threads (2) is not the same as the number of checkpoint threads (1). EXTRACT groups on RAC systems should be created with the THREADS parameter (e.g., ADD EXT , TRANLOG, THREADS 2, BEGIN...).
但据客户反映反映,这是一台单机库,应该没有必要指定 thread 的。
后来发来通过查询v$log,发现存在thread1 ,thread2, 而该库只是用了thread1.而thread2没有使用。
解决方法很简单:
SQL> select THREAD#, STATUS, ENABLED from v$thread; THREAD# STATUS ENABLED ---------- ------ -------- 1 OPEN PUBLIC 2 CLOSED PUBLIC SQL> select group# from v$log where THREAD#=2; GROUP# ---------- 4 5 6 SQL> alter database disable thread 2; Database altered. SQL> alter database drop logfile group 4; Database altered. SQL> alter database drop logfile group 5; Database altered. SQL> alter database drop logfile group 6; Database altered. SQL> select THREAD#, STATUS, ENABLED from v$thread; THREAD# STATUS ENABLED ---------- ------ -------- 1 OPEN PUBLIC Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONEGGSCI>add extract extya ,tranlog,begin now
GGSCI>start extya
猜想可能是rman恢复后没有把rac下未使用的redo删除掉。
GGSCI>add extract extya ,tranlog,begin now
GGSCI>start extya 时报错:
ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, extya.prm: The number of Oracle redo threads (2) is not the same as the number of checkpoint threads (1). EXTRACT groups on RAC systems should be created with the THREADS parameter (e.g., ADD EXT , TRANLOG, THREADS 2, BEGIN...).
但据客户反映反映,这是一台单机库,应该没有必要指定 thread 的。
后来发来通过查询v$log,发现存在thread1 ,thread2, 而该库只是用了thread1.而thread2没有使用。
解决方法很简单:
SQL> select THREAD#, STATUS, ENABLED from v$thread; THREAD# STATUS ENABLED ---------- ------ -------- 1 OPEN PUBLIC 2 CLOSED PUBLIC SQL> select group# from v$log where THREAD#=2; GROUP# ---------- 4 5 6 SQL> alter database disable thread 2; Database altered. SQL> alter database drop logfile group 4; Database altered. SQL> alter database drop logfile group 5; Database altered. SQL> alter database drop logfile group 6; Database altered. SQL> select THREAD#, STATUS, ENABLED from v$thread; THREAD# STATUS ENABLED ---------- ------ -------- 1 OPEN PUBLIC Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONEGGSCI>add extract extya ,tranlog,begin now
GGSCI>start extya
猜想可能是rman恢复后没有把rac下未使用的redo删除掉。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26764468/viewspace-742512/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26764468/viewspace-742512/