8 Replies Latest reply: Nov 6, 2013 4:41 AM by 007 RSS

    ORA-01157: cannot identify/lock data file error in standby database.

    007

      Hi,

       

      i have a primary database and standby database (11.2.0.1.0) running in ASM with different diskgroup names. I applied an incremental backup on standby database to resolve archive log gap and generated a controlfile for standby in primary database and restored the controlfile in standby database.But when i started the MRP process its not starting and thows error in alert log ORA-01157: cannot identify/lock data file. When i queried the standby database file it shows the location on primary database datafiles names not the standby database.

       

      ******************************

      PRIMARY DATABASE

      *****************************

      SQL> select name from v$datafile;


      NAME

      --------------------------------------------------------------------------------

      +DATA/oradb/datafile/system.256.788911005

      +DATA/oradb/datafile/sysaux.257.788911005

      +DATA/oradb/datafile/undotbs1.258.788911005

      +DATA/oradb/datafile/users.259.788911005

       

      ****************************************

      STANDBY DATABASE

      ****************************************

      SQL> select name from v$datafile;


      NAME

      --------------------------------------------------------------------------------

      +STDBY/oradb/datafile/system.256.788911005

      +STDBY/oradb/datafile/sysaux.257.788911005

      +STDBY/oradb/datafile/undotbs1.258.788911005

      +STDBY/oradb/datafile/users.259.788911005

       

      The Actual physical location of standby database files in ASM in standby server is shown below

       

      ASMCMD> pwd

      +STDBY/11gdb/DATAFILE

      ASMCMD>

      ASMCMD> ls

      SYSAUX.259.805921967

      SYSTEM.258.805921881

      UNDOTBS1.260.805922023

      USERS.261.805922029

      ASMCMD>

      ASMCMD> pwd

      +STDBY/11gdb/DATAFILE

       

      i even tried to rename the datafiles in standby database but it throws error

      ERROR at line 1:

      ORA-01511: error in renaming log/data files

      ORA-01275: Operation RENAME is not allowed if standby file management is

      automatic.

       

      Regards,

      007