RE: Unable to rebuild database from hot backup

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                                                     
                            
                    <john.kanagara       To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>       
                    j_at_hds.com>           cc:                                           
                            
                    Sent by:             Subject:     RE: Unable to rebuild database 
from hot backup               
                    root_at_fatcity.c                                                     
                            
                    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:JayMiller_at_TDWaterhouse.com]
> 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: 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: John Kanagaraj
  INET: john.kanagaraj_at_hds.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: 
  INET: DBarbour_at_austin.isd.tenet.edu

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