Tim,
> 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"...
I don't think this is 100% true for every situation.
I am no recovery expert, but I just did this the other
day, and to verify it, I ran the test again this
morning.
- Shutdown abort
- Delete all current controlfiles
- Replaced the binary controlfiles from last hot
backup (they were copied as part of the backup script)
- Startup mount
- Recover database using backup controlfile
- Kept applying logs - only trick was that the last
log was an online redo log, so I had to type in that
log explicitly. There I received the message Media
Recover Complete.
- Alter database open resetlogs.
Rob Pegram
Oracle Certified DBA
SVRMGR> shutdown abort
ORACLE instance shut down.
SVRMGR> startup mount
ORACLE instance started.
SVRMGR> alter database open
2> ;
alter database open
*
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1:
'C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF'
ORA-01207: file is more recent than controlfile - old
controlfile
SVRMGR> recover database using backup controlfile;
ORA-00279: change 546459 generated at 10/26/2001
06:59:20 needed for thread 1
ORA-00289: suggestion :
C:\ORACLE\ORADATA\ORCL\ARCHIVE\ORCLT001S00015.ARC
ORA-00280: change 546459 for thread 1 is in sequence
#15
Specify log: {<RET>=suggested | filename | AUTO |
CANCEL}
Log applied.
.............. cut .......
ORA-00280: change 566491 for thread 1 is in sequence
#21
Specify log: {<RET>=suggested | filename | AUTO |
CANCEL}
c:\oracle\oradata\orcl\redo02.log
Log applied.
Media recovery complete.
SVRMGR> alter database open resetlogs;
Statement processed.
- "Johnston, Tim" <TJohnston_at_quallaby.com> wrote:
> 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-----
> 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
> > --
> > 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).
>
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: Robert Pegram
INET: pegramrg_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 Fri Oct 26 2001 - 07:41:46 CDT