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.
1. Shutdown abort
2. Delete all current controlfiles
3. Replaced the binary controlfiles from last hot
backup (they were copied as part of the backup script)
4. Startup mount
5. Recover database using backup controlfile
6. 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.
7. 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" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]>
> 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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
