View Single Post
Old 07-29-2015, 04:39 AM
shaikht shaikht is offline
Join Date: Feb 2010
Posts: 246
shaikht has 25 to 49 reputation pointsshaikht has 25 to 49 reputation pointsshaikht has 25 to 49 reputation points
Default Technical Whitepaper: IQ :Datafile_Complete_Recovery_Oracle

Hi All,

Technical whitepaper is posted on support site at below link to troubleshoot oracle datafiles issue.
While working with Oracle Database there could be scenario where we need to recover datafiles since Oracle server does not start due to missing or corrupted data files.
Data files contains customer data, also these are essential for database to save data in those files these shall present for database started properly.
There could be multiple reason for media failure and that lead to situation when data files are deleted or moved or corrupted and hence cause oracle server not to start properly or problem with table space or other problems.

We can get some of error listed below ORA error that indicate problem with data file.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01116: error in opening database file 6
ORA-01110: data file 6: '/u01/oradata/avayaiq/avayaiq'
ORA-27041: unable to open file

To recover situation we shall have working copy of database, we can use RMAN to recover files.
Reply With Quote