OraFAQ Forum: Data Guard » ORA_01157 and ORA

Home » Server Options » Data Guard » ORA_01157 and ORA_01110 (OEL 4.7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA_01157 and ORA_01110 [message #590852]

Tue, 23 July 2013 08:15

oracle2013
Messages: 15
Registered: July 2013
Location: Hyderabad

Junior Member

HI all,

i am getting ORA_01157 and ORA_01110 errors while creating dataguard.please give me solution

thanks & regards
hidayath

Report message to a moderator

Re: ORA_01157 and ORA_01110 [message #590854 is a reply to message #590852]

Tue, 23 July 2013 08:21

John Watson
Messages: 8458
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read our OraFAQ Forum Guide and PLEASE read How to use [code] tags and make your code easier to read

With regard to your problem, no-one can assist unless you provide more information. All anyone can do is look up those messages in MOS (or just Google them) which, presumably, you have done already.

Report message to a moderator

Re: ORA_01157 and ORA_01110 [message #590856 is a reply to message #590852]

Tue, 23 July 2013 08:52

Michel Cadot
Messages: 67650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ORA-01157: cannot identify/lock data file %s - see DBWR trace file
 *Cause:  The background process was either unable to find one of the data
         files or failed to lock it because the file was already in use.
         The database will prohibit access to this file but other files will
         be unaffected. However the first instance to open the database will
         need to access all online data files. Accompanying error from the
         operating system describes why the file could not be identified.
 *Action: Have operating system make file available to database. Then either
         open the database or do ALTER SYSTEM CHECK DATAFILES.

ORA-01110: data file %s: '%s'
 *Cause:  Reporting file name for details of another error. The reported
          name can be of the old file if a data file move operation is
          in progress.
 *Action: See associated error message.

Regards
Michel

Report message to a moderator

Re: ORA_01157 and ORA_01110 [message #591136 is a reply to message #590856]

Thu, 25 July 2013 01:13

oracle2013
Messages: 15
Registered: July 2013
Location: Hyderabad

Junior Member

Hi

thanks Michel

Report message to a moderator

Re: ORA_01157 and ORA_01110 [message #597483 is a reply to message #591136]

Sat, 05 October 2013 00:29

8939513598$
Messages: 103
Registered: July 2013
Location: chennai

Senior Member

Hi, post your init.ora file parameters in the primary and standby database, those parameters "db_file_name_convert" important describing the OS location of datafiles, if one of your datafile being moved to another location accidentally, oracle would through error,

Report message to a moderator

Re: ORA_01157 and ORA_01110 [message #597485 is a reply to message #597483]

Sat, 05 October 2013 00:38

Michel Cadot
Messages: 67650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

How all these will/can fix the error on datafile?

Report message to a moderator

Previous Topic:	dataguard configuration physical
Next Topic:	Difficulties in configuring Data Guard environment

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 23 17:30:35 CST 2021