Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: what is the different?
in our hot backup scripts, we use the "archive log current" syntax to ensure that the current log file is archived. prior to the introduction of this syntax, the script used the "switch logfile", and then waited for several minutes to give ARCH enough time to archive the log file, before continuing.
one place we use the the
"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message
news:3b114c75$0$15030$cc9e4d1f_at_news.dial.pipex.com...
> alter system switch logfile switches between current online redo logs. It
> (should) always work.
>
> alter system archive log current will archive the (current) redo log. It
> thus requires all of the prerequisites for archiving redo logs.
>
> Most likely causes for the second command to fail
>
> 1. you are not in archivelog mode
> 2. you have run out of space in your archive log destination.
>
> The error message in the alert log will tell you what the problem is.
>
> IMO you should also not usually need to issue the second command since
> oracle will quite happily archive redo logs for you automatically.
>
>
> --
>
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "Cheong" <leslie_hk_at_hotmail.com> wrote in message
> news:3b113326_at_newsgate.imsbiz.com...
> > Can anyone tell me what is the different of the following two commands
> >
> > alter system archive log current
> > alter system switch logfile
> >
> > and why the first command always produce and error a message fail to
arhive
> > log ... in alert log file.
> >
> > Thanks in advance
> >
> > Antony
> >
> >
>
>
>
Received on Sun May 27 2001 - 16:10:09 CDT