Home » RDBMS Server » Backup & Recovery » cron tab entry not succeeding
cron tab entry not succeeding [message #262227] Sat, 25 August 2007 08:09 Go to next message
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
*************************

Re: cron tab entry not succeeding [message #262230 is a reply to message #262227] Sat, 25 August 2007 09:09 Go to previous messageGo to next message
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

icon7.gif  Re: cron tab entry not succeeding [message #262474 is a reply to message #262230] Mon, 27 August 2007 02:43 Go to previous messageGo to next message
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
Re: cron tab entry not succeeding [message #262477 is a reply to message #262474] Mon, 27 August 2007 02:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: cron tab entry not succeeding [message #262586 is a reply to message #262477] Mon, 27 August 2007 11:35 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Did you create you script as a user ORACLE? check ownership and permissions.
icon7.gif  Re: cron tab entry not succeeding [message #263103 is a reply to message #262586] Wed, 29 August 2007 01:38 Go to previous messageGo to next message
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?
Re: cron tab entry not succeeding [message #263216 is a reply to message #263103] Wed, 29 August 2007 07:24 Go to previous messageGo to next message
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
Re: cron tab entry not succeeding [message #263302 is a reply to message #263216] Wed, 29 August 2007 11:14 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Can you show us..???

what script you use for import / export.
Re: cron tab entry not succeeding [message #263318 is a reply to message #263216] Wed, 29 August 2007 12:54 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
ahmed123 wrote on Wed, 29 August 2007 06:24
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



You will have the only old data.IMP/EXP read write sequentially.
Previous Topic: catalog
Next Topic: Let me provide coding of shell script for Back the database dynamically
Goto Forum:
  


Current Time: Thu Dec 08 18:33:46 CST 2016

Total time taken to generate the page: 0.10697 seconds