REPOST: Re: Given the choice: hot or cold?

In article <UY2X7.1631$ju5.193797_at_news.uswest.net>, dsmcd says...
>
>Hello...
>
>Thinking about using Backup Exec Oracle Agent to backup Oracle 817 on
>Win2k-Serv when no one's connected. In this scenerio, and with this
>software, would hot or cold backups be preferrable?
>
>Thx,
>D.
>

since you have the choice, you must be in archive log mode and since you are in archive log mode, there is no reason to shutdown, lose all of the buffered data you worked so hard to get buffered, wipe out the shared pool -- just to start all over again.

go hot.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp 

========= WAS CANCELLED BY =======:
Path: news.sol.net!spool0-nwblwi.newsops.execpc.com!newsfeeds.sol.net!news-out.visi.com!hermes.visi.com!uunet!ash.uu.net!sac.uu.net!lax.uu.net!news.navix.net!u-n-c-a-n-c-e-l-l-e-r
From: Thomas Kyte <tkyte_at_us.oracle.com>
Newsgroups: alt.config,comp.lang.c,comp.databases.oracle.server
Subject: cmsg cancel <a0ipgd014or_at_drn.newsguy.com>
Control: cancel <a0ipgd014or_at_drn.newsguy.com>
Date: Mon, 31 Dec 2001 07:21:26 GMT
Organization: Navix Internet Subscribers
Lines: 2
Message-ID: <cancel.a0ipgd014or_at_drn.newsguy.com>
NNTP-Posting-Host: 166.102.15.34
X-Trace: iac5.navix.net 1009790016 28060 166.102.15.34 (31 Dec 2001 09:13:36 GMT)
X-Complaints-To: abuse_at_navix.net
NNTP-Posting-Date: 31 Dec 2001 09:13:36 GMT
X-No-Archive: yes
Comment: Anarchy! Fuck You!
X-Commentary: I love NewsAgent 1.10, Sandblaster Build 74 (19 March 1999) and the Polaris Cancel Engine V. 6.1
X-Unacanc3l: yes

This message was cancelled from within Mozilla...not