常用ORACLE SQL语句，不断增加

自己常用的sql，记录一下，以免忘记
1、查看归档日志信息

SELECT space_limit/1024/1024/1024 AS "Quota_G",space_used/1024/1024 AS "Used_M",space_used/space_limit*100 "Used_%",space_reclaimable AS reclaimable,number_of_files AS files FROM v$recovery_file_dest ; 

2、备份并删除现有归档日志

rman target sys/oracle@test

/*执行备份*/
backup database plus archivelog delete input format "oracle+date.bak"

3、仅备份归档日志并删除现有
备份归档日志到/home目录制定的filename，并删除现有的归档日志

backup archivelog all delete 
   input format "/home/oracle/filename ";