What are the .dbf files?
Tony Pich
Could anyone explain me please why the arch.dbf files get created in
$ORACLE_HOME/dbs ??
how do you switch them off ??
Is it safe to delete them ??
What are they exactly??
Thanks a lot for your answers,
--
Regards,
Tony
James Belton
I guess you are talking about your archived redo logs?
In your init.ora file, which will be in $ORACLE_HOME/dbs, there will be an
entry for ARCHIVE_LOG_DEST. In your case, it sounds as though this is set to
$ORACLE_HOME/dbs.
To put them in a more appropriate place, edit this line and stop and start
your database.
You can switch them off but this might upset the way you back up your
database! They are archive copies or your redo logs and will assist you in
point of failure recovery.
If you log into your database as system or internal and type 'alter system
switch logfile', and then look at the $ORACLE_HOME/dbs directory, you should
see that another file has been created... this also confirms to us both that
these are archived redo log files! (they should also be the same size as
your redo logs... look at the size of the redo log files in V$LOG)
If they are archived redo logs, then it is safe to delete them (again,this
depends on your backup and recovery strategy). You need to make sure there
is sufficient space for them anyway, if there isn't, you may find your
database stops until you delete a few.
Check out my website as I've got a section on backup and recovery under
Oracle at http://www.jamesbelton.co.uk
Hope this helps out!
Regards
James
"Tony Pich" <ap...@viviance.com> wrote in message
news:8fr3cs$frb$1...@diana.bcn.ttd.net...
Andreas Stephan
the arch files are the archived redo logs. If your database is running in
archivelog mode the db itself
copies online redo log to a specified path (parameter in initSID.ora
archive_log_dest) after they are
full. There is a special oracle process named arch who does this copying.
These files are needed for
recovery if u get lost of one or more datafiles. You can influence the place
where they will be written to
in modifying the above parameter. After the next reboot of the database they
will be written to the
new path (if it exists and is writeable for oracle)
If you don´t need high data availability you can switch off archivelog mode.
To do so run svrmgrl and
svrmgr> shutdown immediate;
svrmgr> startup mount;
svrmgr> alter database noarchivelog;
svrmgr> alter database open;
That will bring your db into another mode. There will be no arch process
anymore and no arch*.dbf files will be written.
But you won´t be able to recover your db up to the last transaction but only
to your last backup time. So be careful.
Hope this helps.
Andy
Tony Pich schrieb: