I need to move the datafile from one disk to another disk.
So, this is what i did:
1. Bring the tablespace offline
2. Move the physical file
3. Alter tablespace users rename datafile 'disk1/users01.dbf'
4. Bring up the tablespace - HERE i got error - require media recovery .
I know these things can be done while DB is up and runing,But it would be fine to do this by MOUNTING the DB and then opening the DB.While opening the DB, oracle will automatically do the RECOVERY and things would be more smooth.