RE: Fwd: please help

thank you ruth

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: Thursday, May 03, 2001 8:31 AM
To: Multiple recipients of list ORACLE-L

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


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