Re: File system filling up

In article <2sdf2a$56n_at_xmission.xmission.com> dfuller_at_xmission.com (umeboshi) writes:
>When importing multiple verisons of our Oracle databases, we filled up
>our file system. We figured it was because auto archiving was turned
>on. We turned it off in SQLDBA, deleted the redolog files and tried the
>import again. The import again stopped mid-stream. We thought it was
>because Oracle was waiting for a manual archive. We found that
>ARCHIVELOG was TRUE, and turned it off in the initXXXXX.ora file and
>restarted Oracle. Still no luck--it looked like our database again would
>not accept transactions. I figure the best thing to do is to leave
>ARCHIVELOG TRUE and delete the redolog files occasionally.
>
>Obviously, there is something we are missing. Can anyone help?

Try turning of autoarchive, manually archiving the remaining logs, then setting NOARCHIVELOG. I suspect the problem is that tho you weren't in ARCHIVELOG mode, it was still hung on the logs it wanted to archive from when it was in ARCHIVELOG mode.

Just a guess,
Marty Received on Thu Jun 02 1994 - 04:06:14 CEST