DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Standby database datafile deleted

  1. #1
    Join Date
    Jan 2007
    Posts
    14

    Angry 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.

  2. #2
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    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

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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

  4. #4
    Join Date
    Jan 2001
    Posts
    3,134
    Don't forget to smack yourself too.
    I remember when this place was cool.

  5. #5
    Join Date
    Jan 2007
    Posts
    14
    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

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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

    May I ask what sort of availability can be affected....?

  7. #7
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    How big is the datafile? and doing a begin backup, rcp, end backup takes??
    "What is past is PROLOGUE"

  8. #8
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote 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.

  9. #9
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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.
    Jeff Hunter

  10. #10
    Join Date
    Jan 2001
    Posts
    3,134
    Quote 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
  •  


Click Here to Expand Forum to Full Width