Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Recover database inside shell script

Vinay KFeb 9 2024 — edited Feb 9 2024

Hi,

I want to run the recover database from the shell in the background ; as my connection expires in 1hr

How can i pass the argument AUTO into the below script ie, when recover database ask

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

nohup sqlplus / as sysdba <<EOF > RecoverStdby09Feb.log 2>&1 &
select * from dual;
set echo on;
set feedback on;
recover database;
exit
EOF
Comments
Post Details
Added on Feb 9 2024
1 comment
52 views