8 Replies Latest reply on Oct 15, 2016 3:36 PM by Smit Patel

    Data Gaurd Sync Issue after creation of datafile in 12.1.0.2

    Smit Patel

      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