RE: Unable to rebuild database from hot backup

[Miller, Jay]

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- 
 ] 
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 

RE: Unable to rebuild database from hot backup

[Robert Pegram]

Luckily I have never had this situation in production,
and what I have read also suggests using the ascii
file created from 'BACKUP CONTROLFILE TO TRACE' for
recovery.  I just had a little time on my hands and
decided to give it a try.  As I stated, I am by no
means an expert in recovery (more like a novice), I
was just stating what I observed.  Maybe someone else
will let us know their opinion.

Thanks for your input.

Rob Pegram

--- "Jesse, Rich" <[EMAIL PROTECTED]> wrote:
> Is this recovery method valid?  The loss of
> controlfiles is supposed to be
> recovered using the trace file generated from a
> previous BACKUP CONTROLFILE
> TO TRACE, isn't it?  At least according to the
> Oracle8 Backup and Recovery
> class it is.
> 
> The part that concerns me is that you are recovering
> using an ONLINE redo
> log (don't know if it was the active one or not). 
> Could be the paranoid in
> me, but that just doesn't seem right.  The admission
> that "I don't think
> this is 100% true for every situation" would seem to
> suggest that you agree
> that this method shouldn't be used for
> backup/recovery on production
> databases.
> 
> My $.02.
> 
> Rich Jesse  System/Database
> Administrator
> [EMAIL PROTECTED] Quad/Tech
> International, Sussex, WI USA
> 
> -Original Message-
> Sent: Friday, October 26, 2001 08:30
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Jesse, Rich
>   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).

RE: Unable to rebuild database from hot backup

[Jesse, Rich]

Is this recovery method valid?  The loss of controlfiles is supposed to be
recovered using the trace file generated from a previous BACKUP CONTROLFILE
TO TRACE, isn't it?  At least according to the Oracle8 Backup and Recovery
class it is.

The part that concerns me is that you are recovering using an ONLINE redo
log (don't know if it was the active one or not).  Could be the paranoid in
me, but that just doesn't seem right.  The admission that "I don't think
this is 100% true for every situation" would seem to suggest that you agree
that this method shouldn't be used for backup/recovery on production
databases.

My $.02.

Rich Jesse  System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA

-Original Message-
Sent: Friday, October 26, 2001 08:30
To: Multiple recipients of list ORACLE-L


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

RE: Unable to rebuild database from hot backup

[Robert Pegram]

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: {=suggested | filename | AUTO |
CANCEL}

Log applied.

.. cut ...

ORA-00280: change 566491 for thread 1 is in sequence
#21
Specify log: {=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
> >

RE: Unable to rebuild database from hot backup

[Johnston, Tim]

Title: RE: Unable to rebuild database from hot backup





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-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 10:15 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Unable to rebuild database from hot backup



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 PROT

RE: Unable to rebuild database from hot backup

[Rachel Carmichael]

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).

RE: Unable to rebuild database from hot backup

[Johnston, Tim]

Title: RE: Unable to rebuild database from hot backup





Hi Jay,


  When you perform a "recover database using backup controlfile" you are performing an incomplete recovery...  Do a recover database using backup controlfile until cancel...  Cancel...  Then open resetlogs...

Tim


-Original Message-
From: Miller, Jay [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 7:05 PM
To: Multiple recipients of list ORACLE-L
Subject: Unable to rebuild database from hot backup



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).

RE: Unable to rebuild database from hot backup

[DBarbour]

I'm not sure if the error Jay is getting can be caused by this, but I got
bit by it way back - make sure the tablespace that the file is for was
taken out of backup mode.  If it wasn't, you can apply redo logs all day
long and it will never become current.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   

John Kanagaraj 

   
[EMAIL PROTECTED]>   cc:   

Sent by: Subject:     RE: Unable to rebuild database 
from hot backup   
[EMAIL PROTECTED] 

om 

   

   

10/25/2001 

06:55 PM   

Please respond 

to ORACLE-L

   

   





Jay,

It is reasonable to assume that your hot backup is NOT ok ;-)

This is *possibly* because this particular file (or maybe more files to
come) wasn't backed up for a while. Can you look at the timestamp of this
file (and other files) in the backup that you restored? That should give
you
a clue... I think this is what's happening here: Oracle needs to make sure
as many logs as needed should be applied to this 'old' file so that the SCN
on this particular file matches the latest one found in the system.dbf, so
you need to keep applying from that point in time until now Another
clue
is to trace your archive logs - look at the one that you started applying.
The time on that one is probably the time that your backup of that
particular file became invalid

Hth,
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Listen to great commercial-free christian music 24x7 at www.klove.com

** The opinions and statements above are entirely my own and not
those of my employer or clients **




> -Original Message-
> From: Miller, Jay [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 25, 2001 4:05 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Unable to rebuild database from hot backup
>
>
> 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: ht

RE: Unable to rebuild database from hot backup

[Kimberly Smith]

Looks like to me you want to put a until cancel on your recover clause.
Or until time or until scn.  Tell it to stop at a particular spot
otherwise it expects a full recovery.

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


Jay,

It is reasonable to assume that your hot backup is NOT ok ;-)

This is *possibly* because this particular file (or maybe more files to
come) wasn't backed up for a while. Can you look at the timestamp of this
file (and other files) in the backup that you restored? That should give you
a clue... I think this is what's happening here: Oracle needs to make sure
as many logs as needed should be applied to this 'old' file so that the SCN
on this particular file matches the latest one found in the system.dbf, so
you need to keep applying from that point in time until now Another clue
is to trace your archive logs - look at the one that you started applying.
The time on that one is probably the time that your backup of that
particular file became invalid

Hth,
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Listen to great commercial-free christian music 24x7 at www.klove.com 

** The opinions and statements above are entirely my own and not
those of my employer or clients **




> -Original Message-
> From: Miller, Jay [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 25, 2001 4:05 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Unable to rebuild database from hot backup
> 
> 
> 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: John Kanagaraj
  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: Kimberly Smith
  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).

RE: Unable to rebuild database from hot backup

[Miller, Jay]

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).

RE: Unable to rebuild database from hot backup

[Khedr, Waleed]

I think you have to alter the old database backup the control file to trace
file and then use this trace file after modification and editing to open the
new database.

-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: Khedr, Waleed
  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).

RE: Unable to rebuild database from hot backup

[John Kanagaraj]

Jay,

It is reasonable to assume that your hot backup is NOT ok ;-)

This is *possibly* because this particular file (or maybe more files to
come) wasn't backed up for a while. Can you look at the timestamp of this
file (and other files) in the backup that you restored? That should give you
a clue... I think this is what's happening here: Oracle needs to make sure
as many logs as needed should be applied to this 'old' file so that the SCN
on this particular file matches the latest one found in the system.dbf, so
you need to keep applying from that point in time until now Another clue
is to trace your archive logs - look at the one that you started applying.
The time on that one is probably the time that your backup of that
particular file became invalid

Hth,
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Listen to great commercial-free christian music 24x7 at www.klove.com 

** The opinions and statements above are entirely my own and not
those of my employer or clients **




> -Original Message-
> From: Miller, Jay [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 25, 2001 4:05 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Unable to rebuild database from hot backup
> 
> 
> 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: John Kanagaraj
  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).