[SunHELP] RE: [SunHELP] Re: [SunHELP] ¿How to Backup? (I don't find /dev/rmt directory)

Wadi Achmed sunhelp at sunhelp.org
Tue Jul 17 02:14:53 CDT 2001


--------------5444960F4B4278C59DE87919
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

I have some scripts to handle Oracle database

for Shutdown Oracle:
lsnrctl stop
svrmgrl << EOF
connect internal
shutdown immediate
exit
EOF

backup.sh:
tar c $HOME/oradata

for startup.sh:
svrmgrl << EOF
connect internal
startup
exit
lsnrctl start
EOF

With those scripts, how can I create a cron jobs?
Would you like to tell me step by step. FYI my server Solaris 2.6

Thanks in advance.

Cheers,
Wadi Achmed

Ravi_Thotapalli at csaa.com wrote:

> You have to setup Cron jobs to execute at the time and day you want
> (expecting that you want to run these jobs at the same time every day and
> week) the backups to take place.
>
> ravi
>
> -----Original Message-----
> From: Wadi Achmed [mailto:wadiachmed at ludlow.co.id]
> Sent: Wednesday, July 11, 2001 7:57 PM
> To: sunhelp at sunhelp.org
> Subject: Re: [SunHELP] Re: [SunHELP] How to Backup? (I don't find
> /dev/rmt directory)
>
> Hi,
>
> How if I want to backup with scheduled period?
> I am using Oracle database 7.3.4
> I would like to backup my database "hot" and "cold" condition. Hot
> backup means while the database is being used the backup is running and
> Cold means while the database is shutdowned then the backup is started.
>
> Thanks.
>
> Cheers,
> Wadi Achmed

--------------5444960F4B4278C59DE87919
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
I have some scripts to handle Oracle database
<p>for Shutdown Oracle:
<br><font face="Courier New,Courier"><font size=-1>lsnrctl stop</font></font>
<br><font face="Courier New,Courier"><font size=-1>svrmgrl << EOF</font></font>
<br><font face="Courier New,Courier"><font size=-1>connect internal</font></font>
<br><font face="Courier New,Courier"><font size=-1>shutdown immediate</font></font>
<br><font face="Courier New,Courier"><font size=-1>exit</font></font>
<br><font face="Courier New,Courier"><font size=-1>EOF</font></font>
<p>backup.sh:
<br><font face="Courier New,Courier"><font size=-1>tar c $HOME/oradata</font></font>
<p>for startup.sh:
<br><font face="Courier New,Courier"><font size=-1>svrmgrl << EOF</font></font>
<br><font face="Courier New,Courier"><font size=-1>connect internal</font></font>
<br><font face="Courier New,Courier"><font size=-1>startup</font></font>
<br><font face="Courier New,Courier"><font size=-1>exit</font></font>
<br><font face="Courier New,Courier"><font size=-1>lsnrctl start</font></font>
<br><font face="Courier New,Courier"><font size=-1>EOF</font></font>
<p>With those scripts, how can I create a cron jobs?
<br>Would you like to tell me step by step. FYI my server Solaris 2.6
<p>Thanks in advance.
<p>Cheers,
<br>Wadi Achmed
<p>Ravi_Thotapalli at csaa.com wrote:
<blockquote TYPE=CITE>You have to setup Cron jobs to execute at the time
and day you want
<br>(expecting that you want to run these jobs at the same time every day
and
<br>week) the backups to take place.
<p>ravi
<p>-----Original Message-----
<br>From: Wadi Achmed [<a href="mailto:wadiachmed at ludlow.co.id">mailto:wadiachmed at ludlow.co.id</a>]
<br>Sent: Wednesday, July 11, 2001 7:57 PM
<br>To: sunhelp at sunhelp.org
<br>Subject: Re: [SunHELP] Re: [SunHELP] ¿How to Backup? (I don't
find
<br>/dev/rmt directory)
<p>Hi,
<p>How if I want to backup with scheduled period?
<br>I am using Oracle database 7.3.4
<br>I would like to backup my database "hot" and "cold" condition. Hot
<br>backup means while the database is being used the backup is running
and
<br>Cold means while the database is shutdowned then the backup is started.
<p>Thanks.
<p>Cheers,
<br>Wadi Achmed</blockquote>
</html>

--------------5444960F4B4278C59DE87919--





More information about the SunHELP mailing list