Skip to Main Content

Database Software

Data Gaurd Sync Issue after creation of datafile in 12.1.0.2

Smit PatelOct 13 2016 — edited Oct 15 2016

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

This post has been answered by CKPT on Oct 13 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 12 2016
Added on Oct 13 2016
8 comments
1,986 views