OraFAQ Forum: Linux » how to set cronjob? how can i say my OS to do coldbackup every day at 9pm

Home » Infrastructure » Linux » how to set cronjob? how can i say my OS to do coldbackup every day at 9pm

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

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

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,

Report message to a moderator

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

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

Report message to a moderator

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

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

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

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,

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 07:41:10 CST 2024