OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » export log file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

export log file [message #73117]

Wed, 04 February 2004 09:55

denise
Messages: 64
Registered: November 2000

Member

I regularly run full database export and use LOG=alpha.log� The export messages display on the screen and if I run this as a cron job, it prints out in the mail file for the user. Is there a way to create the LOG file but NOT have it display on the screen or in the mail file?�Thanks very much, Denise.

Report message to a moderator

Re: export log file [message #73119 is a reply to message #73117]

Wed, 04 February 2004 10:27

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

you have to redirect the output to somwhere in the cron.
here i have redirected to /backup

bash-2.03$ crontab -l
# minute
# |  hour
# |  &#124day of month
# |  | | month
# |  | | | day of week 0=sunday
# |  | | | 
##################business systems daily export ####################################
0 19 * * * /backup/exp_kronos > /backup/l/l8 2>&1
0 19 * * * /backup/exphrt > /backup/l/l6 2>&1

Report message to a moderator

Re: export log file [message #73121 is a reply to message #73119]

Thu, 05 February 2004 10:44

denise
Messages: 64
Registered: November 2000

Member

Thanks for your response. What effect would this redirection have:
0 19 * * * /backup/exphrt 2>&1 >/dev/null

I have used this on other jobs and thought that it's effect was to take care of the output. But since I'm learning this on my own I could be misunderstanding something.
Thanks again for your help.

Report message to a moderator

Re: export log file [message #73123 is a reply to message #73121]

Thu, 05 February 2004 11:02

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

u are asking the cron to redirect and write the output messages or session display to the file instead of displaying it in the screen or writing it to the mail file.

Report message to a moderator

Previous Topic:	export to diffrent server with diffrent version
Next Topic:	Import Problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 08 22:00:27 CST 2024