RE: Online Redo Log During a Hot Backup
- From: "Spears, Brian" <BSpears@xxxxxxxxxxxxxxxxx>
- To: <aamgms@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 22 Sep 2004 16:28:48 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of aamgm service
Sent: Wednesday, September 22, 2004 6:42 AM
To: 'oracle-l@xxxxxxxxxxxxx'
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
