Scheduling Oracle Export II - For Victor

[Adrian Sobers2]

Victor,

I scheduled the Oracle export and it seemed to run fine. Created the file with correct day/month stamp in the correct location.

However I checked the export.log file and saw some strange things at the beginning. I think you were mentioning them towards the end of the original thread.

I've attached all the log files resulting from the export to this message for you to review ok.

[Victor BERRIDGE · Accepted solution]

Hi Adrian,
Sorry coulnt read before, was on a server crash issue...

Well it seemed to work fine, the strange thing at the beginning was what I already mentionned in a previous mail but I will explain for you will have to see what is generating it:
when you connect yourself to the server you are in interactive mode so you have a tty port of some sort dedicated to your session
when you type on a box who -uA you will see them...
But as cron is NOT interactive it cannot use the settings that it encounters like stty business and so complains..
You will have to see and modify the .profile of oracle since you do a su - and inherit oracle environment.
Like I suggested modify first using my previous reply on the subject /etc/profile
this will correct the problem unless oracle in its .profile sets a terminal such as vt100...
you may have in oracle's .profile something like:

# Set up the terminal:
if tty -s; then
if [ "$TERM" = "" ]
then
eval ` tset -s -Q -m ':?hp' `
else
eval ` tset -s -Q `
fi
stty erase "^H" kill "^U" intr "^C" eof "^D"
stty hupcl ixon ixoff
tabs
fi

----
Here I added a test:
if tty -s; then # this tests if interactive session!
..

fi
---
So do the same if you see a stanza alike
or if you see a line like:
export TERM=vt100


---

Good luck
All the best
Victor

[Victor BERRIDGE]

As you ave noticed also
It generates 2 other logs
export.done giving you the day time of the export done
export.err wich is empty when all's fine
so you will only have to look if this file is greater than 0 to know you had some trouble with the export and are to edit the export.log to find out why


All the best
Victor

[Victor BERRIDGE]

Just thoughts Adrian,
If you want to be fool proof with an oracle export
modify your oracle script that does the export by adding extra lines at the end to copy in the same directory where lies the export file, all the control files and the redologs
e.g. (As I dont know where you files are... an example but they may look like namewise...)

cd /var/export
cp -p /data/mnt1/oradata/POPA/ctrl1IRDS.ctl .
cp -p /data/mnt2/oradata/POPA/ctrl2IRDS.ctl .
cp -p /data/mnt3/oradata/POPA/ctrl3IRDS.ctl .

cp -p /data/mnt2/oradata/POPA/redoIRDS01.log .
cp -p /data/mnt2/oradata/POPA/redoIRDS02.log .
cp -p /data/mnt2/oradata/POPA/redoIRDS03.log .

I always managed to sort myself out with a good full export of all and with these files copied at the time of the export.

All the best
Victor