Oracle 归档相关知识

归档量查询

select trunc(completion_time) as "Data",
    (sum(blocks*block_size))/1024/1024 as "MB"
from v$archived_log
group by trunc(completion_time)
order by 1;

select thread#,sequence#,deleted from v$archived_log order by 2;

归档路径更换

archive log list;
alter system set log_archive_dest_1='location=+ARCHDG';
alter system switch logfile;
archive log list;

删除全部归档

export ORACLE_SID=xxx
rman target /
delete noprompt archivelog all ;

删除归档保留时间

delete force noprompt archivellog until time 'sysdate-1';