RE: Archive Logs

From: Siva_Chintalapati <Siva_Chintalapati_at_satyam.com>
Date: Tue, 25 Jul 2000 22:09:05 +0530
Message-Id: <10569.112902@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFF656.D0576440
Content-Type: text/plain

Hi,
Can U pl say me how to perform Log Switch??

Regards
Siva

> ----------
> From: Eric Lansu[SMTP:eric.lansu_at_quicknet.nl]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Tuesday, July 25, 2000 2:09 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Archive Logs
>
>
> When backup starts, I perform a log-switch, and copy all archive log-files
> to a 'yesterday' directory.
> After the HOT-backup is completed, I perform another log-switch, and
> backup
> all archive-logs to tape as well.
> Next day the 'yesterday' directory is cleaned, and the process starts
> again.
> The archive log-directory is on a seperate disk on a little-used
> controller.
> This way I'm independent of disk-storage from other applications. The
> database really stops on archive-disk full!
>
> Eric Lansu
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, 25 July 2000 07:58
>
>
> > hi,
> > These archive log files are useful to recover the data inbetween a
> cold
> > or a hot backup. i.e. data lost inbetween backups and if it is not
> stored
> > anywhere. also if u r regularly taking any one of these backup then
> there
> > is no need for the prevoius archive logs. Archvie logs file destination
> > should not be full, b'cos ur entire database hangs since it cannot write
> > into it.
> > rgds
> > bharanidharan
> >
> > Sajid Iqbal wrote:
> >
> > > Hello All
> > >
> > > Our 24x7 database is in archive log mode, we do online backups to tape
> > > every other day..
> > >
> > > However the archive logs (which there are a lot of) we only back them
> up
> > > when the destination dir is almost full.
> > >
> > > My question is how often should we backup these archive logs.. also
> how
> > > long to keep these archive logs on tape.. before they are of no use ?
> > >
> > > Regards
> > >
> > > Saj Iqbal
> > >
> > > --
> > > U-NET Ltd a VIA NET.WORKS Inc company
> > > Sajid Iqbal | Mail : sajid_at_u-net.net
> > > Database DBA/Developer | Ext : 4485
> > > U-NET Ltd | ICQ : 43903417
> > > Warrington, Cheshire, UK |
> > >
> > > --
> > > Author: Sajid Iqbal
> > > INET: sajid_at_u-net.net
>
>
> --
> Author: Eric Lansu
> INET: eric.lansu_at_quicknet.nl
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

------_=_NextPart_001_01BFF656.D0576440
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>RE: Archive Logs</TITLE>
</HEAD>
<BODY>

Hi, Can U pl say me how = to perform Log Switch??

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Regards</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Siva</FONT>
</P>
<BR>
<UL>
<P><FONT SIZE=3D1 FACE=3D"MS Sans Serif">----------</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">From:</FONT></B> &nbsp; =
<FONT SIZE=3D1 FACE=3D"MS Sans Serif">Eric =

Lansu[SMTP:eric.lansu_at_quicknet.nl] Reply To: =       ORACLE-L_at_fatcity.com
 Sent:   = Tuesday, July 25, 2000 2:09 = PM
 To: =     Multiple = recipients of list ORACLE-L
 Subject: =        Re: Archive Logs

When backup starts, I perform a = log-switch, and copy all archive log-files to a 'yesterday' directory. After the HOT-backup is completed, I = perform another log-switch, and backup all archive-logs to tape as = well.
 Next day the 'yesterday' directory is = cleaned, and the process starts again. The archive log-directory is on a = seperate disk on a little-used controller. This way I'm independent of = disk-storage from other applications. The database really stops on archive-disk = full!

Eric Lansu

----- Original Message ----- To: "Multiple recipients of list = ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, 25 July 2000 = 07:58

> hi, >    These archive = log files are useful to recover the data inbetween a cold

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; or a hot backup. i.e. data lost =
inbetween backups and if it is not&nbsp; stored</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; anywhere.&nbsp;&nbsp; also if u =

r regularly taking any one of these backup then there > is no need for the = prevoius  archive logs. Archvie logs file destination > should not be full, b'cos ur = entire database hangs since it cannot write

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; into it.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; rgds</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; bharanidharan</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Sajid Iqbal wrote:</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; Hello All</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; Our 24x7 database is in =

archive log mode, we do online backups to tape

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; every other day..</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; However the archive logs =

(which there are a lot of) we only back them up > > when the destination dir is = almost full.
 > > > > My question is how often = should we backup these archive logs.. also how > > long to keep these archive = logs on tape.. before they are of no use ?

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; Regards</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; Saj Iqbal</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; --</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; U-NET Ltd&nbsp; a VIA =

NET.WORKS Inc company
 > > Sajid = Iqbal           &= nbsp;        | Mail : = sajid_at_u-net.net
 > > Database = DBA/Developer         | = Ext  : 4485

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; U-NET =
Ltd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | ICQ&nbsp; : =

43903417

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; Warrington, Cheshire, =
UK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; --</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; Author: Sajid Iqbal</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt;&nbsp;&nbsp; INET: =

sajid_at_u-net.net

<P><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Author: Eric Lansu</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; INET: =

eric.lansu_at_quicknet.nl

Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
 San Diego, = California        -- Public Internet = access / Mailing Lists
 <FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=

-----------
 To REMOVE yourself from this mailing = list, send an E-Mail message
 to: ListGuru_at_fatcity.com (note EXACT = spelling of 'ListGuru') and in
 the message BODY, include a line = containing: UNSUB ORACLE-L
 (or the name of mailing list you want = Received on Tue Jul 25 2000 - 11:39:05 CDT