Re: Cold backup!?

--
Bob Fazio
Remove no.spam from my email to reply

Mikel <not_at_me.com> wrote in message
news:WLkA3.5257$qY3.194701_at_newscontent-01.sprint.ca...
> 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

Agreed!

>
> shutdown abort

A shutdown immediate would really be better. It allows Oracle to do cleanup that abort won't. In fact,
a shutdown abort will force an instance recovery upon startup. I have always been taught
in all of the Oracle DBA classes that I have attended to only do an abort as a last resort. See the following
excerpt from Oracle's documentation

SHUTDOWN command ::=

where:

ABORT Proceeds with the fastest possible shutdown. Does not wait for calls to complete or users to disconnect. Does not close or dismount the database, but does shut down the instance. Requires instance recovery on next startup. You must use this option if a background process terminates abnormally.

IMMEDIATE Does not wait for current calls to complete, prohibits further connects, and closes and dismounts the database. Finally, shuts down the instance. Does not wait for connected users to disconnect. Does not require instance recovery on next startup.

NORMAL Waits for currently connected users to disconnect from the database, prohibits further connects, and closes and dismounts the database. Finally, shuts down the instance. Does not require instance recovery on next startup. NORMAL is the default option.

> 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 Tue Sep 07 1999 - 18:37:20 CDT