REPOST: Re: (more) Given the choice: hot or cold?

In article <oSaX7.2057$ju5.445105_at_news.uswest.net>, dsmcd says...
>
>
>>You will not be able to do a point in time recovery from an o/s-level
>>(ie,
>>cold) backup. There would be no point. It doesn't make sense.
>
>Sorry, I wasn't clear. I am duplexing my archived redo logs. One set is
>on a different pair of mirrored drives than where the tablespaces live.
>Same for the control files. *Assuming* a failure between backups, and
>*assuming* I could retrieve one good set of redo logs and a good
>control file, I should be able to restore the tablespaces from cold
>backup and then use the good control file and running the good redo
>logs from that point forward, getting me to the point of failure.
>Correct?
>

yes.
as long as you are in archive log mode and have all of the logs since the last backup. It is a good practice indeed to keep at LEAST two or three backups and all needed logs.

>
>>Archivelog mode is critical (required) for a hot-backup, so I would
>>say that
>>they do, in fact, come into play.
>
>Yes, archivelog mode is required for hot, but does not rule out cold,
>correct?
>

correct -- but doing HOT is not any harder then cold really (for some reason it "sounds scarier" to people but its not). You need to go through the same steps during a recovery regardless of hot or cold.

>>Sign up for the Oracle Technology Network at http://otn.oracle.com and
>>then
>>read this document:
>
>Definately will. Thanks.
>
>Thanks for your help. I appreciate it...
>D.
>

--
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!spool1-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 <a0kst202k0t_at_drn.newsguy.com>
Control: cancel <a0kst202k0t_at_drn.newsguy.com>
Date: Mon, 31 Dec 2001 08:25:25 GMT
Organization: Navix Internet Subscribers
Lines: 2
Message-ID: <cancel.a0kst202k0t_at_drn.newsguy.com>
NNTP-Posting-Host: 166.102.15.34
X-Trace: iac5.navix.net 1009788912 26548 166.102.15.34 (31 Dec 2001 08:55:12 GMT)
X-Complaints-To: abuse_at_navix.net
NNTP-Posting-Date: 31 Dec 2001 08:55:12 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