Alter system switch logfile;
Check v$log to see which files are currently being used.
- Kristen Cameron
Indian and Northern Affairs Canada
Yellowknife, NT
>>> Siva_Chintalapati_at_satyam.com 7/25/2000 >>>
Hi,
Can U pl say me how to perform Log Switch??
Regards
Siva
> ----------
> From: Eric Lansu[SMTP:eric.lansu_at_quicknet.nl]=20
> Reply To: ORACLE-L_at_fatcity.com=20
> Sent: Tuesday, July 25, 2000 2:09 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Archive Logs
>=20
>=20
> 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!
>=20
> Eric Lansu
>=20
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, 25 July 2000 07:58
>=20
>=20
> > 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 destinatio=
n
> > 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=20
> > > Database DBA/Developer | Ext : 4485
> > > U-NET Ltd | ICQ : 43903417
> > > Warrington, Cheshire, UK |
> > >
> > > --
> > > Author: Sajid Iqbal
> > > INET: sajid_at_u-net.net=20
>=20
>=20
> --=20
> Author: Eric Lansu
> INET: eric.lansu_at_quicknet.nl=20
>=20
> 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
Received on Tue Jul 25 2000 - 13:51:12 CDT
