My Oracle Support Banner

为主库 PDB 创建的服务在备库中变为活动状态 (Doc ID 2533885.1)

Last updated on JULY 29, 2019

适用于:

Oracle Database - Enterprise Edition - 版本 12.1.0.2 和更高版本
本文档所含信息适用于所有平台

症状

由srvctl add service -role PRIMARY 命令 添加的主库可插拔数据库中的service,在启动备库可插拔数据库后在备库中变为活动状态。

在主库上添加服务时的命令示例

 % srvctl add service -db orcl -service testp -pdb pdb1 -preferred orcl1 -available orcl2 -role PRIMARY -policy AUTOMATIC


检查备用可插拔数据库上的为主库创建的 service 是处于活动状态:

SQL> alter pluggable database pdb1 open;

SQL> select db_unique_name, database_role, open_mode from v$database;

DB_UNIQUE_NAME   DATABASE_ROLE        OPEN_MODE
---------------- -------------------- --------------------------
orcls            PHYSICAL STANDBY     READ ONLY WITH APPLY

SQL> select CREATION_DATE,NAME,CON_NAME from v$active_services;

CREATION_DATE       NAME                       CON_NAME
------------------- -------------------------- ----------
2018-02-07 19:21:55 SYS$BACKGROUND             CDB$ROOT
2018-02-07 19:21:55 SYS$USERS                  CDB$ROOT
2018-09-23 06:41:51 pdb1                       PDB1
2018-11-01 14:45:44 orcls.jp.jp                CDB$ROOT
2018-11-01 14:33:58 testp                      PDB1

原因

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


文档内容
症状
原因
解决方案
参考

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.