Path: news.easynews.com!easynews!cyclone2.usenetserver.com!usenetserver.com!newsfeed.icl.net!colt.net!deine.net!fu-berlin.de!uni-berlin.de!isdn0.tvol.IT!not-for-mail From: etechweb@yahoo.com (Sebastiano Pilla) Newsgroups: comp.databases.oracle.server Subject: Re: Quick Tale: Lost production database because of keyboard and Veritas Cluster Server Date: Sun, 3 Mar 2002 15:11:31 +0100 Lines: 20 Message-ID: <1f8h3bf.7vgugmi2t9q8N%etechweb@yahoo.com> References: <90d82e70.0202271308.3056cee3@posting.google.com> <90d82e70.0202281514.4bb55a36@posting.google.com> NNTP-Posting-Host: isdn0.tvol.it (151.99.188.20) X-Trace: fu-berlin.de 1015164654 10494579 151.99.188.20 (16 [1379]) X-Orig-Path: etechweb User-Agent: MacSOUP/2.4.6 Xref: easynews comp.databases.oracle.server:137301 X-Received-Date: Sun, 03 Mar 2002 07:08:50 MST (news.easynews.com) milkfilk wrote: > What is meant by hot backups? We are doing full exports every night > (CONSISTENT keyword enabled), we'll do archive log mode and we'll do > cold file copies every week. Hot backups are backups done with the instance up & running, and serving data as usual. Archivelog mode is a prerequisite for taking hot backups that can be used for recovery. Full exports are useful, but for a different purpose: I like to think of the differences as thinking that exports protect yourself from logical errors (i.e., dropping a table by mistake), while backups protect you from physical errors (i.e. a disk going bad). Have a look at Howard J. Rogers's site at , there's a PDF document on Oracle's backup and recovery very worth a look. Sebastiano Pilla