OraFAQ Forum: Backup & Recovery » cron tab entry not succeeding

Home » RDBMS Server » Backup & Recovery » cron tab entry not succeeding

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

cron tab entry not succeeding [message #262227]

Sat, 25 August 2007 08:09

harjinder_k_singh
Messages: 3
Registered: August 2007
Location: .

Junior Member

HI to all,
i m just new to this forum, pl'z help.actually i have tried a lot to automatize my cold back up using the cron,but my database is not getting shut down and also the cron is not executing, i have paste my config,pl'z suggest if anything wrong?

*********************************
[root@grg ~]# crontab -l
59 17 24 8 5 /root/coldbkp.sh
**********************************
[root@grg ~]# cat coldbkp.sh
/root/shut
tar -cvf /dev/st0 /arch/GRG
/root/start
**************************
[root@grg ~]# cat shut
su - oracle
lsnrctl stop
sqlplus /nolog
connect / as sysdba
shutdown immediate
exit
exit
********************************
[root@grg ~]# vi start
su - oracle
lsnrctl start
sqlplus /nolog
connect / as sysdba
startup
exit
*************************

Report message to a moderator

Re: cron tab entry not succeeding [message #262230 is a reply to message #262227]

Sat, 25 August 2007 09:09

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
You should set ORACLE_SID,ORACLE_HOME variable in your coldbkp script.

http://dbataj.blogspot.com/2007/03/coldbackuplinuxscript.html

Regards
Taj

[Updated on: Sat, 25 August 2007 09:09]

Report message to a moderator

Re: cron tab entry not succeeding [message #262474 is a reply to message #262230]

Mon, 27 August 2007 02:43

harjinder_k_singh
Messages: 3
Registered: August 2007
Location: .

Junior Member

ok,Mr. Taj,
2 day i'll try this one as sent by you,
but it's sure the info send by u is very helpfull,
in case of any diff i'll tell u
thanks
harjinder

Report message to a moderator

Re: cron tab entry not succeeding [message #262477 is a reply to message #262474]

Mon, 27 August 2007 02:55

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Don't use IM speak.
It is difficult to read for those that have not english as primary language and it is not professional.

Regards
Michel

Report message to a moderator

Re: cron tab entry not succeeding [message #262586 is a reply to message #262477]

Mon, 27 August 2007 11:35

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Did you create you script as a user ORACLE? check ownership and permissions.

Report message to a moderator

Re: cron tab entry not succeeding [message #263103 is a reply to message #262586]

Wed, 29 August 2007 01:38

harjinder_k_singh
Messages: 3
Registered: August 2007
Location: .

Junior Member

hi,
i have made the script,
but the funda of prompt, i m not getting
one more thing, the i m taking the backup at tape
and this should run from root user,
only from root u can take the backup,
now how to do this?

Report message to a moderator

Re: cron tab entry not succeeding [message #263216 is a reply to message #263103]

Wed, 29 August 2007 07:24

ahmed123
Messages: 9
Registered: August 2007
Location: india

Junior Member

hii everyone

i took the backup using export dmp files

expdp system/manager directory=dpump dumpfile=expfull.dmp full=y logfile=expfull.log job_name=full_job

i have done some changes...i added one user and done some transactions

when iam importing the database iam getting the modified data
iam not getting the previous database for whcih i hav took the xport
backup..

plz reply

thank in advance

Report message to a moderator