使用dgmgrl的时候,发现也默认使用了SYSDG这个新的角色,而非SYSDBA [oracle@teststd dbs]$ dgmgrl / DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production Copyright (c) 2000, 2013, Oracle. All rights reserved. Welcome to DGMGRL, type "help" for information. Connected as SYSDG. 参数配置的时候,文件路径映射多了一个参数,那就是PDB相关的。 SQL> show parameter convert NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_file_name_convert string log_file_name_convert string pdb_file_name_convert string 数据库启动的时候也会打印出已有的patch
备库洋洋洒洒的几个PDB。 先启动Active Data Guard SQL> select open_mode from v$database; OPEN_MODE ------------------------------------------------------------ MOUNTED 此时PDB还都是mount状态 SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED MOUNTED 3 TCYMOB0 MOUNTED 4 MACTVDB MOUNTED 启动备库 SQL> alter database open; Database altered. 稍等一下,备库就变为了READ ONLY WITH APPLY SQL> select open_mode from v$database;
OPEN_MODE ------------------------------------------------------------ READ ONLY WITH APPLY 此时还是需要单独去启动PDB了。 SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 TCYMOB0 MOUNTED 4 MACTVDB MOUNTED SQL> alter pluggable database tcymob0 open; Pluggable database altered. SQL> alter pluggable database MACTVDB open; Pluggable database altered. SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 TCYMOB0 READ ONLY NO 4 MACTVDB READ ONLY NO 从整体而言,整个搭建的过程没有花费太多时间,还是很顺利的。 关注DBAplus社群,了解更多技术干货文!