Re: Cold backup!?

Sybrand Bakker wrote:

> 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!
> >

Thanks! Received on Sat Sep 04 1999 - 13:28:07 CDT