RE: Online Redo Log During a Hot Backup

Basically not a problem.

Hotbackup is independent of the redo logs being archived. * Of course make sure you have archiving functioning properly

Note: Manually switch all the logs before and after the hotbackup so you have clean cut off points.

The archivelogs that were produced during the backup should be considered as part of the backup as they would be required for recovery with that backup.

You should really understand the fundamentals of hotbackup and archiving before designing a recovery solution (My safety suggestion).

There are many hotbackup explanations on many oracle user sites now.

Brian

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