Script error

[Vinod Sadanandan]

Hi,

Can anyone help me on the error message ? ; -)
recover.sh: line 18: syntax error: unexpected end of file
=============== =============== ====

#!/usr/bin/sh
HostName=`hostname`
LOGDIR=$PWDLE_SID
LOGFILE=$LOGDIR/${MYSID}
num=0
while [$num -lt 10]
do
echo -n $num
num='expr $num+1'
sqlplus /nolog <<EOF
conn / as sysdba
recover datafile $num;
exit
done

Thanks & Regards,
Vinod Sadanandan
Oracle DBA

[numberwhun]

Hi,

Can anyone help me on the error message ? ; -)
recover.sh: line 18: syntax error: unexpected end of file
=============== =============== ====

#!/usr/bin/sh
HostName=`hostname`
LOGDIR=$PWDLE_SID
LOGFILE=$LOGDIR/${MYSID}
num=0
while [$num -lt 10]
do
echo -n $num
num='expr $num+1'
sqlplus /nolog <<EOF
conn / as sysdba
recover datafile $num;
exit
done

Thanks & Regards,
Vinod Sadanandan
Oracle DBA

Well, you have a here document , line 10 above, that tells the script to do all of the commands that follow until you see "EOF" on a line by itself. if that is the case, then you have not met the requirements of the here document. You need to have EOF on a line by itself, I assume, right before the word "exit".

Regards,

Jeff

[Vinod Sadanandan]

Hi Jeff ,

Thanks for the turn around,changed it like this,

funct_get_datafiles(){
#Get the list of datafiles
echo "Getting datafiles list " >> ${DATAFILES}
file_list='{ORACLE_BASE}/sqlplus -s <<EOF
/as sysdba
set heading off  feedback off
select distinct file_id from dba_data_files order by file_id;
exit
EOF'
echo "####### DATE :" 'date'  > ${RECOVER}
for datafile in 'echo $file_list'
do
${ORACLE_BASE}/sqlplus -s <<EOF
/as sysdba
set heading off feedback off
recover datafile ${file_list};
exit
EOF
}

Thanks & Redagrds,
Vinod Sadanandan
Oracle DBA

[numberwhun]

Hi Jeff ,

Thanks for the turn around,changed it like this,

funct_get_datafiles(){
#Get the list of datafiles
echo "Getting datafiles list " >> ${DATAFILES}
file_list='{ORACLE_BASE}/sqlplus -s <<EOF
/as sysdba
set heading off  feedback off
select distinct file_id from dba_data_files order by file_id;
exit
EOF'
echo "####### DATE :" 'date'  > ${RECOVER}
for datafile in 'echo $file_list'
do
${ORACLE_BASE}/sqlplus -s <<EOF
/as sysdba
set heading off feedback off
recover datafile ${file_list};
exit
EOF
}

Thanks & Redagrds,
Vinod Sadanandan
Oracle DBA

Vinod,

I am glad that the solution worked for you. In the future, when you post code to the forums, please remember to place [code] [/code] tags around the code so the moderators don't have to follow up behind you and add them.

Thank you!

Regards,

Jeff