#!/bin/bash
#清理七天前归档
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=/oracle/app/oracle/product/12.2.0/db
export ORACLE_SID=gc
export PATH=$ORACLE_HOME/bin:$PATH
rman target / <<EOF
run{
crosscheck archivelog all;
delete noprompt expired archivelog all;
delete noprompt archivelog until time 'sysdate-7' ;
}
EOF