1. 查看数据库状态
select v.INSTANCE_NUMBER,v.INSTANCE_NAME,v.STATUS from v$instance v;
2. 查看归档日志占用磁盘空间大小
select name,space_limit as quota,space_used as used,
space_reclaimable as reclaimable,number_of_files as files from v$recovery_file_dest;
3. 删除过期归档日志
C:>rman
rman>connect target
rman> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-30';