rac pdb database role service
主库
srvctl add service -d ggc -s prim_db -l PRIMARY -r ‘ggc1,ggc2,ggc3’ -e SESSION -m BASIC -w 10 -z 10 -pdb hjk
srvctl add service -d ggc -s stby_db -l PHYSICAL_STANDBY -r ‘ggc1,ggc2,ggc3’ -e SESSION -m BASIC -w 10 -z 10 -pdb hjk
备库
srvctl add service -d ggcdg -s prim_db -l PRIMARY -r ‘ggcdg1,ggcdg2,ggcdg’ -e SESSION -m BASIC -w 10 -z 10 -pdb
srvctl add service -d ggcdg -s stby_db -l PHYSICAL_STANDBY -r ‘ggcdg1,ggcdg2,ggcdg’ -e SESSION -m BASIC -w 10 -z 10 -pdb hjk,bzk
主备
srvctl start service -d testdb -s prim_db
srvctl stop service -d testdb -s stby_db
备库上:
srvctl stop service -d testdb -s prim_db
srvctl start service -d testdb -s stby_db
备库启动服务时,可能遇到以下错误
PRCD-1084 : Failed to start service stby_db
PRCR-1079 : Failed to start resource ora.archnrt.stby_db.svc
CRS-5017: The resource action “ora.archnrt.stby_db.svc start” encountered the following error:
ORA-44786: Service operation cannot be completed.
ORA-06512: at “SYS.DBMS_SERVICE”, line 76
ORA-06512: at “SYS.DBMS_SERVICE”, line 483
ORA-06512: at line 1
处理方式:
主库启动
srvctl start service -d archnrt -s stby_db
备库启动
srvctl start service -d archnrts -s stby_db
主库关闭
srvctl stop service -d archnrt -s stby_db
PRIM_DB =
(DESCRIPTION =
(ADDRESS_LIST =
(FAILOVER = ON)
(LOAD_BALANCE = OFF)
(ADDRESS = (PROTOCOL = TCP)(HOST = primary.oracle.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = standby.oracle.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = prim_db)
)
)
STBY_DB =
(DESCRIPTION =
(ADDRESS_LIST =
(FAILOVER = ON)
(LOAD_BALANCE = OFF)
(ADDRESS = (PROTOCOL = TCP)(HOST = primary.oracle.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = standby.oracle.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = stby_db)
)
)