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.
Printable View
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.
yeah, recreate the database from scratch....
No, no, no.
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.
Don't forget to smack yourself too.
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
Quote:
Originally Posted by nuushona
May I ask what sort of availability can be affected....?
How big is the datafile? and doing a begin backup, rcp, end backup takes??
We don't need to know your weird proclivities! :rolleyes:Quote:
Originally Posted by Mr.Hanky
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.Quote:
Originally Posted by nuushona
Yer such a douche.Quote:
Originally Posted by gandolf989