Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: backup online redo log file during a hot backup
On Jun 22, 1:04 pm, Massa Batheli <mng..._at_gmail.com> wrote:
> On Jun 22, 1:50 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
>
>
>
>
>
> > On Jun 22, 12:00 pm, Massa Batheli <mng..._at_gmail.com> wrote:
>
> > > This might seem out of place to those who have religiously not been
> > > backing up online redo log files but unfortunately some of us have
> > > been doing that.
> > > Question out of ignorance
>
> > > If you do not back them up would they be recreated from the archived
> > > redo log files when the files are restored and the database started /
> > > recovered?...
>
> > > Thanks for your response as usual
>
> > > Massa
>
> > The active redo log is not, I repeat not, archived unless you
> > explicitly do so with 'alter system archive log current;' at which
> > time it's no longer active, therefore if you lose this you may have
> > lost vital information necessary for instance recovery; you WILL have
> > lost the ability of Oracle to function. Active redo logs cannot be
> > 'recreated' from any archived copy of the redo logs. You really need
> > to read this:
>
> >http://download-west.oracle.com/docs/cd/B19306_01/backup.102/b14191/r...
>
> > before you go any further.
>
> > David Fitzjarrell
>
> David
> Thanks for your very fast reply
>
> But that was not the point of the question.The point was do you have
> to make a copy of the online redo log files as well
> as the datafiles during a backup or the redo log files(not archived
> redo log files are left out) ?If they are omitted would the database
> come up OK
>
> Massa- Hide quoted text -
>
> - Show quoted text -
You would have an incomplete recovery and an 'alter database open resetlogs;' would create new redo logs. And that was not the same question posed in your original post.
David Fitzjarrell Received on Fri Jun 22 2007 - 13:40:44 CDT