Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: different ways of archiving current redo log

Re: different ways of archiving current redo log

From: Prem K Mehrotra <premmehrotra_at_hotmail.com>
Date: 24 Mar 2004 07:04:26 -0800
Message-ID: <43441e77.0403240704.71887b32@posting.google.com>


Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<4k2160t2lnakhr2maob5odr8cb3v7iontb_at_4ax.com>...
> On 23 Mar 2004 10:48:47 -0800, premmehrotra_at_hotmail.com (Prem K
> Mehrotra) wrote:
>
> >I have seen different ways of archiving logs and want to clarify their
> >usage:
> >
> >1. alter system switch logfile
> >
> >Does this command really archives current redo log before switch, or
> >it simply switches and archiving is done later in background
> >(asynchronus manner)
>
> will switch the logfile and archive the previous log file when
> necessary. So possible consecutive operation, which is not the same as
> asynchronous.
>
> >
> >2. alter system archive log current:
> >I will think this command will actually archive the current log and
> >then only swtch to next log, i.e, archiving and next log are
> >synchronus operations.
>
> Will archive the current log *when necessary*. It will NOT switch the
> log.
> May do nothing, when the log doesn't need archiving.
> >
> >3. alter system archive log all:
> >This command will archive all filled redo logs but will not complete
> >current log because it will not be full.
> >
> >
> Will archive all logs *that need archiving*.
> May do nothing
>
>
> >Thanks,
> >
> >Prem

Regarding 2, when you say it will not switch log, do you mean after archiving same redo log will be used. I have not seen that using archive log list command. Received on Wed Mar 24 2004 - 09:04:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US