如何设置oracle dataguard数据库自动recover

废话不多说，直接复制测试环境配置过来。

[test-sty:oracle:/oradata/archive]$crontab -l

0 23 * * * /scripts/autorecover.sh
[erp-sty:oracle:/oradata/archive]$cat /scripts/autorecover.sh

export ORACLE_SID=orcl  
export ORACLE_HOME=/oracle/11.2.0/db/dbhome1
export PATH=$PATH:$ORACLE_HOME/bin
sqlplus / as sysdba <<EOF
recover standby database;
auto
exit
EOF