RE: Archive Logs

From: David Barbour <DBarbour_at_connectsouth.com>
Date: Tue, 25 Jul 2000 13:35:49 -0500
Message-Id: <10569.112918@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_01BFF667.27A2FA80
Content-Type: text/plain;

charset="iso-8859-1"

Alter system switch logfile;

David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
dbarbour_at_connectsouth.com

-----Original Message-----
From: Siva_Chintalapati [mailto:Siva_Chintalapati_at_satyam.com] Sent: Tuesday, July 25, 2000 12:48 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Archive Logs

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_01BFF667.27A2FA80
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: Archive Logs</TITLE>

<META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD>

<BODY>
<DIV>Alter system switch logfile; </DIV>
<DIV> </DIV>
David A. Barbour <FONT face=Arial

size=2>Oracle DBA - ConnectSouth</FONT> <BR><FONT face=Arial 
size=2>512-681-9438</FONT> <BR><FONT face=Arial 
size=2>dbarbour_at_connectsouth.com</FONT> </P>

<BLOCKQUOTE>
 <DIV align=left class=OutlookMessageHeader dir=ltr>-----Original Message----- From: Siva_Chintalapati [mailto:Siva_Chintalapati_at_satyam.com] Sent: Tuesday, July 25, 2000 12:48 PM To: Multiple recipients of list ORACLE-L Subject: RE: Archive Logs </DIV>
 Hi, Can U pl say me how to perform Log Switch?? Regards Siva <UL>
 ---------- From:   Eric Lansu[SMTP:eric.lansu_at_quicknet.nl] Reply To:       ORACLE-L_at_fatcity.com Sent:   Tuesday, July 25, 2000 2:09 PM <FONT face="MS Sans Serif"

    size=1>To:</FONT></B> &nbsp;&nbsp;&nbsp; <FONT face="MS Sans Serif" 
    size=1>Multiple recipients of list ORACLE-L</FONT> <BR><B><FONT 
    face="MS Sans Serif" size=1>Subject:</FONT></B>

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 <FONT

    face=Arial size=2>&gt; bharanidharan</FONT> <BR><FONT face=Arial 
    size=2>&gt;</FONT> <BR><FONT face=Arial size=2>&gt; Sajid Iqbal 
    wrote:</FONT> <BR><FONT face=Arial size=2>&gt;</FONT> <BR><FONT face=Arial

size=2>> > 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 <FONT face=Arial

    size=2>--------------------------------------------------------------------</FONT>

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 <FONT face=Arial Received on Tue Jul 25 2000 - 13:35:49 CDT