带有 .arc 扩展名的存档文件在 oracle 数据库中急剧增长
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/10782391/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Archive files with .arc extension is growing extremely in oracle database
提问by Sridevi Laks
I am using Linux operating system. My application run on Java and Oracle is my Database.
In my /ora2/DB/archivefolder I have increasing log files written which have occupied 85% of the filesystem now.
我正在使用 Linux 操作系统。我的应用程序在 Java 上运行，Oracle 是我的数据库。在我的/ora2/DB/archive文件夹中，我写入了越来越多的日志文件，这些文件现在占据了文件系统的 85%。
I have so many .arc files in /ora2/DB/archivewith names like DB1_5218.arcetc. each occupying atleast 20 MB. I have atleast 100 .arc files written in a day.
我有很多 .arc 文件/ora2/DB/archive，名字像DB1_5218.arc等等。每个文件至少占用 20 MB。我一天至少写了 100 个 .arc 文件。
What makes .arc files written?
是什么让 .arc 文件写入？
Why such a Huge load of files in archive folder?
为什么存档文件夹中有如此大量的文件？
I am new to oracle logs , does too many threads running for a database operation and database not committed, closed or rolledback in the end cause these many files to be written in the archive?
我是 oracle 日志的新手，是否有太多线程为数据库操作而运行，而数据库最终未提交、关闭或回滚导致将这么多文件写入存档？
Please help.
请帮忙。
回答by jamal saleh
By taking backup of the archive files you can delete the old archive files from the system and give some space for the new archives. Deleting from the hard-drive is not enough though, you should clear them using RMAN.
通过备份存档文件，您可以从系统中删除旧存档文件并为新存档留出一些空间。但是，从硬盘驱动器中删除是不够的，您应该使用RMAN.
- Delete them from the hard-drive.
- connect
RMAN>crosscheck archivelog all; RMAN>delete expired archivelog all; this way you gave more space to oracle to write the new archive files.
- 从硬盘驱动器中删除它们。
- 连接
RMAN>交叉检查归档日志全部； RMAN>全部删除过期归档日志；通过这种方式，您为 oracle 提供了更多空间来编写新的存档文件。
回答by David Aldridge
There is a very complete explanation in the documentation here: http://docs.oracle.com/cd/B19306_01/server.102/b14231/archredo.htm
这里的文档中有一个非常完整的解释：http: //docs.oracle.com/cd/B19306_01/server.102/b14231/archredo.htm
Briefly, these are backups of the redo log files generated by database changes. They are used for recovering the database from a media failure. They can also be "consumed" by another database acting as a failover.
简而言之，这些是由数据库更改生成的重做日志文件的备份。它们用于从媒体故障中恢复数据库。它们也可以被另一个充当故障转移的数据库“消耗”。
