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
Please respond|
|| to ORACLE-L |
|||
|+>
>|
||
| To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> |
| cc: (bcc: Mike Hately/ETECH)
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 t
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 autoexte
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
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. Lauderdal
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 abou
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
ltiple recipients of list ORACLE-L <[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
>
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 li
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 que
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 ta
12 matches
Mail list logo