RE: Online Redo Log During a Hot Backup

In addition to the other responses...

Just because you are in archivelog mode does not mean you are archiving automatically. Ensure that you have adequate space in your archive log destination(s) and make you have automatic archiving enabled...unless you would like to sit that there and manually archive every redo log.

chris

-----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 5: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
--
http://www.freelists.org/webpage/oracle-l