RE: Online Redo Log During a Hot Backup

Page 68 and 69 of Velpuri's "Backup and Recovery Handbook" gives a good explanation of what goes on internally when tablespaces are in hot backup mode. If you are in archivelog mode and you are automatically archiving your log files, you don't have anything to worry about. Hot backup mode just increases redo activity. Redo logs are still archived during a hot backup.
Is the "2-3 hours" for a tape backup of your system? Or is it a script that backs up your database by putting each tablespace in backup mode?

Jay=20

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of aamgm service Sent: Wednesday, September 22, 2004 6:42 AM To: 'oracle-l_at_freelists.org'
Subject: Online Redo Log During a Hot Backup

Dear Gurus,

I have been running my database in noarchive mode and I want to switch to Archivelog mode. I am running Oracle 7.3.4. I have three groups of redo logs that are 20MB each.=20
My question is what happens to filled online redo logs during a hot/online backup?? My fear is my database could hang when all redo logs fill up before my backup completes because it usually takes 2-3 hours (backup) to complete?
and my log switches occur in 15-20 mins.

TIA
Regards
=20

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.742 / Virus Database: 495 - Release Date: 2004-08-19


=20

--
http://www.freelists.org/webpage/oracle-l





**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the =
use of the individual or entity to which they are addressed and may contain=
 information that is privileged, proprietary and confidential. If you are n=
ot the intended recipient, you may not use, copy or disclose to anyone the =
message or any information contained in the message. If you have received t=
his communication in error, please notify the sender and delete this e-mail=
 message. The contents do not represent the opinion of D&E except to the ex=
tent that it relates to their official business.
--
http://www.freelists.org/webpage/oracle-l