Message-Id: <10569.112902@fatcity.com> From: Siva_Chintalapati Date: Tue, 25 Jul 2000 22:09:05 +0530 Subject: RE: Archive Logs 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@quicknet.nl] > Reply To: ORACLE-L@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" > 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@u-net.net > > > Database DBA/Developer | Ext : 4485 > > > U-NET Ltd | ICQ : 43903417 > > > Warrington, Cheshire, UK | > > > > > > -- > > > Author: Sajid Iqbal > > > INET: sajid@u-net.net > > > -- > Author: Eric Lansu > INET: eric.lansu@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@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 RE: Archive Logs

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

Regards
Siva