RE: Fwd: please help

From: Glasrot, Nechama <NGlasrot_at_seisint.com>
Date: Wed, 02 May 2001 13:31:44 -0700
Message-ID: <F001.002F7B9E.20010502130055@fatcity.com>

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

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