Re:Another Database Down

From: <dgoulet_at_vicr.com>
Date: Thu, 24 May 2001 08:00:06 -0700
Message-ID: <F001.0030D279.20010524061525@fatcity.com>

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
 <cancel immediately>
 alter database open resetlogs
 shutdown
 <get a backup NOW>

Dick Goulet

____________________Reply Separator____________________
Author: "Burton; Laura L." <BurtonL_at_prismplus.com>
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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12">
<TITLE>Another Database Down</TITLE>
</HEAD>
<BODY>

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


</BODY>
</HTML>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dgoulet_at_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_at_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).

Received on Thu May 24 2001 - 10:00:06 CDT