Re: Fwd: please help

Bill,

Did you force a log switch before and after the hot backup? Did you backup your archive logs (or alternatively, are they available)? Sounds to me like you need to run

    ALTER DATABASE <SID> RECOVER UNTIL (CANCEL, TIME, CHANGE, USING BACKUP CONTROLFILE); If you didn't force the log switch, be mindful that you may have to specify one or more of the redo logs to get the requested SCN. Did you backup the controlfile? redo logs? init<SID>.ora? orapasswd?

These are some generalities, which may or may not apply to your specific situation. However, given the information at hand, it's probably where I'd start looking.

Regards.

David A. Barbour
Oracle DBA, OCP

Jonathan Gennick wrote:
>
> Fellow list members, I received the following email from a
> reader a few minutes ago. If you skip down to where he talks
> about backup, you'll see that he's in trouble with a
> database that won't recover. I've already suggested that he
> open a TAR, and that he supply more specifics as to error
> messages and the like, but maybe someone on this list can
> draw some conclusions from what he's told me so far. If
> you're good at recovery, have a look at what he says. I'll
> post his email address later if he says its ok, and I'll
> pass on any advice/suggestions I receive in the meantime.
>
> --
> Best regards,
>
> Jonathan Gennick
> mailto:jonathan_at_gennick.com * 906.387.1698
> http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org
>
> Tuesday, May 01, 2001, 10:27:51 PM, X wrote:
> BC> Hi Jonathan,
>
> BC> I always read and like your articles in the Oracle
> BC> Magazine.
>
> BC> Could you please give me a moment of your time ..
> BC> I have some couple of pressing problems and questions
> BC> if you don't mind as i am under fire at work ..
>
> BC> I have trouble with some of the Oracle databases that
> BC> i manage on Sun Solaris platform, sometimes i have my
> BC> shutdowns hanging and this takes a very long time to
> BC> complete. Also, hanging problems with some of the sql
> BC> statements. Could you lend a hand about any possible
> BC> clues as to what i should do or where i should look
> BC> for answers.
>
> BC> My last question is about hotback.
>
> BC> I ran a hot backup yesterday and tried recovering
> BC> today. I was faced with an Oracle error saying system
> BC> tablespace needs more recovery and that open resetlogs
> BC> will get an error after automatically applying the
> BC> redo logs.
>
> BC> My backup strategy went this way,
>
> BC> i created a backup shell script and
> BC> i put all tablespaces in hotbackup mode at the same
> BC> time with this syntax..
>
> BC> select 'alter tablespace' || tablespace_name ||'begin
> BC> backup;'
> BC> from dba_tablespaces
> BC> where status <> 'INVALID';
>
> BC> I copied my datafiles to backup using the syntax below
> BC> ...
>
> BC> !cp /u02/oradata/prod/system01.dbf /backup/prod
> BC> !cp ....
> BC> !cp ....
> BC> !cp ....
> BC> !cp ....
>
> BC> then ended backup the same way as i began backup
> BC> with the ||'end backup;'
>
> BC> I backed up my controlfile
>
> BC> and everything went well. Today, I restored my
> BC> datafiles from backup and i was greeted with the
> BC> problem i just expalined to you.
>
> BC> I am the only dba DBA at this location
> BC> and i need some advise on what to do as this is a
> BC> serious issue with my supervisor.
>
> BC> Thanks,
>
> BC> Bill
>
> BC> __________________________________________________
> BC> Do You Yahoo!?
> BC> Yahoo! Auctions - buy the things you want at great prices
> BC> http://auctions.yahoo.com/
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jonathan Gennick
> INET: jonathan_at_gennick.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: David A. Barbour
  INET: dbarbour_at_nucentrix.net

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