Re: quick hot backup question...

From: daniel <test_at_test.com>
Date: Mon, 25 Mar 2002 21:24:34 -0000
Message-ID: <a7o4db$v8$1@news5.svr.pol.co.uk>

i force a log switch after i have copied all the df's, thus ensuring all changes during the file copies are in archive redo and not just online redo.

i use the statement;

alter system archive log current;

--
Regards,

Daniel.


"Glen A Stromquist" <gstromquist_at_nospamyahoo.com> wrote in message
news:jpMn8.11561$EV.366849_at_news1.telusplanet.net...


> In my online backup scripts I don't do a logfile switch or force a

> checkpoint before copying the datafiles.

>

> Is this  recommended by Oracle?

>

> I'm wondering if I overlooked something when writing my scripts, I have

used


> my online backups on occasion to create a clone db, so I know they "work"

> the way I'm doing it now, but I guess  it can't hurt to build in a logfile

> switch and/or force a checkpoint as part of the script as well.

>

> Curious to hear what others do regarding this....

>

>

> cheers!

>

>

Received on Mon Mar 25 2002 - 15:24:34 CST