Re: Cold backup!?

No, you are not right. You will be missing out the ONLINE redo logfiles, ie the most current files.
Say you have sequence 1, 2,3,4 archived and 5,6,7,8 online. The controlfile will contain one of the sequence numbers 5,6,7,8. So if you have a crash, and you didn't backup the online redo log files, you will be forced to execute incomplete recovery and loose data. The archived files do not contain duplicates of the files online, they contain files that have been 'phased out'

Hth,

--
Sybrand Bakker, Oracle DBA

Jack Zhu <jackzhu_at_monmouth.com> wrote in message news:37D15108.19DFF36B_at_monmouth.com...
> Oracle runs on ARCHIVELOG mode.
>
> Perform cold backup against this db. Backup files from 'dba_data_files',
> 'v$controlfile', 'v$logfile', and also backup the archived log files
> from 'log_arch_dest'.
>
> But I think if I do the backup for archived log files(log_arch_dest),
> it's unnecessary to do the backup for 'v$logfile'. 'cause from the
> recovery point of view, these backup files(from v$logfile) are useless.
>
> Am I right?
>
> Thanks a lot!
>
Received on Sat Sep 04 1999 - 16:13:57 CDT