RE: Online Redo Log During a Hot Backup

Oops didn't see this question had adequate responses... So I will at a tid bit here..

Suggestion 2-3 hours for a backup... Are you backing up 700 gig?

Architecture Backup speed hints..
 Here is a recovery solution idea I like and have used.. Run your hotbackup to disk - much faster backup and restore than to tape. After it has landed to disk...then backup it up to tape later without impacting the DB.=20
Also I compress with Gzip to disk so that the space is often reduced by about 8 times. Then the kicker...
Is do the copying of the datafiles (and compressing) in parallel threads... I backkup a 60gig database in about 5-11 minutes that way.... Of course that depends on factors of your machine and impact on the system.

This is just meant to give you some ideas to pursue if you like them... We did it on a massive system and it works wonders.

My fav trick is to do the poor man time finder hot backup/recovery... Recovery of 1 terabyte database from hotbackup in mintutes.. Anybody out there guess how that is done?

Brian

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Spears, Brian Sent: Wednesday, September 22, 2004 4:29 PM To: aamgms_at_aamines.co.zw; oracle-l_at_freelists.org Subject: 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.=3D20 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
=3D20

---

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 =3D20
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Wed Sep 22 2004 - 15:37:50 CDT