Sound to me the same thing had happened.
He did not force a log switch after he finished back up all the datafiles
to tape.
If the required log (probably archive log) which is generated during the
hot backup of the database can no longer be found. Part of that hot backup
will be unusable.
--
<\ /> ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~``~
(@ @) @}-`-,-`-,------- Winnie Liu ------',-'-,-'-,-{@ `~`~
/ V \ Oracle Database Administrator `~`~
o--m-m--o Infonet Services Corporation `~`~
##### mailto:[EMAIL PROTECTED] `~`~
~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~
"David A.
Barbour" To: Multiple recipients of list ORACLE-L
<dbarbour@nuce <[EMAIL PROTECTED]>
ntrix.net> cc:
Sent by: Subject: Re: Fwd: please help
[EMAIL PROTECTED]
om
05/02/01 07:24
AM
Please respond
to ORACLE-L
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:[EMAIL PROTECTED] * 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: [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: David A. Barbour
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:
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).
