Hi Oracle Experts,
My Database Setup is :
Primary : 2 Node RAC 12.1.0.2 with Multitenant Architecture and ASM file structure
Standby : 2 Node RAC 12.1.0.2 with Multitenant Architecture and ASM file structure
During Data Guard Configuration, the standby file management was kept to manual (by mistake). After that we have created one new tablespace in primary database and which has shutdown the MRP process in Data Guard with below errors in alert log of standby instance.
ORA-01111: name for data file 87 is unknown - rename to correct file
ORA-01110: data file 87: '/u01/app/oracle/product/12.1.0/db_1/dbs/UNNAMED00087'
ORA-01157: cannot identify/lock data file 87 - see DBWR trace file
ORA-01111: name for data file 87 is unknown - rename to correct file
ORA-01110: data file 87: '/u01/app/oracle/product/12.1.0/db_1/dbs/UNNAMED00087'
MRP0: Background Media Recovery process shutdown (blrdr2)
Now I have dropped newly created tablespace and its datafile#87 from primary instance to resolve this issue.
Please suggest me solution to synch Data Guard with Primary database.
Thanks and Regards,
Smit