RE: Unable to rebuild database from hot backup

From: Miller, Jay <JayMiller_at_TDWaterhouse.com>
Date: Tue, 20 Nov 2001 08:46:49 -0800
Message-ID: <F001.003C97B4.20011120081524@fatcity.com>

Sorry I never got back to people on this (since I got my restore to work using the standby controlfile I didn't pursue it for a while and then I forgot to respond until I was cleaning up old messages). The issue was adding the "until cancel" clause.
Thanks to everyone who suggested it and special thanks to Tim for explaining why it was necessary.  

Jay Miller

-----Original Message-----
Sent: Thursday, October 25, 2001 10:55 PM To: Multiple recipients of list ORACLE-L

My understanding the when you perform a "recover database using backup controlfile", the stop SCN in the controlfile is set to infinity... Therefore, you never "finish" media recovery since you never encounter the stop SCN... You can not simply cancel a "recover database using backup controlfile" since Oracle is expecting you perform a complete recovery ( since your not using the UNTIL CANCEL/TIME/CHANGE ) and canceling a complete recovery leaves the stop SCN in the controlfile at infinity... Therefore, the recovery is never complete and you will always receive the "needs media recovery message"... But, if you "recover using backup controlfile until cancel" and then cancel, that is the signal to Oracle that your are performing an incomplete recovery and the stop SCN in the controlfile is set to the SCN you have recovered through... At this point you can do an alter open resetlogs to open the database ( as long as you have applied enough logs to insure a consistent database )...

Tim

-----Original Message-----
<mailto:wisernet100_at_YAHOO.COM> ]
Sent: Thursday, October 25, 2001 10:15 PM To: Multiple recipients of list ORACLE-L

maybe the problem was never in the file but in the controlfile in the backup?

standby assumes that the scn in the datafile header will be out of date and that you will be recovering up to or past the scn in the standby controlfile and that that is okay.

• "Miller, Jay" <JayMiller_at_TDWaterhouse.com> wrote:
  > Another piece of information:
  >
  > On the basis of "it couldn't hurt to try" I recopied everything but
  > instead
  > of using the regular control file I used the standby control file. I
  > then
  > mounted it in standby mode, issued the recover standby database
  > command,
  > activated the standby, shutdown, and opened the database. It worked
  > fine.
  >
  > Why would it work with a standby controlfile and not with the regular
  > control file? I have my QC database working but I'm really puzzled.
  >
  > Jay Miller
  >
  > -----Original Message-----
  > Sent: Thursday, October 25, 2001 7:05 PM
  > To: Multiple recipients of list ORACLE-L
  >
  >
  > Okay, this is weird.
  >
  > I'm trying to rebuilding my QC database from a hot backup. As
  > always, I
  > copied all the hot backup files, all the archive logs from the period
  > of the
  > hot backup and the control files.
  >
  > After doing
  > recover database using backup controlfile;
  >
  > I got
  > SVRMGR> alter database open resetlogs;
  > alter database open resetlogs
  > *
  > ORA-01113: file 1 needs media recovery
  > ORA-01110: data file 1: '/data1/nyccp/systnyccp.dbf
  >
  > Thinking that perhaps I just needed to apply more logs I went on to
  > apply
  > another 12 hours worth of archive logs. I still get the same error.
  >
  >
  > Now I'm really concerned that my hot backup is invalid for some
  > reason.
  > Does anyone have any suggestions for what else I can look at?
  >
  > TIA,
  > Jay Miller
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.com
  <http://www.orafaq.com>
  > --
  > Author: Miller, Jay
  > INET: JayMiller_at_TDWaterhouse.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).
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.com
  <http://www.orafaq.com>
  > --
  > Author: Miller, Jay
  > INET: JayMiller_at_TDWaterhouse.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).
  

  ---

Do You Yahoo!?
Make a great connection at Yahoo! Personals. http://personals.yahoo.com <http://personals.yahoo.com>

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: JayMiller_at_TDWaterhouse.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 Tue Nov 20 2001 - 10:46:49 CST