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: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] |
| cc: (bcc: Mike Hately/ETECH) |
| Subject: Re: Solaris 8 Question
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
[EMAIL PROTECTED] 07/24/01 11:05AM
This happened to me
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
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
Kevin Kostyszyn wrote:
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
a disk partition or a
Shrek,
It's a disk partition.
KK
-Original Message-
William
Sent: Thursday, July 19, 2001 11:55 AM
To: Multiple recipients of list ORACLE-L
Kevin Kostyszyn wrote:
Hi all,
A friend of mine is having a problem so I thought I would ask all
of you
experts a quick
It depends. If a root partition fills up then it could crash the box. Otherwise, if
it's for the database, it might crash the database depends on what's on that partition.
HTH
Richard Ji
-Original Message-
Sent: Thursday, July 19, 2001 11:55 AM
To: Multiple recipients of
[EMAIL PROTECTED]
Subject: Re: Solaris 8 Question
Date: Thu, 19 Jul 2001 07:55:25 -0800
Kevin Kostyszyn wrote:
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
Kevin Kostyszyn wrote:
Shrek,
It's a disk partition.
KK
OK, if the partition hits 100% then nothing can get written to the
disk. if it has something like /var/temp on it that's bad. but i've
had them hit 100% with datafiles on them and the database keep going
because of the way
Interesting, sort of the same thing that happens on NT. Anyway, I am not
sure what is going on at their shop. Seemingly everything is running fine,
DB, OS, DB in archive log mode, then when they shut it down to do a cold
back up the machine takes a big crap on itself. I don't know anything
Title: RE: Solaris 8 Question
Seema you are describing a full arclog destination. That isn't a crash. It's just a hung state. Fixing this problem does not require any sort of recovery. It is easy to get out of this situation gracefully.
Lisa Koivu
Seat Warmer
Ft. Lauderdale, FL, USA
Usually on a Unix system when the file system is created, there is a small percentage
of space reserved for the root. The disk will fill up and could still function because
of the space reserved for root. If not taken care of right away the full disk space
could become a full physical disk and
13 matches
Mail list logo