Re: Solaris 8 Question

From: Richard Ji <rji_at_exenet.com>
Date: Tue, 24 Jul 2001 08:05:25 -0700
Message-ID: <F001.00353537.20010724075628@fatcity.com>

You should try to query the archive destination

select * from v$archive_dest

see if it says ERROR

And do

alter system archive log stop followed by alter system archive log start

This will fix the broken archive process.

Richard Ji

>>> rabbit_at_emirates.net.ae 07/24/01 11:05AM >>> This happened to me today: Solaris 5.8
we have a large data load exercise going on and the archive log directory filled - database stopped of course.
but after I had moved all the archive logs to another location the system still hung - I tried manual switching of log file ,still hung. I had to stop and start instance - I was surprised. did I miss something ?

sam

Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, July 20, 2001 2:15 PM

If it's / or /tmp, then yes, your machine could well become unusable until it gets some free space. If your archive log disk fills, Oracle will refuse transactions until there is free space. Read the man page for 'quota' to help you limit the possibility of this. And think about switching autoextend off.

Cheers,

-----Original Message-----

Sent: Thursday, July 19, 2001 4:10 PM
To: Multiple recipients of list ORACLE-L

Hi all,
A friend of mine is having a problem so I thought I would ask all of you
experts a quick question. On a Solaris 8 box running 8.1.7, if a partition
fills up, will it crash the box? I know that on NT this is very possible
depending on pagefile and what file is filling up the partition. But I don't know anything about Sun. Thanks alot:)

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
kevin_at_dulcian.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kevin Kostyszyn
INET: kevin_at_dulcian.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: Guy Hammond
INET: guy.hammond_at_avt.co.uk

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sam Roberts
INET: rabbit_at_emirates.net.ae

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Richard Ji
INET: rji_at_exenet.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