The database was open and the files went missing and alert.log showed problem in only RBS datafile and not in other datafiles but users in their PCs were getting errors for 2 other datafiles . The v$datafile showed all files online. I had to do recovery from hotbakup files.
Did it happen to any one while using the database the datafiles went missing? Why it did not show about the problem for other 2 datafiles? Interestingly I have my tables updated on the tablespace on the above datafiles betwwen the time the problem started and the tablespaces were taken offline. The tablespaces had only one datafile each . Can any one throw any lights on this ?