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!

Oracle Archive file

506791Mar 25 2010 — edited Mar 26 2010

My 11g database is in archivelog mode, I noticed that there are sequential files generated in the RDBMS directory with the extension .001 when I also have the Archivedlog file under the flash_recovery_area *.arc files.
Why do I need both files. I know that one is duplication of the other. Can I just delete the .001 files since I already have the *.arc in the flash_recovery_area. If RMAN users the *.arc when recovering the database why do I still need the .001 files. The .001 files consume much of the hard disk space. Can I just delete, does RMAN catalog delete .001 when issuing the delete while recovering.

Thanks
Mhnd.

This post has been answered by EdStevens on Mar 26 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 23 2010

Added on Mar 25 2010

#general-database-discussions

5 comments

6,095 views