12.2 Pluggable Database Creation kills managed recovery process on standby database
edited Apr 3, 2018 5:47AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 3 commentsAnswered
I have a Multitenant 12.2 Database set up with Dataguard.
Everything is in sync and looking good.
I'm on ASM, using OMF, standby_file_managment is auto. db_file_name_convert etc. is all set up correctly. essentially the config appears sound. Something isn't right though!!
I create a pluggable database on the primary as per the following example:
CREATE PLUGGABLE DATABASE PDB_16_03_0950 ADMIN USER PDB_ADMIN IDENTIFIED BY PASSWORD123
STORAGE (MAXSIZE 2G MAX_SHARED_TEMP_SIZE 100M)
DEFAULT TABLESPACE USERS DATAFILE SIZE 100M;
In a nutshell this leads to the standby managed recovery process being killed. Here is an alert log excerpt from the standby.
0