RE: Online Redo Log During a Hot Backup
- From: aamgm service <aamgms@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 23 Sep 2004 07:18:32 +0200
the 2-3 hours is a tape backup of a 80GB database. My confusion was that,
Oracle will ONLY archive checkpointed online redo logs and since
"checkpointing" online redo logs is suspended when a database is in backup
mode then filled online redos are not archived!
1. So how the does oracle apply changes made during the hot backup when the
redo logs have been archived?
2. What is the recommended procedure of taking the database in backup up
mode, I mean put all tablespaces in backup mode at once or one tablespace at
a time?
Thank you Gurus for all the explanations
Regards
> -----Original Message-----
> From: Hostetter, Jay M [SMTP:JHostetter@xxxxxxxxxxxxxxxxxxxx]
> Sent: Wednesday, September 22, 2004 2:25 PM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: 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@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
>
> ---
> Incoming 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
>
>
---
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
