seems like a safe solution... (?)
- manually switch the log, and make a note of the seq. no
- take a hot backup of all the tbs
- delete all logs prior to the seq. no above
> ----------
> From: Mouloudi, Saad[SMTP:Saad.Mouloudi_at_compaq.com ]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Wednesday, January 24, 2001 12:00 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: will log be generated during hot backup ?
>=20
>=20
> If you have not enough space to keep all your archive logs then=20
> you can delete some of them
> =20
> - look at the sequence number of the current archive log before=20
> starting the backup=20
> svrmgrl> archive log list
>=20
> - After your backup is finished delete all the archive logs=20
> that are generated before the begining of the backup ( keep archive =
logs
> that have bigger or equal sequence numbers than the number=20
> you saw befor the backup)=20
> =20
>=20
>=20
>=20
> regards,
> saad
>=20
>=20
> > -----Message d'origine-----
> > De: Joseph S. Testa [mailto:teci_at_oracle-dba.com]
> > Date: mardi 23 janvier 2001 14:00
> > =C0: Multiple recipients of list ORACLE-L
> > Objet: Re: will log be generated during hot backup ?
> >=20
> >=20
> > you keep them all, oracle sorts out what it needs and what it dont.
> >=20
> > joe
> > Rahul wrote:
> > >=20
> > > List,
> > > will log generation (and archiving) continues during the backup =
of a
> > > tablespace ?
> > > if yes, then how will identify which logs to delete/keep=20
> > after finish my hot
> > > backup ?
> > >=20
> > > regards
> > > rahul sharma
> > >=20
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Rahul
> > > INET: rahul_at_ratelindo.co.id
> > >=20
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) =
538-5051
> > > San Diego, California -- Public Internet access /=20
> > 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).
> >=20
> > --=20
> > Joe Testa http://www.oracle-dba.com
> > Performing Remote DBA Services, need some backup DBA support?
> > For Sale: Oracle-dba.com domain, its not going cheap but feel free =
to
> > ask :)
> > --=20
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --=20
> > Author: Joseph S. Testa
> > INET: teci_at_oracle-dba.com
> >=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
> > also send the HELP command for other information (like =
subscribing).
> >=20
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: Mouloudi, Saad
> INET: Saad.Mouloudi_at_compaq.com
>=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 Jan 23 2001 - 22:19:44 CST
