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';

????

?