Re: Hot backup

In article <4f7ia6$1f6_at_brickbat.mindspring.com> dmcbride_at_atl.mindspring.com (David B. McBride) writes:
>Path: amc!uva.nl!sun4nl!EU.net!howland.reston.ans.net!newsfeed.internetmci.com!in2.uu.net!news.mindspring.com!usenet
>From: dmcbride_at_atl.mindspring.com (David B. McBride)
>Newsgroups: comp.databases.oracle
>Subject: Re: Hot backup
>Date: Tue, 06 Feb 1996 12:48:31 GMT
>Organization: MindSpring Enterprises, Inc.
>Lines: 43
>Message-ID: <4f7ia6$1f6_at_brickbat.mindspring.com>
>References: <4ec8pj$5g3_at_news.nyc.pipeline.com> <4el6uf$1uc_001_at_sysadmpc.dex.com>
>Reply-To: dmcbride_at_atl.mindspring.com
>NNTP-Posting-Host: dmcbride.mindspring.com
>X-Newsreader: Forte Free Agent 1.0.82

>I just recovered a database that was saved while 'HOT'. I do not
>think that having the database in backup mode causes significant
>increase in recovery time. I believe activity on the database during
>the backup will have a bigger impact. Rember that to backup HOT, you
>must be running in archivelog mode. You will need to roll the archive
>logs forward. You will need all the archive logs from the time the
>hot backup was taken to the time you want to recover the database up
>to. The more logs, the more time to recover.
 

>Hope this helps,
>David
 

>lsnyder_at_mail.dex.com (Lowell R. Snyder Jr.) wrote:
 

>>In article <4ec8pj$5g3_at_news.nyc.pipeline.com>,
>> Sameer Utrankar <utrankar_at_nyc.pipeline.com> wrote:
>>>Usual examples of Hot backup scripts are :
>>>
>>>Alter tablespace1 begin backup
>>>backup tablespace1
>>>alter tablespace1 end backup
>>>
>>>alter tablespace2 begin backup
>>>..
>>>and so on ?
>>>
>>>It is a lot easier to setup and manage a script which does begin backup
>>>on all tablespaces, backups all and then does end backup on all of them.
>>>What is the problem in doing so ? Any downside ?
>>>
 

>>My understanding is that if you crash the system during this type of backup,
>>then recovery will take longer (since there are more datafiles that will need
>>recovery).
 

>>-------------------------------------------------------------------
>>Lowell R. Snyder, Jr. Lord Einar Sclater of Orkney
>>Network Manager Kingdom of Caid
>>Data Exchange Corp. Society for Creative Anachronism
>>lowells_at_dex.com einar_at_dex.com
Received on Wed Feb 07 1996 - 00:00:00 CET