rac pdb database role service

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)
)
)

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值