This content has been marked as final. Show 3 replies
By using OFFLINE DROP you just have disabled the datafile for further use. The information of datafile is still in controlfile. You need to remove that datafile or else your rman backup willl fail again and again to do so you can follow the following link
Yeah the DBWR couldnt locate the file
Advanced Technical Support Engineer, SMB Partner Support, Symantec Corporation
what will happen if i delete the datafile or remove permanently? exa. a_txn_data12.dbf
Is there any easy way to remove the infromation in the controlfile?