From dgoulet@vicr.com Thu, 24 May 2001 08:00:06 -0700 From: dgoulet@vicr.com Date: Thu, 24 May 2001 08:00:06 -0700 Subject: Re:Another Database Down Message-ID: MIME-Version: 1.0 Content-Type: text/plain Laura, Seems like you've gotten one suggestion on the lk file(s). The other that I would suggest, and this has worked for me in the past with OTS's help, is: shutdown abort startup mount recover database until cancel alter database open resetlogs shutdown Dick Goulet ____________________Reply Separator____________________ Author: "Burton; Laura L." Date: 5/23/2001 3:26 PM Well, I think the time for jubilation has been short-lived for me. The production database was recovered successfully due to archiving and luck. I also have a small, inhouse, remedy (help desk) database that I haven't done anything with and now recovery is necessary for it as well. The bad news is I wasn't archiving, and although I do have a physical backup, the database was not down. I restored the datafiles, control files, and redo logs so that everything would be for the same time, but when I try to open the database I get the error "cannot mount database in exclusive mode." The error states that an instance already has it open in exclusive or parallel mode. I am assuming this is because the database was not closed when the backup was executed. I have tried a few things to 'trick' it, but I guess my magic tricks are not good enough to fool the crowd. I am already bracing myself for what I will probably read in response to this...but I am hopeful that someone will find that rabbit in the hat. Thank you in advance, Laura Another Database Down

Well, I think the time for jubilation has been short-lived for me.  The production database was recovered successfully due to archiving and luck.  I also have a small, inhouse, remedy (help desk) database that I haven't done anything with and now recovery is necessary for it as well.  The bad news is I wasn't archiving, and although I do have a physical backup, the database was not down.

I restored the datafiles, control files, and redo logs so that everything would be for the same time, but when I try to open the database I get the error "cannot mount database in exclusive mode."  The error states that an instance already has it open in exclusive or parallel mode.  I am assuming this is because the database was not closed when the backup was executed.

I have tried a few things to 'trick' it, but I guess my magic tricks are not good enough to fool the crowd.  I am already bracing myself for what I will probably read in response to this...but I am hopeful that someone will find that rabbit in the hat.

Thank you in advance,
Laura

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: dgoulet@vicr.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).