RE: Online Redo Log During a Hot Backup
- From: "Hostetter, Jay M" <JHostetter@xxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 22 Sep 2004 08:24:48 -0400
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@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
**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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
