Re: Cold backup!?

Note, however, that when you recover and try to restart, Oracle will need Redo Log files to exist, as specified in the control files. If you don't back them up, you may be able to create new ones and edit your control file to point to them. But you're far better off backing up the online logs with you data and control files.

Yosi

Mikel wrote:

> Correct, online redo files are only used in instance recovery, not media
> recovery, therefore they are not required for a cold backup. To ensure
> you've captured all the online redo prior to the cold backup (shutting down
> the db of course before the cold backup), do the following
>
> shutdown abort
> startup restrict
> alter system switch LOGFILE
> shutdown normal
>
> Mike
>
> terry norman <scott_at_tiger9.freeserve.co.uk> wrote in message
> news:7qsame$8fv$1_at_news6.svr.pol.co.uk...
> > 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 Fri Sep 17 1999 - 11:10:31 CDT