如何清除掉归档日志文件？

如果已经有当前的完整备份了，就把归档日志删掉（直接删除文件即可）！

如果想备份：

下面的脚本备份归档日志：

RMAN> run {
2> allocate channel dev1 type disk;
3> backup
4> format '/ora/backups/log_t%t_s%s_p%p'
5> (archivelog all);
6> release channel dev1;
7> }

　　下面的脚本归档日志从# 90 to 100：

RMAN> run {
2> allocate channel dev1 type disk;
3> backup
4> format '/ora/backups/log_t%t_s%s_p%p'
5> (archivelog from logseq=90 until logseq=100 thread 1);
6> release channel dev1;
7> }

　　下面的脚本备份在两天内产生的归档日志，在备份完成后会自动删除归档日志。如果备份失败，归档日志不会被删除。

RMAN> run {
2> allocate channel dev1 type disk;
3> backup
4> format '/oracle/backups/log_t%t_s%s_p%p'
5> (archivelog from time 'sysdate-2' all delete input);
6> release channel dev1;
7> }
-------------------------------
d.归档模式转换

                archivedlog -noarchivedlog

                        setp1.shutdown clearly

                        setp2.startup mount

                        setp3.alter database archielog/noarchivelog

                        setp4.alter databse archivelog;

                        setp5.alter system archive log start(启动自动存档)[archive log start/alter system archive log all]

                        setp6.alter database open;