Hi Friends ,
I am using version :- 11.2.0.3.0 RAC with 2 node .
Accidently one of my DBA has created a datafile in a wrong path as it is on ASM . we are getting these messages in the alert log .
ORA-01135: file 26 accessed for DML/query is offline
ORA-01110: data file 26:
'/dboracle/orabase/product/11.2.0.BTSP5/dbs/DATA_DG01'
now i need to drop that datafile which has been made offline but there is some data in that datafile.
1 select file_id, count(*)
2 from dba_extents
3 where file_id = 26
4* group by file_id;
FILE_ID COUNT(*)
---------- ----------
26 3
Request your inputs to resolve this .
Regards,
DBApps