Re: could not log into database

Uwe

If you need to be able to recover the database at any time then you need the archived log files so these need retaining until you have another consistent backup. If there is insufficient room to retain these on disk you'll need a scheduled task to move them to tape before deleting them from the disk. It's likely you already have a task running on a daily basis (or you'd not normally see 25GB free) - just make this task more frequent (so long as it's not just a delete).

If you do need to be able to recover the database then you need to be aware that loosing a disk that consititutes all or part of the filesystem in question will loose you the data files and the archived log files you need to recover from (unless the archived logs are also being written somewhere else either using mirrored disks or Oracles multiple archive destination feature). Having the archived logs and data files on one filesystem isn't a particularly robust solution :-). You might want to move the archive destination to another disk.

If on the other hand you do not need to recover this database (if it's an unimportant development / scratch system) then turn the archiving off. That way no more archived logs will be produced.

Andy

"Uwe Wagner" <Uwe.Wagner_at_gef.de> wrote in message news:apo431$crt$1_at_cvs-server.gef.de...
> Hi,
>
> we are using ORACLE 8.1.7 on SuSE 7.0.
> Some days ago the filesystem was full and no connect except internal was
> allowed because of a lot of archiv files in
> /db/oracle/OraHome1/admin/orcl/arch.
> This directory is on the same filesystem as the database files.The
database
> files has a size of about 50 GB, the filesystem
> has a size of 80 GB.
> Most of the time there are 25 GB free on the filesystem, but when we mae a
> lot of actions like creating and deleting tables, the filesystem was full
> because of a lot of archive files.
>
> What can I do ?
> A greater disk is one solution, but not a good one I think.
> How big must be the size of the filesystem for the archive files, if the
> database files has a size of 50 GB ?
>
> thanks
> uwe
>
>
Received on Wed Oct 30 2002 - 02:32:12 CST