.
Hi All,
Technical whitepaper is posted on support site at below link to troubleshoot oracle datafiles issue.
http://support.avaya.com/css/P8/documents/101008076
Abstract
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.
Technical whitepaper is posted on support site at below link to troubleshoot oracle datafiles issue.
http://support.avaya.com/css/P8/documents/101008076
Abstract
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.
