Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

arch files in /u01/app/oracle/product/11.1.0/db_1/dbs/ ... why?

bobonacusNov 11 2010 — edited Nov 11 2010

Hi,

Oracle version 11.2.0.1 on linux

I have archived redo turned on and the log_archive_dest_1='LOCATION=/u01/app/oracle/oradata/aspasiad/arch/'

My redo files are created there fine and I manage them manually. The disc has just become full and I've noticed thousands of files in /u01/app/oracle/product/11.1.0/db_1/dbs/ that all seem to be additional archived redo logs ...

why have they been created?
what are they used for?
how do I set oracle to not create them?
is it worth keeping them?

thanks
Robert

This post has been answered by CKPT on Nov 11 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 9 2010

Added on Nov 11 2010

#general-database-discussions

28 comments

1,594 views