Quote Originally Posted by nuushona
Thanks a lot. Problem solved. I couldn't take the affect tablespace on the primary database on a backup mode as our database is it could have affected the database availability. I rcp the deleted datafile from primary to standby and start recovery. Everything went ok. It was a silly mistake
risky, risky. You might have a fractured block in there. Putting your tablespace in backup mode has a very, very, very minuscule effect on your performance. If I were you (which I'm not), I would redo my rcp this time with the tablespace in backup mode. You don't want to be surprised when you have to failover. But, that's just me and I prefer to do things the right way.