I deleted one of the datafailes on the standby (physical) accidental and now managed recovery have stopped. I don't want to recreate the standby database from scratch. Any idea on how I should proceed will be much appreciated.
On the primary, put the affected tablespace in backup mode.
rcp the affected datafile to the standby
on the primary, take affected tablespaces out of backup mode.
resume recovery on standby.
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
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
May I ask what sort of availability can be affected....?
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.
Standby database datafile deleted
Reply With Quote
Originally Posted by nuushona
Bookmarks