Home » Server Options » Data Guard » ORA_01157 and ORA_01110 (OEL 4.7)
ORA_01157 and ORA_01110 [message #590852] Tue, 23 July 2013 08:15 Go to next message
oracle2013
Messages: 4
Registered: July 2013
Location: hyd
Junior Member
HI all,

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






thanks & regards
hidayath
Re: ORA_01157 and ORA_01110 [message #590854 is a reply to message #590852] Tue, 23 July 2013 08:21 Go to previous messageGo to next message
John Watson
Messages: 4086
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.
Re: ORA_01157 and ORA_01110 [message #590856 is a reply to message #590852] Tue, 23 July 2013 08:52 Go to previous messageGo to next message
Michel Cadot
Messages: 57613
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
Re: ORA_01157 and ORA_01110 [message #591136 is a reply to message #590856] Thu, 25 July 2013 01:13 Go to previous messageGo to next message
oracle2013
Messages: 4
Registered: July 2013
Location: hyd
Junior Member
Hi

thanks Michel
Re: ORA_01157 and ORA_01110 [message #597483 is a reply to message #591136] Sat, 05 October 2013 00:29 Go to previous messageGo to next message
8939513598$
Messages: 101
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,

icon5.gif  Re: ORA_01157 and ORA_01110 [message #597485 is a reply to message #597483] Sat, 05 October 2013 00:38 Go to previous message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

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


Current Time: Sun Apr 20 07:03:26 CDT 2014

Total time taken to generate the page: 0.04450 seconds