Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
#data-guard, #performance-availability
8 comments
2,332 views