You can also mount another archive destination on a different machine
so that all the archives generating are created on that machine,
provided you have one.
Hope This will serves your problem.
"Andy" <andy.spaven_at_eps-hq.co.uk> wrote in message news:<_MMv9.1936$9R.9302211_at_newsr2.u-net.net>...
> 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 Thu Oct 31 2002 - 02:48:40 CST
