oracle recover datafile,oracle recover database;

//持续滚动日志

export ORACLE_BASE=/u01/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0

export ORACLE_SID=oemsdb1

$ORACLE_HOME/bin/rman target / << EOF

run

{

recover database;

}

exit

EOF

/usr/bin/find /backup/archlog -mtime +4 -exec rm

{} \;

//持续滚动日志到指定的时间点

export ORACLE_BASE=/u01/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0

export ORACLE_SID=oemsdb1

export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'

dt=`date +"%Y-%m-%d"`

str=${dt}" 16:58:00"

$ORACLE_HOME/bin/sqlplus / as sysdba << EOF

recover database until time '$str' using backup controlfile;

EOF

/usr/bin/find /backup/archlog -mtime +4 -exec rm

{} \;