This discussion is archived
8 Replies Latest reply: Nov 6, 2013 2:41 AM by 007 RSS

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

007 Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points