Home » Infrastructure » Linux » how to set cronjob? how can i say my OS to do coldbackup every day at 9pm
how to set cronjob? how can i say my OS to do coldbackup every day at 9pm [message #217931] Tue, 06 February 2007 02:48 Go to next message
pavan27
Messages: 50
Registered: December 2006
Location: bangalore
Member
Hi to every one,

i need some informatin about setup cronjob in linux.

means i have a backup script(.sh) file. i want to tell my OS to go for backup every day at 9 pm. how to write shell script/or any one have secitpt please send me. bcos i am new to oracle dba/linux. please give step/step process...

thanks,
Re: how to set cronjob? how can i say my OS to do coldbackup every day at 9pm [message #217942 is a reply to message #217931] Tue, 06 February 2007 03:08 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Which type of backup you want to schedule ( cold or hot)
and what you did so far ?

regards
Taj
Re: how to set cronjob? how can i say my OS to do coldbackup every day at 9pm [message #217996 is a reply to message #217931] Tue, 06 February 2007 05:47 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Search before posting. These questions are answered many many times before
http://www.adminschoice.com/docs/crontab.htm
Re: how to set cronjob? how can i say my OS to do coldbackup every day at 9pm [message #218009 is a reply to message #217996] Tue, 06 February 2007 06:27 Go to previous messageGo to next message
pavan27
Messages: 50
Registered: December 2006
Location: bangalore
Member
Hi taj,

i need to set both hot backup/ cold backup. please can you help to me sort out the issue. and also thanks to Rajendran to send one link.

thanks,
Re: how to set cronjob? how can i say my OS to do coldbackup every day at 9pm [message #218013 is a reply to message #218009] Tue, 06 February 2007 06:56 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
I will guide you but i am not give you complete solution.
first try yourself if you receive any error and concern with us.

Cold Backup Script.
1.Shutdown immediate + normal ( database your database)
2.copy all *.ctl , *.dbf, *.log or spfile and password.
3.startup ( startup your database for normal operation).

for above you have to create .sh ( shell script)
through chmod grant read , write and execute permission to OS user.
Schedule ".sh" script through CRONTAB utility.

-----------------------------------------------------
Hot backup through USER MANAGED BACKUP.
alter tablespace begin backup ....COPY......end backup.
backup your *.arc log files.
For Control file.
alter database backup control file to trace;
or
alter database backup control file to 'OS PATH';
for above some create ".sh" file and grant permission.
---------------------------------------------------------
Hot backup through RMAN tool.

http://download-uk.oracle.com/docs/cd/B14117_01/server.101/b10734/toc.htm

----------------------------------------------------------

Go through below link http://dbataj.blogspot.com/search/label/Backup%20Scripts

above script based on WINDOWS but for overview you can take a look.


regards
Taj
Re: how to set cronjob? how can i say my OS to do coldbackup every day at 9pm [message #218035 is a reply to message #218013] Tue, 06 February 2007 08:58 Go to previous message
pavan27
Messages: 50
Registered: December 2006
Location: bangalore
Member
thanks Taj, Rajendran.

thanks alot for your help. i will set a cronjob to day if any problems i face i will get back you.

once again thanks

Previous Topic: GRUB loading, please wait... Error 22
Next Topic: Connection Error 12541
Goto Forum:
  


Current Time: Thu Mar 28 14:42:38 CDT 2024