DB:GI+Oracle 12.1.0.2
在12c的DataGuard下,当试图在Primary创建新的PDB时,Standby端无法同步创建该PDB并且redo apply停止。具体表现为:
v$pdb视图出现了新pdb;
dba_pdbs视图下未出现新pdb;
关闭redo apply时,居然显示未启用:
点击(此处)折叠或打开
-
alter database recover managed standby database cancel;
-
ERROR at line 1:
- ORA-16136: Managed Standby Recovery not active
点击(此处)折叠或打开
-
SQL> select file#,name from v$datafile;
-
……
-
25
- +DATA/RACDB/35112BB187971752E0531506A8C09821/DATAFILE/system.285.914342455
解决方法:
在Standby端设置相关参数:
点击(此处)折叠或打开
-
alter system set DB_FILE_NAME_CONVERT='+DATA/RACDB/','/oradata/STBY/' scope=spfile;
-
shutdown immediate
-
startup mount
-
alter database open read only;
- alter database recover managed standby database disconnect;
另外,Primary端最好也设置db_file_name_convert参数,以备当其转变为Standby角色。注意,此时应该Standby在前,Primary在后。