-
Standby database datafile deleted
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....
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
-
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.
Jeff Hunter
-
Don't forget to smack yourself too.
I remember when this place was cool.
-
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
-
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
May I ask what sort of availability can be affected....?
-
How big is the datafile? and doing a begin backup, rcp, end backup takes??
"What is past is PROLOGUE"
-
Originally Posted by Mr.Hanky
Don't forget to smack yourself too.
We don't need to know your weird proclivities!
Last edited by gandolf989; 02-02-2007 at 12:49 PM.
-
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.
Jeff Hunter
-
Originally Posted by gandolf989
We don't need to know your weird perclivities!
Yer such a douche.
I remember when this place was cool.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|