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
> --
> 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
> --
> 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
--
Please see the official ORACLE-L FAQ: 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).
Received on Thu Oct 25 2001 - 20:07:18 CDT
