首先还是创建物理的standby，然后进行转换，rac physical standby需要关闭除了apply节点以外的节点
prdb：
ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE;
lstdb:
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
prdb:
EXECUTE DBMS_LOGSTDBY.BUILD;
ALTER SYSTEM ARCHIVE LOG CURRENT;
lstdb:
ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=SPFILE;
SHUTDOWN ABORT;
STARTUP MOUNT EXCLUSIVE;
ALTER DATABASE RECOVER TO LOGICAL STANDBY lstdb;
ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=SPFILE;
STARTUP MOUNT FORCE;
ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE START LOGICAL STANDBY APPLY;
这样logical standby rac就建立好了，可以添加standby redo进行实时的apply：
ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 5 SIZE 50M,GROUP 6 SIZE 50M,GROUP 7 SIZE 50M;
ALTER DATABASE ADD STANDBY LOGFILE THREAD 2 GROUP 8 SIZE 50M,GROUP 9 SIZE 50M,GROUP 10 SIZE 50M;
ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE SKIP FAILED TRANSACTION;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/79686/viewspace-1016487/ ，如需转载，请注明出处，否则将追究法律责任。
