Re: Fwd: please help

Nechama,

I do a level 0 or level 1 and then do archivelog current and then backup my archivelogs. I have been able to do point-in-time and ordinary recovery using this plan. This makes a complete set of backups. Further, we put them on tape each day and store a complete set for recovery.

Regards,
Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, May 02, 2001 5:00 PM

> would it be reasonable, then to alter system archive log current, and then
> back up all archived logs ... are there any pitfalls? ... thanks you
>
> Nechama Glasrot
> Oracle DBA
> Seisint, Inc.
> 6601 Park of Commerce Blvd.
> Boca Raton, Florida 33487
> nglasrot @seisint.com <mailto:nglasrot_at_seisint.com>
> Direct 561.999.3977
> Main 561.999.4400
> Fax 561.999.4695
>
>
>
> -----Original Message-----
> Sent: Wednesday, May 02, 2001 10:25 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Jonathan,
>
> It would appear that your friend has hit upon one of the problems of
hot
> backups that everyone misses and actually Oracle recommends against. That
> is
> backing up your online redo log files and doing that LAST. The reason is
> that
> there are more than likely active transactions that were recorded therein
> and
> those logs are not available. Can he complete the recovery, maybe if he
has
> the
> remaining logs from the active system, I'm assuming he is recovering to
> somewhere other than his production system. Otherwise his only recourse
is
> OTS.
>
> Dick Goulet
> Oracle Certified 8i DBA
>
> ____________________Reply Separator____________________
> Author: Jonathan Gennick <jonathan_at_gennick.com>
> Date: 5/1/2001 8:55 PM
>
> 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:
> INET: dgoulet_at_vicr.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).
>
>
> This transmission may contain information that is privileged, confidential
> and exempt from disclosure under applicable law.
> If you are not the intended recipient, you are hereby notified that any
> disclosure, copying, distribution, or use of the information contained
> herein (including any reliance thereon) is STRICTLY PROHIBITED.
> If you received this transmission in error, please immediately contact the
> sender and destroy the material in its entirety, whether in electronic or
> hard copy format.
> Thank you
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Glasrot, Nechama
> INET: NGlasrot_at_seisint.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: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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