Re: Cold backup!?

I'm fairly new to Oracle and I'm very confused about this one. Somewhere in the literature I am sure I have read that online redo log files should not be backed up because, and I quote "they add no value to the recovery process". If we're in a cold backup situation following a shutdown immediate or shutdown normal is there actually anything in the online redo files which is needed for recovery?

Regards,
Terry.

Sybrand Bakker <postmaster_at_sybrandb.demon.nl> wrote in message news:936479684.18712.0.pluto.d4ee154e_at_news.demon.nl...
> 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:36:07 CDT