mysql怎么删除归档日志文件_如何清除掉归档日志文件？

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

如果想备份：

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

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;